Search Results inq_prog_pkg_item_id

Overview

The table IGS_AD_I_PRG_PKG_ITM is a component of the Oracle E-Business Suite Student System (IGS). Its primary function was to store the relationship between inquiry program codes and specific items within an inquiry package. This table facilitated the configuration of predefined information packages that could be associated with different academic inquiry programs. It is critical to note that the official ETRM documentation explicitly marks this table as Obsolete. This status indicates that while the table may physically exist in the database for backward compatibility, its business logic is no longer actively used or supported within the application's current architecture in releases 12.1.1 and 12.2.2. Its role has likely been superseded by other data models or features.

Key Information Stored

The table's structure centers on linking two key entities. The primary identifier for each record is the INQ_PROG_PKG_ITEM_ID, which serves as the table's unique primary key. The core relationship is established through two foreign key columns: INQ_PROG_CODE_ID, which references a specific inquiry program code, and ENQUIRY_PACKAGE_ITEM, which references a specific item within a broader inquiry package. This design allowed administrators to define which package items (e.g., specific brochures, forms, or information sheets) were automatically linked to particular types of program inquiries.

Common Use Cases and Queries

Given its obsolete status, direct operational or transactional use of this table in active development or reporting is strongly discouraged. Historical analysis or data migration projects might be the only scenarios for accessing it. Sample queries would typically involve joining to its parent tables to understand legacy configurations. For example, to retrieve all package items previously associated with a specific inquiry program, one might use a pattern such as:

• SELECT ipi.* FROM igs.igs_ad_i_prg_pkg_itm ipi JOIN igs.igs_ad_inq_progs iap ON ipi.inq_prog_code_id = iap.inq_prog_code_id WHERE iap.program_code = '&PROGRAM_CODE';

Any new functionality should be built using the current, supported data models as defined by Oracle.

Related Objects

The table's integrity is defined by its relationships with two parent tables, as documented in the ETRM metadata. These foreign key constraints are essential for understanding its place in the obsolete data model:

• IGS_AD_INQ_PROGS: The INQ_PROG_CODE_ID column in IGS_AD_I_PRG_PKG_ITM references this table, linking a package item to a specific inquiry program code.
• IGS_IN_ENQ_PKG_ITEM: The ENQUIRY_PACKAGE_ITEM column in IGS_AD_I_PRG_PKG_ITM references this table, linking the relationship record to the actual definition of an inquiry package item.

The primary key constraint IGS_AD_I_PRG_PKG_ITM_PK on INQ_PROG_PKG_ITEM_ID ensures the uniqueness of each relationship record.