Search Results igs_ps_of_unt_set_rl_u1

Overview

The IGS_PS_OF_UNT_SET_RL table is a core data structure within the Oracle E-Business Suite (EBS) Student Administration module, specifically in the context of Academic Program and Curriculum Management. This table defines and enforces hierarchical relationships between unit sets (collections of academic units or courses) that are offered within a specific program version. Its primary role is to manage the parent-child dependencies between unit sets a student can select, ensuring that curriculum rules and prerequisites are structurally maintained within the system. By establishing these relationships, the table supports complex program structures where enrollment in one unit set may be contingent upon or related to enrollment in another.

Key Information Stored

The table stores a composite record that uniquely identifies a relationship between two unit sets in a specific program offering. The key columns form a seven-part primary key and define the relationship's context. The COURSE_CD, CRV_VERSION_NUMBER, and CAL_TYPE columns anchor the relationship to a specific program version and its calendar of offering. The relationship itself is defined by a superior (parent) and subordinate (child) unit set pair, each identified by its code and version number: SUP_UNIT_SET_CD, SUP_US_VERSION_NUMBER, SUB_UNIT_SET_CD, and SUB_US_VERSION_NUMBER. The inclusion of version numbers for both unit sets is critical for maintaining historical accuracy and supporting curriculum changes over time. Standard "Who" columns (CREATED_BY, CREATION_DATE, etc.) track audit information.

Common Use Cases and Queries

A primary use case is validating student unit set enrollments during academic planning or enrollment processes. The system can query this table to determine if a selected subordinate unit set is permitted under the student's current superior unit set enrollment. For reporting, administrators may analyze program structures to understand unit set dependencies. A common query pattern involves joining to the IGS_PS_OFR_UNIT_SET table to retrieve descriptive details of the related unit sets. For example, to find all subordinate unit sets for a given program and superior unit set:

• SELECT rl.SUB_UNIT_SET_CD, rl.SUB_US_VERSION_NUMBER FROM IGS.IGS_PS_OF_UNT_SET_RL rl WHERE rl.COURSE_CD = :p_course_cd AND rl.CRV_VERSION_NUMBER = :p_version AND rl.CAL_TYPE = :p_cal_type AND rl.SUP_UNIT_SET_CD = :p_sup_unit_set_cd;

Conversely, to find the parent unit set for a given subordinate set, the WHERE clause would filter on SUB_UNIT_SET_CD and SUB_US_VERSION_NUMBER.

Related Objects

The table's integrity is enforced through its relationships with other curriculum objects. Its primary key (IGS_PS_OF_UNT_SET_RL_PK) ensures uniqueness of each defined relationship. Crucially, the table references the IGS_PS_OFR_UNIT_SET table via foreign key constraints on the COURSE_CD column (and implicitly, the other context columns). This ensures that a relationship can only be established for unit sets that are formally offered within a program. The table is referenced by the APPS schema, indicating it is integral to the application logic within the EBS layer. There are no indexes beyond the primary key index (IGS_PS_OF_UNT_SET_RL_U1), which enforces uniqueness and supports queries based on the full key.