Search Results inq_prog_uset_id

Overview

The IGS_SS_INQ_PROG_USET 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) product family. As indicated by its storage in the APPS_TS_INTERFACE tablespace and its STATUS column, it functions as a staging or transactional table. Its documented purpose is to hold Self Service Staging Inquiry Program Unit Set records. This table is central to managing the relationship between inquiry programs and academic unit sets during student inquiry or application processes, likely within the context of the Student Self-Service module. It serves as a junction table that links program inquiries to specific curriculum or study plan preferences.

Key Information Stored

The table's columns are designed to establish relationships and track transactional state. The primary identifier is the INQ_PROG_USET_ID. The two most significant foreign key columns are INQ_PROG_ID, which links to an inquiry program code, and INQ_PROG_UNIT_SET_ID, which links to a related inquiry unit set code. The UNIT_SET_PREF_ID column stores a preference identifier, allowing for ordering or ranking of multiple unit sets for a single program inquiry. The STATUS column is critical for workflow management, indicating the current state of the record (e.g., Active, Inactive, Processing). Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and concurrent program tracking columns (REQUEST_ID, PROGRAM_ID, etc.) provide full auditability and integration with batch processes.

Common Use Cases and Queries

This table is primarily accessed for reporting on program-unit set associations during the inquiry lifecycle and for data validation in interface programs. A common operational query would retrieve all active unit set preferences for a specific inquiry program to display in a self-service portal or for administrative review. The base query pattern, as provided in the ETRM, is:

SELECT INQ_PROG_USET_ID, INQ_PROG_ID, UNIT_SET_PREF_ID,
       INQ_PROG_UNIT_SET_ID, STATUS
FROM IGS.IGS_SS_INQ_PROG_USET
WHERE INQ_PROG_ID = :p_inq_prog_id
AND STATUS = 'ACTIVE'
ORDER BY UNIT_SET_PREF_ID;

Another frequent use case involves data migration or cleansing scripts that update the STATUS of records based on business rules, utilizing the standard who columns to track changes. Integrity checks often involve identifying orphaned records where the INQ_PROG_ID or INQ_PROG_UNIT_SET_ID does not exist in its parent reference table.

Related Objects

Based on the provided dependency information, the IGS_SS_INQ_PROG_USET table is referenced by an APPS synonym named IGS_SS_INQ_PROG_USET, which is the standard access point for all application code. The table itself does not have documented foreign key constraints in the provided metadata, but the column names strongly imply relationships to other inquiry staging tables. The INQ_PROG_ID column is a foreign key to a parent inquiry program table (e.g., IGS_SS_INQ_PROG). Similarly, the INQ_PROG_UNIT_SET_ID column is a foreign key to a unit set definition table (e.g., IGS_SS_INQ_UNIT_SET). The unique index IGS_SS_INQ_PROG_USET_U2 on (INQ_PROG_UNIT_SET_ID, INQ_PROG_ID) enforces business rule integrity, preventing duplicate unit set associations for a given program inquiry.