Search Results igs_ps_ref_cd_pk

Overview

The IGS_PS_REF_CD table is a core data entity within the Oracle E-Business Suite Student System (IGS) module. It functions as a junction table that stores reference codes associated with specific academic programs (courses). Its primary role is to establish a flexible linkage between a program definition and various types of external or internal reference codes, such as an IVRS (Interactive Voice Response System) code, as noted in the documentation. This structure allows for the extension of program attributes without modifying the core program tables, supporting integration with other systems and internal classification needs.

Key Information Stored

The table's structure is defined by a composite primary key, ensuring a unique reference code assignment per program and code type. The critical columns are:

• COURSE_CD and VERSION_NUMBER: Together, these foreign key columns uniquely identify the specific program version from the IGS_PS_VER_ALL table to which the reference code is attached.
• REFERENCE_CD_TYPE: A foreign key to IGS_GE_REF_CD_TYPE_ALL, this column defines the category or domain of the reference code (e.g., 'IVRS', 'STATE_REPORTING').
• REFERENCE_CD: The actual alphanumeric code value assigned to the program for the specified type.

Common Use Cases and Queries

This table is central to processes requiring the retrieval of auxiliary identifiers for academic programs. A common reporting use case involves generating feeds for external systems, such as state reporting bodies or telephony systems, where a specific external code is required. For instance, to list all programs with their associated IVRS codes, a typical query would join IGS_PS_REF_CD with the program version and reference code type tables, filtering on the relevant REFERENCE_CD_TYPE. Data maintenance involves standard DML operations (INSERT, UPDATE, DELETE) on this table, often performed via the application's user interface or supporting APIs, to manage the lifecycle of these reference codes as programs are created or modified.

Related Objects

The table maintains defined foreign key relationships with two primary entities, as documented in the ETRM metadata:

• IGS_PS_VER_ALL: The relationship is established via the columns (COURSE_CD, VERSION_NUMBER). This links each reference code record to its corresponding academic program version.
• IGS_GE_REF_CD_TYPE_ALL: The relationship is established via the column REFERENCE_CD_TYPE. This validates that the type of reference code being stored is a defined and active code type within the system.

The table's primary key constraint, IGS_PS_REF_CD_PK, enforces data integrity on the combination of these four key columns.