Search Results igs_ps_unit_ref_cd




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_REF_CD table is a core data entity within the Oracle E-Business Suite's Student System (IGS), specifically designed for versions 12.1.1 and 12.2.2. Its primary function is to manage and store reference codes associated with academic units. These reference codes serve as supplementary identifiers or classification tags for a unit, linking it to external systems or internal categorization schemes. A typical example, as noted in the official documentation, is an IVRS (Interactive Voice Response System) code. It is critical to note that the Student System (IGS) is marked as "Obsolete" in the provided metadata, indicating that while the table exists in the database schema, its associated application logic may be deprecated or superseded in current implementations. The table's design enforces a many-to-one relationship, allowing a single unit version to be associated with multiple reference codes of different types.

Key Information Stored

The table's structure is defined by a composite primary key and foreign key relationships that ensure referential integrity. The key columns are:

Common Use Cases and Queries

This table is primarily utilized for integration, reporting, and data validation where units must be identified by external or alternate codes. A common operational use case is generating interface files for external systems, such as government reporting bodies or third-party learning platforms, that require a specific identifier not captured in the standard unit code. For reporting, it enables the joining of unit data with broader reference code lookups. A typical query would retrieve all reference codes for a given unit to validate data completeness or for use in a downstream extract:

SELECT urc.unit_cd, urc.version_number, urc.reference_cd_type, urc.reference_cd, rc.description
FROM igs_ps_unit_ref_cd urc,
igs_ge_ref_cd rc
WHERE urc.unit_cd = 'MATH101'
AND urc.reference_cd_type = rc.reference_cd_type
AND urc.reference_cd = rc.reference_cd;

Given the "Obsolete" status of the IGS module, direct interaction with this table is likely limited to legacy data support, migration projects, or historical reporting.

Related Objects

The IGS_PS_UNIT_REF_CD table is centrally connected to several master tables in the Student System, as defined by its documented foreign key constraints:

  • IGS_PS_UNIT_VER_ALL: This is the master table for unit versions. The relationship is defined on the columns UNIT_CD and VERSION_NUMBER, ensuring every reference code record is attached to a valid, existing unit version.
  • IGS_GE_REF_CD and IGS_GE_REF_CD_TYPE_ALL: These are generic code tables that control the valid values for REFERENCE_CD_TYPE and REFERENCE_CD. The dual foreign key ensures that any code type and code value stored in IGS_PS_UNIT_REF_CD is defined and active in the system's centralized code management tables, maintaining data consistency across the application.