Search Results igs_ad_ent_inq_uset_pk

Overview

The table IGS_AD_ENT_INQ_USET is a data object within the Oracle E-Business Suite, specifically belonging to the now-obsolete IGS (Student System) product family. Its documented purpose is to store associations between inquiry entry statuses and inquiry unit sets. This table functioned as a junction or intersection table, defining which academic unit sets were applicable or relevant for a prospective student based on their specific inquiry entry status. This relationship was critical for managing the academic pathways and program interests associated with student inquiries during the admissions lifecycle. As explicitly noted in the ETRM metadata, this table and its parent module are marked as obsolete, indicating it is part of a legacy system component that is no longer actively developed or implemented in newer database instances.

Key Information Stored

The table's structure centers on a unique identifier and two foreign key relationships. The primary technical identifier is the column ENT_INQ_UNIT_SET_ID, which serves as the system-generated primary key (IGS_AD_ENT_INQ_USET_PK). The core business data is stored via two key columns that form a unique constraint (IGS_AD_ENT_INQ_USET_UK): INQ_ENTRY_STAT_ID and INQ_UNIT_SET_CODE_ID. The INQ_ENTRY_STAT_ID column holds a foreign key reference to a specific inquiry entry status record. The INQ_UNIT_SET_CODE_ID column holds a foreign key reference to a defined inquiry unit set. Together, these columns enforce a rule that a given status can be associated with a specific unit set only once, preventing duplicate mappings.

Common Use Cases and Queries

In its operational context, this table supported processes for validating and presenting available academic options during the inquiry stage. A primary use case was to dynamically determine which unit sets (representing programs or courses of study) should be presented to a user based on the current entry status of an inquiry. A typical query would join this table to the status and unit set master tables to generate a list. For reporting, it enabled analysis of inquiry trends by academic interest area. Given its obsolete status, direct queries against this table in active implementations are unlikely. However, historical data migration or reporting on legacy information would involve standard SELECT statements with joins to the related foreign key tables.

Related Objects

The IGS_AD_ENT_INQ_USET table has defined relationships with two other tables in the obsolete Student System, as per the provided foreign key metadata:

• IGS_AD_I_ENTRY_STATS: This is the master table for inquiry entry statuses. The relationship is established via the column IGS_AD_ENT_INQ_USET.INQ_ENTRY_STAT_ID, which references the primary key of IGS_AD_I_ENTRY_STATS.
• IGS_AD_INQ_UNIT_SETS: This is the master table for inquiry unit set codes. The relationship is established via the column IGS_AD_ENT_INQ_USET.INQ_UNIT_SET_CODE_ID, which references the primary key of IGS_AD_INQ_UNIT_SETS.

These relationships confirm the table's role as an intersection entity between these two master definitions. The provided metadata also states this table was "Not implemented in this database," suggesting it may exist in documentation but not in all deployed instances.