Search Results igs_ad_i_entry_lvls




Overview
Explore in AI Chat

Overview

The table IGS_AD_I_ENTRY_LVLS is a data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to store reference data for inquiry entry levels, which are classification codes used to categorize prospective student inquiries or applications based on their intended level of study (e.g., undergraduate, graduate). This table acts as a lookup or validation table, ensuring data integrity for the entry level information captured in the main inquiry processing tables. Critically, the official ETRM documentation explicitly marks this table as "Obsolete." This status indicates that while the table may exist in schemas for versions 12.1.1 and 12.2.2 to support legacy data, its use is deprecated, and it is not intended for new development or customizations.

Key Information Stored

The table's structure is centered on a unique identifier and the entry level code itself. The primary key is the column INQ_ENTRY_LEVEL_ID, which is a system-generated unique identifier (likely a sequence number) for each entry level record. The table also enforces a unique constraint on the column INQ_ENTRY_LEVEL, which stores the actual code representing the level of study (e.g., 'UG', 'GR'). While the provided metadata does not list additional descriptive columns such as a meaning or description field, such columns are common in similar lookup tables within EBS to provide a human-readable name for the code.

Common Use Cases and Queries

Given its obsolete status, direct interaction with this table for new reporting or integration is discouraged. Its primary historical use case was to validate and describe the entry level associated with a student inquiry. Common queries would involve joining this table to the main inquiry table to translate codes into descriptions for reports. A typical legacy query pattern would be:

  • Retrieving a list of all valid entry level codes: SELECT INQ_ENTRY_LEVEL FROM IGS_AD_I_ENTRY_LVLS;
  • Joining to the inquiry application table for a descriptive report: SELECT appl.column1, lvl.INQ_ENTRY_LEVEL FROM IGS_IN_ENQUIRY_APPL_ALL appl, IGS_AD_I_ENTRY_LVLS lvl WHERE appl.INQ_ENTRY_LEVEL_ID = lvl.INQ_ENTRY_LEVEL_ID;

For any current development, consultants must identify and use the successor table or API that has replaced this obsolete object.

Related Objects

The documented relationship for this table is unidirectional; it is referenced by one other table via a foreign key constraint. This relationship is crucial for understanding data dependencies.

  • Referencing Table: IGS_IN_ENQUIRY_APPL_ALL
  • Relationship: The column IGS_IN_ENQUIRY_APPL_ALL.INQ_ENTRY_LEVEL_ID is a foreign key that references IGS_AD_I_ENTRY_LVLS.INQ_ENTRY_LEVEL_ID.
  • Purpose: This relationship enforces that every inquiry application record must have an entry level ID that corresponds to a valid record in the IGS_AD_I_ENTRY_LVLS lookup table, thereby maintaining referential integrity for this attribute.

No other foreign keys or dependencies are documented in the provided metadata.