Search Results igs_ad_inq_unit_sets_pk

Overview

The table IGS_AD_INQ_UNIT_SETS is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. It functions as a reference table designed to store codes representing academic unit sets of interest to prospective students during the inquiry phase of the admissions lifecycle. Its primary role is to maintain a standardized list of these unit sets, which are then linked to specific admission inquiries and applicant preferences. Crucially, the official ETRM documentation explicitly marks this table as "Obsolete" in the context of releases 12.1.1 and 12.2.2. This status indicates that while the table may still exist in the database schema for backward compatibility, its use in new development or business processes is deprecated, and it may be targeted for removal in future releases.

Key Information Stored

Based on the provided metadata, the table's structure is centered around two key identifiers. The primary technical key is INQ_UNIT_SET_CODE_ID, a unique system-generated identifier constrained by the primary key IGS_AD_INQ_UNIT_SETS_PK. The primary business key is INQ_UNIT_SET_CODE, which holds the actual code value for the inquiry unit set and is enforced by a unique key constraint (IGS_AD_INQ_UNIT_SETS_UK). While the specific descriptive name or other attributes for the unit set are not detailed in the excerpt, the table's purpose is to act as the authoritative source for these valid codes, which are referenced via foreign key relationships throughout the admissions inquiry sub-module.

Common Use Cases and Queries

Given its obsolete status, active development or new reporting should avoid direct dependencies on this table. Historical use cases would have involved validating and retrieving unit set codes for inquiry processing. Common queries would have been joins to related transactional tables for reporting or data validation. A typical historical pattern for retrieving inquiry details might have resembled:

• SELECT ius.inq_unit_set_code, eiu.* FROM igs_ad_ent_inq_uset eiu, igs_ad_inq_unit_sets ius WHERE eiu.inq_unit_set_code_id = ius.inq_unit_set_code_id;

Current use is likely limited to supporting legacy data, data migration scripts, or understanding historical data relationships during audits or upgrades where the obsolete table has not yet been purged.

Related Objects

The table maintains several foreign key relationships, where its primary key (INQ_UNIT_SET_CODE_ID) is referenced by other tables in the IGS schema. These relationships, as documented, are:

• IGS_AD_ENT_INQ_USET: Links an inquiry unit set to a specific admission entry inquiry.
• IGS_AD_I_PRG_U_SET: Associates an inquiry unit set with an inquiry program.
• IGS_AD_I_USET_PREFS: Stores applicant preferences related to specific inquiry unit sets.
• IGS_AD_I_UST_PKG_ITM: Relates an inquiry unit set to items within a package (likely for structured program offerings).

These dependencies underscore the table's former central role in modeling the academic interests of prospective students. Any analysis or data extraction involving these related tables must account for the obsolete status of IGS_AD_INQ_UNIT_SETS.