Search Results inq_u_set_pkg_item_id




Overview
Explore in AI Chat

Overview

The IGS_AD_I_UST_PKG_ITM table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) module. It functions as a junction table that establishes and manages the relationship between inquiry unit sets and their associated package items. An inquiry unit set typically represents a grouping of academic units or a program of study for which a prospective student inquires. This table links those sets to specific "enquiry package items," which are likely configurable elements or data points (e.g., brochure requests, specific information packets) that can be associated with an inquiry. Its primary role is to maintain the valid combinations of these entities, enabling the system to track which informational items are relevant to which academic inquiry paths.

Key Information Stored

The table stores the relationship metadata along with standard audit columns. The most critical columns are:

The table enforces data integrity through unique constraints on both the primary key and the combination of the two foreign key columns (INQ_UNIT_SET_CODE_ID, ENQUIRY_PACKAGE_ITEM).

Common Use Cases and Queries

This table is central to operations involving the configuration and retrieval of inquiry-related information. A common use case is generating a list of all active package items available for a given inquiry unit set, which might be presented to an admissions officer or within a self-service portal. Troubleshooting often involves searching for a specific relationship using the unique identifier, as indicated by the user's search for "inq_u_set_pkg_item_id". Sample queries include retrieving all relationships for reporting or validation:

SELECT iuspi.inq_u_set_pkg_item_id,
       iuspi.inq_unit_set_code_id,
       iuspi.enquiry_package_item,
       iuspi.closed_ind
FROM igs.igs_ad_i_ust_pkg_itm iuspi
WHERE iuspi.closed_ind = 'N';

Another frequent pattern is joining to the referenced tables to get descriptive information:

SELECT iuspi.inq_u_set_pkg_item_id,
       ius.unit_set_code,
       epi.meaning AS package_item_name
FROM igs.igs_ad_i_ust_pkg_itm iuspi
JOIN igs.igs_ad_inq_unit_sets ius ON iuspi.inq_unit_set_code_id = ius.inq_unit_set_code_id
JOIN igs.igs_in_enq_pkg_item epi ON iuspi.enquiry_package_item = epi.enquiry_package_item
WHERE iuspi.closed_ind = 'N'
ORDER BY ius.unit_set_code;

Related Objects

The IGS_AD_I_UST_PKG_ITM table sits at the center of a small, well-defined relationship model within the IGS schema, as documented in the provided metadata.

  • Primary Key Constraint: IGS_AD_I_UST_PKG_ITM_PK on the INQ_U_SET_PKG_ITEM_ID column.
  • Foreign Key Relationships (Referenced by this table):
    • TABLE: IGS.IGS_AD_INQ_UNIT_SETS via column INQ_UNIT_SET_CODE_ID. This links the package item to a specific academic inquiry set.
    • TABLE: IGS.IGS_IN_ENQ_PKG_ITEM via column ENQUIRY_PACKAGE_ITEM. This links the unit set to a specific configurable inquiry item.
  • Referencing Objects: The documentation indicates the table is referenced by an APPS synonym (IGS_AD_I_UST_PKG_ITM), which is the standard access point for EBS application code, confirming its integration into the larger application architecture.