Search Results inq_prg_pref_uset_id

Overview

The IGS_AD_I_PRG_PRF_UST table is a data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function was to store the relationships between an inquiry's program preferences and the specific unit sets (or course structures) preferred by the prospective student. This table is designated as obsolete in the provided ETRM documentation, indicating it is no longer actively used or supported in the current data model for Oracle EBS versions 12.1.1 and 12.2.2. Its historical role was to maintain referential integrity between inquiry program preferences and their associated unit set selections during the student admissions inquiry process.

Key Information Stored

The table's structure is defined by its primary and unique keys, which are critical for understanding its data relationships. The primary identifier for each row is the INQ_PRG_PREF_USET_ID column. The table enforces data integrity through two unique constraints. The first, IGS_AD_I_PRG_PRF_UST_UK1, ensures a unique combination of INQ_PROG_PREF_ID (linking to the main program preference) and INQ_PROG_UNIT_SET_ID (linking to a specific unit set). The second, IGS_AD_I_PRG_PRF_UST_UK2, ensures a unique combination of INQ_PROG_PREF_ID and UNIT_SET_PREF_ID, which likely stored a ranking or preference order for the unit set within the context of that program preference.

Common Use Cases and Queries

Given its obsolete status, direct operational or reporting use of this table in current implementations is not recommended. Historically, it would have been queried to analyze or report on the unit set preferences associated with student inquiries for specific programs. A typical query pattern, based on the user's search for "inq_prog_pref_id", would involve joining to its parent tables to retrieve descriptive information. For example, a historical report might have used SQL similar to:

• SELECT prf_ust.*, prefs.inquiry_id, u_set.unit_set_cd FROM igs.igs_ad_i_prg_prf_ust prf_ust JOIN igs.igs_ad_i_prg_prefs prefs ON prf_ust.inq_prog_pref_id = prefs.inq_prog_pref_id JOIN igs.igs_ad_i_prg_u_set u_set ON prf_ust.inq_prog_unit_set_id = u_set.inq_prog_unit_set_id WHERE prf_ust.inq_prog_pref_id = :1;

Related Objects

The table's relationships are explicitly defined by its foreign key constraints. It is a child table that references two key parent tables in the IGS schema, forming the core of its data model context.

• IGS_AD_I_PRG_PREFS: This is the primary parent table. The relationship is maintained via the INQ_PROG_PREF_ID column in IGS_AD_I_PRG_PRF_UST, which references the primary key of the IGS_AD_I_PRG_PREFS table. This links a unit set preference record to a specific inquiry program preference.
• IGS_AD_I_PRG_U_SET: This table provides the definition for the unit set. The relationship is maintained via the INQ_PROG_UNIT_SET_ID column in IGS_AD_I_PRG_PRF_UST, which references the primary key of the IGS_AD_I_PRG_U_SET table.