Search Results ent_inq_unit_set_id




Overview
Explore in AI Chat

Overview

The IGS_AD_ENT_INQ_USET table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. It functions as a junction or association table that defines the relationship between an inquiry entry status and the permissible unit sets for that status. Its primary role is to enforce business rules by linking a specific stage in the inquiry process (entry status) with the academic unit sets a prospective student can inquire about, thereby governing the available academic pathways during the admissions lifecycle.

Key Information Stored

The table stores the association metadata and its lifecycle attributes. The ENT_INQ_UNIT_SET_ID column serves as the unique primary key identifier for each association record. The two critical foreign key columns, INQ_ENTRY_STAT_ID and INQ_UNIT_SET_CODE_ID, establish the core relationship by referencing a specific inquiry entry status and a specific unit set code, respectively. The CLOSED_IND flag indicates whether the specific status-unit set linkage is currently active or has been deactivated. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing and compliance.

Common Use Cases and Queries

This table is central to configuring and validating the admissions inquiry workflow. A primary use case is to determine all valid academic unit sets that can be selected when a prospective student's inquiry reaches a particular status. Conversely, it can be used to find which entry statuses are valid for a given unit set. Administrators may run queries to audit configurations or identify inactive linkages. A typical reporting query to list all active associations would be:

  • SELECT stat.entry_status_code, uset.unit_set_code, a.CLOSED_IND
  • FROM IGS_AD_ENT_INQ_USET a,
  • IGS_AD_I_ENTRY_STATS stat,
  • IGS_AD_INQ_UNIT_SETS uset
  • WHERE a.INQ_ENTRY_STAT_ID = stat.INQ_ENTRY_STAT_ID
  • AND a.INQ_UNIT_SET_CODE_ID = uset.INQ_UNIT_SET_CODE_ID
  • AND a.CLOSED_IND = 'N';

Another common operation is validating a user's selection against this table during data entry in the relevant EBS forms.

Related Objects

The IGS_AD_ENT_INQ_USET table maintains defined foreign key relationships with two other tables in the IGS schema, forming a critical part of the data model for admissions inquiries.

  • IGS_AD_I_ENTRY_STATS: The INQ_ENTRY_STAT_ID column in IGS_AD_ENT_INQ_USET references this table, which stores the definition of different inquiry entry statuses (e.g., "New," "Contacted," "Converted").
  • IGS_AD_INQ_UNIT_SETS: The INQ_UNIT_SET_CODE_ID column in IGS_AD_ENT_INQ_USET references this table, which stores the master list of available academic unit sets that can be the subject of an inquiry.

The table's primary key constraint is IGS_AD_ENT_INQ_USET_PK on the ENT_INQ_UNIT_SET_ID column. It is also referenced by an APPS synonym, IGS_AD_ENT_INQ_USET, which provides the standard access point for application code.