Search Results igs_ps_usec_ocur_ref

Overview

The table IGS_PS_USEC_OCUR_REF is a core data entity within the Oracle E-Business Suite Student System (IGS). Its primary function is to capture and manage reference data associated with specific occurrences of a unit section. In the academic structure of the Student System, a unit section is a scheduled offering of a course unit, and an occurrence represents a particular instance or schedule of that section (e.g., a specific lecture series, lab session, or tutorial group). This table acts as a junction, linking a unit section occurrence to standardized reference codes, thereby enabling the categorization, tagging, or classification of occurrences for administrative, reporting, and business process purposes.

Key Information Stored

The table's structure is designed to maintain the relationship between a unit section occurrence and its associated reference codes. The critical columns include UNIT_SECTION_OCCURRENCE_ID, which is a foreign key linking to the IGS_PS_USEC_OCCURS_ALL table to identify the specific occurrence. The reference data itself is stored via the pair of columns REFERENCE_CODE_TYPE and REFERENCE_CODE, which together form a foreign key to the IGS_GE_REF_CD (General Reference Code) table. This design allows for a flexible system where occurrences can be tagged with codes from various defined types. The primary identifier for each record is the surrogate key UNIT_SEC_OCCUR_REFERENCE_ID.

Common Use Cases and Queries

This table is essential for queries and reports that need to filter, group, or analyze unit section occurrences based on their classified attributes. A common use case is generating a list of all lab session occurrences (a reference code) for a given academic term or identifying occurrences tagged with a specific instructional method code. For support and development, a typical diagnostic query would join to the parent tables to retrieve meaningful descriptions.

Sample Query Pattern:
SELECT uso.unit_cd, uso.version_number, uso.cal_type, uso.sequence_number,
grc.reference_code_type, grc.reference_code, grc.description
FROM igs_ps_usec_ocur_ref ocur
JOIN igs_ps_usec_occurs_all uso ON ocur.unit_section_occurrence_id = uso.unit_section_occurrence_id
JOIN igs_ge_ref_cd grc ON (ocur.reference_code_type = grc.reference_code_type
AND ocur.reference_code = grc.reference_code)
WHERE grc.reference_code_type = 'INSTRUCTION_METHOD';

Related Objects

The IGS_PS_USEC_OCUR_REF table has defined dependencies within the Student System schema. Its primary foreign key relationship is with IGS_PS_USEC_OCCURS_ALL, the main table for unit section occurrence details. It also maintains a critical foreign key relationship with IGS_GE_REF_CD, the central repository for all reference codes used across the IGS module. This ensures data integrity and standardization, as the reference codes applied to occurrences are controlled and validated through the general reference code setup. Any interfaces, reports, or processes that consume unit section occurrence data may also indirectly depend on the classifications stored in this table.