Search Results ent_pkg_item_id




Overview
Explore in AI Chat

Overview

The IGS_AD_ENT_PKG_ITEMS 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 mapping table that establishes the relationship between inquiry entry statuses and specific inquiry package items. Its primary role is to define which inquiry package items are relevant or applicable to a given entry status within the admissions workflow. This configuration is essential for managing the lifecycle of an applicant's inquiry, ensuring the correct forms, documents, or checklist items (the package items) are associated with specific stages (the entry statuses) of the inquiry process.

Key Information Stored

The table stores a concise set of columns that define the relationship and its attributes. The most critical columns are the foreign keys and the status indicator:

  • ENT_PKG_ITEM_ID (NUMBER): The primary key and unique system-generated identifier for each record in this table. This is the column referenced by the user's search term.
  • INQ_ENTRY_STAT_ID (NUMBER): A foreign key referencing the IGS_AD_I_ENTRY_STATS table. This links the record to a specific inquiry entry status.
  • ENQUIRY_PACKAGE_ITEM (VARCHAR2): A foreign key referencing the IGS_IN_ENQ_PKG_ITEM table. This identifies the specific inquiry package item (e.g., a form or document) associated with the status.
  • CLOSED_IND (VARCHAR2): A status flag indicating whether the association is active or closed. This allows for the deactivation of relationships without deleting the historical record.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns that track the user and timestamp for record creation and last update, as per Oracle EBS conventions.

Common Use Cases and Queries

This table is primarily used for configuration, validation, and reporting within the admissions inquiry process. A common operational use case is to retrieve all active package items required for an applicant at their current inquiry status to generate a dynamic checklist. For reporting, administrators may analyze the configuration to ensure all necessary entry statuses have the correct package items assigned. A typical query to fetch all active mappings would be:

SELECT stat.entry_status_code, pkg.item_code, map.closed_ind
FROM igs.igs_ad_ent_pkg_items map,
     igs.igs_ad_i_entry_stats stat,
     igs.igs_in_enq_pkg_item pkg
WHERE map.inq_entry_stat_id = stat.inq_entry_stat_id
AND map.enquiry_package_item = pkg.enquiry_package_item
AND NVL(map.closed_ind, 'N') = 'N'
ORDER BY stat.entry_status_code;

To find the specific record identified by the primary key from the user's search, one would query: SELECT * FROM igs.igs_ad_ent_pkg_items WHERE ent_pkg_item_id = <value>;

Related Objects

The IGS_AD_ENT_PKG_ITEMS table sits at the center of a small but critical relationship model, as defined by its foreign key constraints:

  • Primary Key: IGS_AD_ENT_PKG_ITEMS_PK on the ENT_PKG_ITEM_ID column.
  • Foreign Key Reference (Parent): TABLE: IGS.IGS_AD_I_ENTRY_STATS. The INQ_ENTRY_STAT_ID column in IGS_AD_ENT_PKG_ITEMS references this table, which holds the master list of valid inquiry entry statuses.
  • Foreign Key Reference (Parent): TABLE: IGS.IGS_IN_ENQ_PKG_ITEM. The ENQUIRY_PACKAGE_ITEM column in IGS_AD_ENT_PKG_ITEMS references this table, which is the master definition table for inquiry package items.
  • Dependent Object: The APPS synonym IGS_AD_ENT_PKG_ITEMS points to this table, providing the standard access point for EBS application code.