Search Results igs_ps_unitreqref_cd




Overview
Explore in AI Chat

Overview

The IGS_PS_UNITREQREF_CD table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. It serves as a junction table that establishes and manages formal relationships between academic units (courses or subjects) and standardized reference codes. Its primary role is to enable the association of specific requirements, classifications, or attributes to a unit by linking it to a controlled code from a central reference repository. This ensures data integrity and consistency across the student system by enforcing the use of predefined code values for critical unit-related metadata.

Key Information Stored

The table stores the unique linkage between a unit and a reference code. The key columns include UNIT_REQ_REF_CD_ID, which serves as the primary surrogate key for the record. The identity of the academic unit is defined by the UNIT_CD and VERSION_NUMBER columns. The nature of the association is determined by the REFERENCE_CD_TYPE, which categorizes the kind of reference (e.g., a government reporting code, a disciplinary classification, or a funding category). The specific value within that type is stored in the REFERENCE_CODE column. The combination of UNIT_CD, VERSION_NUMBER, REFERENCE_CD_TYPE, and REFERENCE_CODE is enforced as a unique key (IGS_PS_UNITREQREF_CD_UK1), preventing duplicate assignments of the same code to the same unit version.

Common Use Cases and Queries

A primary use case is regulatory reporting, where a unit must be tagged with specific government or accreditation body codes for compliance. Another is internal categorization for reporting or rule-based processing, such as assigning a research area or a faculty-specific attribute. Common queries involve listing all reference codes attached to a specific unit or finding all units associated with a particular reference code for audit or cohort analysis.

  • Retrieve all reference codes for a unit: SELECT reference_cd_type, reference_code FROM igs_ps_unitreqref_cd WHERE unit_cd = 'MATH101' AND version_number = 1;
  • Find units tagged with a specific accreditation code: SELECT unit_cd, version_number FROM igs_ps_unitreqref_cd WHERE reference_cd_type = 'ACCREDITATION' AND reference_code = 'ENG_2023';

Related Objects

The table's integrity is maintained through defined relationships with other key Student System tables. Its most critical foreign key relationship is with the IGS_GE_REF_CD table, which is the master repository for all reference codes. This relationship is enforced on two columns: REFERENCE_CD_TYPE and REFERENCE_CODE. This ensures that any code assigned to a unit in IGS_PS_UNITREQREF_CD must already exist as a valid, active combination in the central reference code master table. The primary key of this table, UNIT_REQ_REF_CD_ID, is likely referenced by other transactional or history tables within the IGS schema to track changes or apply these attributes in business processes.