Search Results reference_code_type




Overview
Explore in AI Chat

Overview

The IGS_PS_USEC_REF_CD table is a core data entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules under the IGS (iGrants) schema. Its primary function is to establish and manage the relationship between unit sections and standardized reference codes. A unit section represents a specific offering or instance of an academic unit (course), and this table allows for the association of various classification codes to those sections. This linkage is essential for consistent data categorization, reporting, and enforcing business rules across the academic enterprise, such as tagging sections with specific instructional methods, funding sources, or assessment types.

Key Information Stored

The table stores the associative entity records linking a unit section reference to a reference code pair. Key columns include UNIT_SECTION_REFERENCE_CD_ID, which serves as the primary unique identifier for each relationship record. The UNIT_SECTION_REFERENCE_ID is a foreign key that identifies the specific unit section. The critical pair for categorization is REFERENCE_CODE_TYPE and REFERENCE_CODE; the type defines the category or domain (e.g., 'ASSESSMENT_TYPE'), and the code is the specific value within that domain (e.g., 'FINAL_EXAM'). The REFERENCE_CODE_DESC provides a descriptive name for the code. The table also maintains standard Oracle EBS "Who" audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN). Notably, the older REFERENCE_CODE_ID column is documented as obsolete.

Common Use Cases and Queries

This table is central to queries that retrieve or report on unit sections based on their classified attributes. A common use case is generating a list of all unit sections tagged with a particular reference code type for operational or compliance reporting. For instance, an institution may need to identify all sections using a specific assessment method or belonging to a particular program cohort. The unique index on (UNIT_SECTION_REFERENCE_ID, REFERENCE_CODE_TYPE, REFERENCE_CODE) ensures that a given section cannot be assigned the same code type and value combination more than once, enforcing data integrity. A typical reporting query would join this table to the parent unit section reference table (IGS_PS_USEC_REF) and potentially to the reference code lookup tables.

SELECT usec_ref.unit_section_reference_id,
       ref_cd.reference_code_type,
       ref_cd.reference_code,
       ref_cd.reference_code_desc
FROM igs.igs_ps_usec_ref_cd ref_cd
WHERE ref_cd.reference_code_type = '&CODE_TYPE';

Related Objects

The IGS_PS_USEC_REF_CD table maintains defined relationships with several other key entities in the IGS schema, as indicated by its foreign key constraints and indexes. The primary key (UNIT_SECTION_REFERENCE_CD_ID) is enforced by the IGS_PS_USEC_REF_CD_PK constraint. Its foreign keys establish critical data integrity links:

  • IGS_PS_USEC_REF: The UNIT_SECTION_REFERENCE_ID column references this table to identify the specific academic unit section.
  • IGS_GE_REF_CD_TYPE_ALL and IGS_GE_REF_CD: The REFERENCE_CODE_TYPE column references these lookup tables to ensure the code type is valid and defined within the system's reference code framework.

The table is also referenced by application objects within the APPS context, indicating its use by the application's business logic and user interfaces.