Search Results igs_ps_of_opt_unt_st




Overview
Explore in AI Chat

Overview

The table IGS_PS_OF_OPT_UNT_ST is a core configuration entity within the Oracle E-Business Suite Student System (IGS) module. It serves a critical role in defining and managing the academic structure available to students. Specifically, this table establishes the relationship between a Program Offering Option and the Unit Sets that are permissible for students enrolled under that specific offering. A Program Offering Option defines a particular instance of a program (course) based on attributes like location, attendance mode, and calendar type. The table acts as a control mechanism; if a program offering option has entries here, only the listed unit sets are available for student enrollment. Conversely, if no records exist for a given offering option, the system defaults to allowing all defined program unit sets, providing administrative flexibility.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies the linkage between an offering option and a unit set. The key columns, which also serve as foreign keys to parent entities, are: COURSE_CD (program code), CRV_VERSION_NUMBER (program version), CAL_TYPE (calendar type), LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE (collectively defining the offering option), and UNIT_SET_CD with US_VERSION_NUMBER (identifying the specific unit set). This design enforces data integrity by ensuring that each record corresponds to a valid combination of an existing program offering option and an existing program unit set. The presence of the COO_ID column provides an alternative foreign key reference to the offering option via its surrogate key.

Common Use Cases and Queries

This table is central to academic administration and student enrollment validation. A primary use case is during the student course enrollment or unit selection process, where the system queries this table to present only the authorized unit sets for the student's specific program offering. It is also essential for generating compliance reports on program structures and for administrative setup when configuring new program offerings. A typical query would join this table to the offering option and unit set master tables to list all available unit sets for a given program instance.

SELECT ooust.unit_set_cd, ooust.us_version_number, us.unit_set_name
FROM igs_ps_of_opt_unt_st ooust,
     igs_ps_ofr_unit_set us
WHERE ooust.course_cd = :p_course_cd
  AND ooust.crv_version_number = :p_version_number
  AND ooust.cal_type = :p_cal_type
  AND ooust.location_cd = :p_location_cd
  AND ooust.unit_set_cd = us.unit_set_cd
  AND ooust.us_version_number = us.version_number;

Related Objects

The table IGS_PS_OF_OPT_UNT_ST maintains strict referential integrity with two primary parent tables, as documented in the foreign key metadata.

  • IGS_PS_OFR_OPT_ALL: This is the master table for Program Offering Options. The foreign key relationship ensures every record in IGS_PS_OF_OPT_UNT_ST points to a valid offering option. The join can be made using the natural key columns (COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE) or via the surrogate key column COO_ID.
  • IGS_PS_OFR_UNIT_SET: This is the master table for Program Unit Sets. The foreign key ensures that every unit set referenced in IGS_PS_OF_OPT_UNT_ST is a valid, defined unit set. The join is performed on the columns COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, UNIT_SET_CD, and US_VERSION_NUMBER.