Search Results igs_ps_unit_ofr_opt_all




Overview
Explore in AI Chat

Overview

The table IGS_PS_UNIT_OFR_OPT_ALL is a core data entity within the Oracle E-Business Suite's now-obsolete Student System (IGS) module. It serves as the master definition for a specific offering instance, or "section," of an academic unit (course). The table defines the available options for each unit offering, effectively representing the intersection of a unit version, a calendar instance (e.g., Semester 1, 2024), a location, and a class type (e.g., Lecture, Tutorial). This record, often referenced by its unique identifier UOO_ID, is the fundamental building block for student enrollment, assessment scheduling, and financial accounting related to unit offerings in versions 12.1.1 and 12.2.2 of the application.

Key Information Stored

The table's structure captures the multidimensional nature of a unit offering. Its primary keys reveal the critical dimensions: UNIT_CD and VERSION_NUMBER identify the specific unit; CAL_TYPE and CI_SEQUENCE_NUMBER define the academic calendar period; LOCATION_CD specifies the campus; and UNIT_CLASS indicates the instruction mode. The surrogate key UOO_ID provides a single, unique identifier for the offering option. Other significant columns include GRADING_SCHEMA_CD and GS_VERSION_NUMBER to link to the applicable grading scheme, REV_ACCOUNT_CD for financial revenue account mapping, and UNIT_CONTACT to associate an instructor or responsible party from the HZ_PARTIES table.

Common Use Cases and Queries

This table is central to operational and reporting queries in the student lifecycle. A common use case is generating a schedule of offerings for a given term and location. A typical query would join to IGS_PS_UNIT_OFR_PAT_ALL for pattern details and IGS_AD_LOCATION_ALL for location descriptions. Another critical use is validating enrollment eligibility, where a student's planned units (IGS_EN_PLAN_UNITS) are checked against the active offerings in this table. For assessment purposes, queries often retrieve all UOO_IDs for a specific unit and term to assign graders or schedule exams. A sample SQL pattern to list active offerings would be:

  • SELECT uoo.unit_cd, uoo.location_cd, uoo.unit_class, loc.location_name
  • FROM igs_ps_unit_ofr_opt_all uoo,
  • igs_ad_location_all loc
  • WHERE uoo.cal_type = :p_term_type
  • AND uoo.ci_sequence_number = :p_term_seq
  • AND uoo.location_cd = loc.location_cd(+);

Related Objects

As a central hub table, IGS_PS_UNIT_OFR_OPT_ALL has extensive relationships. It is a direct child of IGS_PS_UNIT_OFR_PAT_ALL, which defines the broader unit offering pattern. Its primary identifier, UOO_ID, is referenced as a foreign key in numerous transactional tables across the Student System, including IGS_EN_PLAN_UNITS (for student study plans), IGS_EN_SPL_PERM (for special permissions), IGS_AS_USEC_SESSNS (for assessment sessions), and IGS_FI_ACC_ALL for financial accounting. It also links to master data tables like IGS_AS_GRD_SCHEMA for grading, IGS_AD_LOCATION_ALL for campuses, and HZ_PARTIES for contacts, highlighting its integrative role in the application's data model.