Search Results igs_in_enq_pkg_item_pk

Overview

The IGS_IN_ENQ_PKG_ITEM table is a core data entity within the Oracle E-Business Suite (EBS) Student System (IGS) module for releases 12.1.1 and 12.2.2. It functions as a master catalog for correspondence items, which can be either system-generated or manually created, that are eligible for inclusion in an enquiry package. An enquiry package is a collection of documents and information assembled for prospective students during the admissions process. Critically, the official ETRM documentation explicitly marks this entity as "Obsolete." This status indicates that while the table may exist in the database schema for backward compatibility, its associated business logic is likely deprecated, and its use in new customizations or integrations is not recommended. The table's primary role is to serve as a reference point for various configuration tables that map specific enquiry package items to other entities within the admissions lifecycle.

Key Information Stored

While the provided metadata does not list specific column definitions beyond the primary and foreign keys, the table's structure can be inferred from its relationships and description. The central data point is the ENQUIRY_PACKAGE_ITEM column, which serves as the unique primary key (IGS_IN_ENQ_PKG_ITEM_PK) to identify each distinct piece of correspondence. This key is extensively referenced by numerous child tables. Another documented column is ATTENDANCE_MODE, which is a foreign key referencing the IGS_EN_ATD_MODE_ALL table. This suggests that enquiry package items could be associated with or filtered by specific modes of attendance (e.g., full-time, part-time). The table likely contains additional descriptive columns to define the item, such as a name, description, type (system/non-system), and status, though these are not detailed in the excerpt.

Common Use Cases and Queries

Given its obsolete status, direct operational use cases are minimal in contemporary implementations. Its primary function is referential. Historical or support-related queries might involve identifying which configuration records depend on a specific enquiry package item. A common reporting need would be to list all items available for packaging. A typical SQL pattern would involve joining to the many child tables to understand an item's full usage across the system.

• Sample Query: Find all configuration mappings for a package item:
  SELECT eipi.enquiry_package_item, aepi.* FROM igs_in_enq_pkg_item eipi LEFT JOIN igs_ad_ent_pkg_items aepi ON eipi.enquiry_package_item = aepi.enquiry_package_item WHERE eipi.enquiry_package_item = 'ITEM_CODE';
• Use Case: Data validation or cleanup scripts to ensure referential integrity before decommissioning obsolete items from the catalog.

Related Objects

The IGS_IN_ENQ_PKG_ITEM table maintains a complex web of foreign key relationships, primarily as a parent table. It references the IGS_EN_ATD_MODE_ALL table via its ATTENDANCE_MODE column. More significantly, its primary key (ENQUIRY_PACKAGE_ITEM) is referenced as a foreign key by a multitude of configuration tables, establishing it as a central hub for admissions-related correspondence packaging. The documented referencing tables are:

• IGS_AD_ENT_PKG_ITEMS: Links enquiry items to entry periods.
• IGS_AD_I_PRG_PKG_ITM: Links enquiry items to programs of study.
• IGS_AD_I_UST_PKG_ITM: Links enquiry items to IGS US states (likely for region-specific correspondence).
• IGS_PS_IN_PKG_ITM: Links enquiry items within the IGS Product Suite context.
• IGS_IN_INFTYP_PKG_IT: Links enquiry items to information types.
• IGS_IN_LVLTYP_PKG_IT: Links enquiry items to level types (e.g., undergraduate, postgraduate).
• IGS_IN_APPLML_PKGITM: Links enquiry items to application methods.

These relationships demonstrate how a single enquiry package item in this master table could be configured for use across different admissions criteria, programs, geographical regions, and student levels.