Search Results igs_ad_ent_inq_progs




Overview
Explore in AI Chat

Overview

The IGS_AD_ENT_INQ_PROGS table is a data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the IGS (Student System) product family. As explicitly noted in its metadata, this table is designated as "Obsolete." Its core purpose was to store the relationships between inquiry entry statuses and the corresponding inquiry programs within the student admissions module. This mapping would have been essential for defining the workflow or programmatic path associated with an inquiry based on its current status. The "Obsolete" status indicates that this table is no longer actively developed or implemented in new database instances, as confirmed by the documentation stating "Not implemented in this database." Its presence in the data model is primarily for legacy reference.

Key Information Stored

Based on the provided metadata, the table's structure is defined by its primary and unique keys, which reveal its critical columns. The primary identifier for each row is the ENT_INQ_PROG_ID, a system-generated unique key. The table enforces a unique constraint on the combination of two foreign key columns: INQ_ENTRY_STAT_ID and INQ_PROG_CODE_ID. This constraint logically ensured that a specific inquiry entry status could not be linked to the same inquiry program more than once. Therefore, the table fundamentally stored pairs of status IDs and program code IDs, representing a many-to-many relationship between these two entities.

Common Use Cases and Queries

Given its obsolete status, active use cases are minimal. Historically, it would have been queried to determine which inquiry programs were valid or applicable for a given inquiry entry status, or to list all statuses associated with a particular program. A typical reporting query might have joined this table to its parent tables to retrieve descriptive names instead of IDs. A sample analytical SQL pattern would have been:

  • SELECT stats.entry_status_code, progs.inquiry_program_code
  • FROM igs_ad_ent_inq_progs map
  • JOIN igs_ad_i_entry_stats stats ON map.inq_entry_stat_id = stats.inq_entry_stat_id
  • JOIN igs_ad_inq_progs progs ON map.inq_prog_code_id = progs.inq_prog_code_id;

Any custom integrations or data extracts referencing this table in an active system would require careful analysis for potential migration to newer, supported data models.

Related Objects

The table's relationships are explicitly documented through its foreign keys. It is a child table to two primary reference tables in the obsolete Student System schema:

  • IGS_AD_I_ENTRY_STATS: This table stores the definitions of inquiry entry statuses. The relationship is established via the column IGS_AD_ENT_INQ_PROGS.INQ_ENTRY_STAT_ID.
  • IGS_AD_INQ_PROGS: This table stores the definitions of inquiry programs. The relationship is established via the column IGS_AD_ENT_INQ_PROGS.INQ_PROG_CODE_ID.

These foreign key relationships enforce referential integrity, ensuring that every record in IGS_AD_ENT_INQ_PROGS points to a valid record in both parent tables. The primary key IGS_AD_ENT_INQ_PROGS_PK on ENT_INQ_PROG_ID would be referenced by any other obsolete objects that needed to link directly to a specific mapping record.