Search Results igs_ss_inq_prog




Overview
Explore in AI Chat

Overview

The table IGS_SS_INQ_PROG is a historical data object within the Oracle E-Business Suite, specifically belonging to the now-obsolete IGS (Student System) module. As indicated by its description, it was designed to hold data for Self Service Staging Inquiry Programs. This table functioned as a staging or configuration entity, likely managing the linkage between specific inquiry processes and the academic programs to which they pertained within the student self-service framework. Its status is explicitly marked as obsolete, and the provided metadata notes it was not implemented in the referenced database, indicating it may exist in the data dictionary as a legacy artifact from an earlier version or a discontinued feature path.

Key Information Stored

Based on the documented structure, the table's primary data element is a unique identifier for each inquiry program record. The central column is INQ_PROG_ID, which serves as the table's primary key. A critical relational column is INQ_INQ_ID, a foreign key that links each program record back to a parent inquiry definition stored in the IGS_SS_INQUIRY table. This establishes a master-detail relationship where an inquiry can be associated with multiple programs.

Common Use Cases and Queries

Given the table's obsolete status, active operational or reporting use cases are non-existent in current implementations. Historically, its purpose would have been to support configuration and runtime operations for student self-service inquiries related to academic programs. Analytical queries would have focused on understanding the relationships between inquiries and programs. A typical historical join to retrieve all program associations for a specific inquiry might have resembled:

  • SELECT prog.* FROM igs_ss_inq_prog prog, igs_ss_inquiry inq WHERE prog.inq_inq_id = inq.inquiry_id AND inq.code = '<INQUIRY_CODE>';

Today, any encounter with this table is likely during data migration analysis, legacy code review, or cleanup activities to remove obsolete schema objects.

Related Objects

The table exists within a defined relational hierarchy, as per the provided foreign key metadata.

  • Parent Table (Referenced by IGS_SS_INQ_PROG):
    • IGS_SS_INQUIRY: Linked via the foreign key column IGS_SS_INQ_PROG.INQ_INQ_ID. This is the master inquiry definition table.
  • Child Table (References IGS_SS_INQ_PROG):
    • IGS_SS_INQ_PROG_USET: Linked via its foreign key column IGS_SS_INQ_PROG_USET.INQ_PROG_ID. This indicates a further detail table, likely defining user sets or security for the inquiry program.