Search Results igs_ad_i_prg_u_set_pk

Overview

The IGS_AD_I_PRG_U_SET table is a data entity within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to store the relationship between an inquiry program code and the associated inquiry unit set codes. This table facilitates the management of academic program structures during the student inquiry and admissions lifecycle. It is important to note that the official ETRM documentation explicitly marks this table as Obsolete. This status indicates that while the table may exist in the database schema, it is no longer actively developed or recommended for use in new implementations. Its functionality has likely been superseded by other data models or objects within later versions of the application.

Key Information Stored

The table's structure is defined by its primary and unique keys, which enforce data integrity for the relationships it stores. The key columns are:

• INQ_PROG_UNIT_SET_ID: Serves as the primary key (IGS_AD_I_PRG_U_SET_PK), providing a unique system-generated identifier for each record.
• INQ_PROG_CODE_ID: A foreign key column that references an inquiry program code in the IGS_AD_INQ_PROGS table. This identifies the specific program of interest.
• INQ_UNIT_SET_CODE_ID: A foreign key column that references an inquiry unit set code in the IGS_AD_INQ_UNIT_SETS table. This identifies a specific unit set (or group of courses) linked to the program.

The combination of INQ_PROG_CODE_ID and INQ_UNIT_SET_CODE_ID is enforced as a unique key (IGS_AD_I_PRG_U_SET_UK), preventing duplicate program-to-unit-set associations.

Common Use Cases and Queries

Given its obsolete status, direct interaction with this table in new customizations or reports is discouraged. Historically, its use cases would have centered on querying valid unit set options for a given inquiry program. A typical legacy query pattern might involve joining to its parent tables to retrieve descriptive codes:

SELECT iprg.inq_prog_code, ius.inq_unit_set_code
FROM igs.igs_ad_i_prg_u_set ipus,
igs.igs_ad_inq_progs iprg,
igs.igs_ad_inq_unit_sets ius
WHERE ipus.inq_prog_code_id = iprg.inq_prog_code_id
AND ipus.inq_unit_set_code_id = ius.inq_unit_set_code_id
AND iprg.inq_prog_code = '&PROGRAM_CODE';

Any reporting or integration requirements in current implementations should be validated against the application's active data model, as this table may be deprecated or its data may be maintained elsewhere.

Related Objects

The table's integrity is maintained through documented foreign key relationships with other IGS schema objects:

• Referenced By (Parent Tables):
  • IGS_AD_INQ_PROGS: via the column INQ_PROG_CODE_ID.
  • IGS_AD_INQ_UNIT_SETS: via the column INQ_UNIT_SET_CODE_ID.
• Referenced From (Child Table):
  • IGS_AD_I_PRG_PRF_UST: This table references IGS_AD_I_PRG_U_SET via the foreign key column INQ_PROG_UNIT_SET_ID.

These relationships form a small hierarchy within the obsolete inquiry data model, where IGS_AD_I_PRG_U_SET acts as a junction table between inquiry programs and unit sets, and is itself a parent to the IGS_AD_I_PRG_PRF_UST table.