Search Results IGS_PS_USEC_RU




Overview
Explore in AI Chat

Overview

The IGS_PS_USEC_RU table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as the central repository for storing and managing business rules associated with specific unit section offerings. In the context of academic administration, a unit section version represents a scheduled instance of a course unit. This table links these offerings to configurable validation and processing rules, enabling institutions to enforce complex academic policies, prerequisites, co-requisites, and other logic at the point of enrollment or academic planning. Its role is critical for maintaining data integrity and automating academic workflows within the Student System.

Key Information Stored

The table's structure is designed to establish relationships between unit offerings and the rules that govern them. The primary identifier is the system-generated USECRU_ID. The key logical columns are UOO_ID, which is the foreign key to a specific unit offering option (IGS_PS_UNIT_OFR_OPT_ALL), and S_RULE_CALL_CD, which identifies the type or point of invocation for the rule (linked to IGS_RU_CALL). The RUL_SEQUENCE_NUMBER column is a foreign key to the IGS_RU_RULE table, which stores the actual rule definition and logic. Together, these columns define which rule, of a specific type, is applied to a given unit section.

Common Use Cases and Queries

A primary use case is validating a student's eligibility to enroll in a particular class section. The system queries this table to find all rules (e.g., prerequisite checks, capacity rules, approval requirements) attached to the section and executes them. For reporting and administrative review, common queries involve listing all rules attached to a set of unit offerings or identifying sections that use a specific rule type. A typical SQL pattern would join this table to the unit offering and rule definition tables:

  • SELECT sec_rule.uoo_id, call.meaning, rule.rule_name FROM igs_ps_usec_ru sec_rule, igs_ru_rule rule, igs_ru_call call WHERE sec_rule.rul_sequence_number = rule.rul_sequence_number AND sec_rule.s_rule_call_cd = call.s_rule_call_cd AND sec_rule.uoo_id = :p_uoo_id;

This retrieves the names and types of all rules configured for a specified unit offering.

Related Objects

The IGS_PS_USEC_RU table maintains defined foreign key relationships with several foundational tables in the Student System, as documented in the ETRM:

  • IGS_PS_UNIT_OFR_OPT_ALL: Related via the UOO_ID column. This is the parent table for unit offering details.
  • IGS_RU_RULE: Related via the RUL_SEQUENCE_NUMBER column. This table stores the master definition of the business rule's logic and text.
  • IGS_RU_CALL: Related via the S_RULE_CALL_CD column. This reference table defines the valid contexts or calling points for rule execution (e.g., enrollment, advising).

These relationships ensure that rules are attached to valid academic offerings and reference properly defined rule components, forming a key part of the rule engine's data model.