Search Results igs_ad_unitsets_int




Overview
Explore in AI Chat

Overview

The IGS_AD_UNITSETS_INT table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically designed for the Admissions process. It functions as an interface or staging table that temporarily holds an applicant's desired unit set details during the application import or data loading phase. Its primary role is to facilitate the transfer and validation of unit set preference data from external sources into the main transactional tables of the Student System, ensuring data integrity before it is processed into the live application records.

Key Information Stored

The table's central purpose is to store unit set preferences linked to a specific application instance within the interface. The primary key, INTERFACE_UNITSETS_ID, uniquely identifies each unit set preference record in this staging area. The most critical foreign key column is INTERFACE_PS_APPL_INST_ID, which ties each unit set record to a corresponding application instance record in the related interface table (IGS_AD_PS_APPL_INST_INT). While the provided metadata does not list all columns, typical data stored would include identifiers for the desired unit set (e.g., a code or name), a sequence or preference order, and status flags indicating the processing state of the interface record.

Common Use Cases and Queries

The primary use case involves batch data loading for admissions. An external system, such as a portal, submits application data, including unit set choices, which populate this interface table. Administrators or concurrent programs then run validation and import processes to move this data into the production tables. Common queries against this table are typically for monitoring and troubleshooting the interface queue. For example, a query to find all pending unit set preferences for a specific application batch would join on the application instance interface table using the documented foreign key.

SELECT usint.*
FROM igs.igs_ad_unitsets_int usint,
     igs.igs_ad_ps_appl_inst_int aint
WHERE usint.interface_ps_appl_inst_id = aint.interface_ps_appl_inst_id
AND aint.batch_id = '&BATCH_NUMBER'
AND usint.status = 'PENDING';

Related Objects

The table has defined relationships with other key interface tables in the Admissions schema, as per the provided metadata.

  • Primary Key: IGS_AD_UNITSETS_INT_PK on column INTERFACE_UNITSETS_ID.
  • Foreign Key (References): The table contains a foreign key column (INTERFACE_PS_APPL_INST_ID) that references the primary key of the IGS_AD_PS_APPL_INST_INT table. This establishes that every unit set preference must be associated with a valid application instance record within the interface layer.

This relationship is fundamental, ensuring that unit set data is not orphaned and is correctly scoped to a specific applicant's submission before being processed into the core system.