Search Results IGS_PS_UNIT_VER_RU




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_VER_RU table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a junction table that establishes and manages the association between unit versions and the business rules that govern them. In the context of academic administration, a unit version represents a specific offering of a course subject. This table enables the system to enforce complex academic policies, prerequisites, co-requisites, and other regulatory logic by linking a unit version to predefined rule definitions. Its role is critical for maintaining academic integrity and automating compliance checks during processes like enrollment, progression, and graduation within the EBS framework.

Key Information Stored

The table's structure is designed to uniquely identify a rule attached to a specific unit version. The primary key is a composite of UNIT_CD, VERSION_NUMBER, and S_RULE_CALL_CD, ensuring that a particular rule type is not duplicated for the same unit offering. Key columns include UNIT_CD and VERSION_NUMBER, which together reference the specific unit version from the IGS_PS_UNIT_VER_ALL table. The S_RULE_CALL_CD column identifies the category or type of rule being applied, linking to the IGS_RU_CALL table. Furthermore, the RUL_SEQUENCE_NUMBER column is a foreign key that points to the actual rule definition and its logic stored in the IGS_RU_RULE table, completing the linkage between the unit, the rule call type, and the rule's implementation.

Common Use Cases and Queries

A primary use case is validating student eligibility for unit enrollment. The system queries this table to retrieve all rules associated with a unit version a student wishes to take, then evaluates each linked rule against the student's academic record. For reporting and administrative oversight, queries often join this table to unit and rule descriptions to audit which rules are applied across the curriculum. A common SQL pattern involves fetching all rules for a given unit:

  • SELECT uv.unit_cd, uv.version_number, rc.meaning AS rule_call, r.rule_type
    FROM igs_ps_unit_ver_ru uvru
    JOIN igs_ru_call rc ON uvru.s_rule_call_cd = rc.s_rule_call_cd
    JOIN igs_ru_rule r ON uvru.rul_sequence_number = r.sequence_number
    WHERE uvru.unit_cd = '&UNIT_CODE' AND uvru.version_number = &VERSION_NUM;

Another critical scenario is during curriculum design, where administrators insert or update records in this table to attach new academic rules to unit offerings.

Related Objects

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

  • IGS_PS_UNIT_VER_ALL: The parent table for unit versions. Joined via columns UNIT_CD and VERSION_NUMBER.
  • IGS_RU_CALL: Provides the valid list of rule call types (e.g., prerequisite, corequisite). Joined via column S_RULE_CALL_CD.
  • IGS_RU_RULE: Contains the master definition and logic of the rule itself. Joined via column RUL_SEQUENCE_NUMBER.

These relationships ensure referential integrity, meaning a rule cannot be assigned to a non-existent unit version or linked to an undefined rule call or rule definition.