Search Results igs_ad_unitsets_int_all

Overview

The table IGS_AD_UNITSETS_INT_ALL is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as an interface or staging table designed to hold detailed information regarding an applicant's desired unit sets or academic plans during the admissions process. Its primary role is to facilitate the intake and validation of applicant preference data before it is processed and potentially transferred into the main transactional tables of the system. The "_ALL" suffix indicates it is a multi-org table capable of storing data for multiple operating units. Notably, the provided metadata states it is "Not implemented in this database," suggesting it may be part of a specific interface model or a legacy structure that is not active in all deployment instances of EBS 12.1.1 or 12.2.2.

Key Information Stored

While the specific column list is not detailed in the provided excerpt, the table's description and key relationships define its critical data elements. The central piece of information is the applicant's desired unit set details. The primary key column, INTERFACE_UNITSETS_ID, uniquely identifies each record within this interface table. The essential foreign key column, INTERFACE_PS_APPL_INST_ID, links each unit set preference record to a specific applicant and application instance within the related interface table IGS_AD_PS_APPL_INST_INT. This structure implies the table would also contain columns specifying the unit set code, version, and potentially a preference ranking or effective term.

Common Use Cases and Queries

The primary use case revolves around batch processing of applicant data. Admissions data loaded from external systems, such as application portals, can be inserted into this interface table. Subsequent validation and processing logic would then review these records. Common operational queries would involve joining to the parent application interface table to review or troubleshoot an applicant's complete submitted preferences before formal acceptance into the student system. A typical reporting query might follow this pattern:

• SELECT appl.APPLICANT_NUMBER, uset.UNIT_SET_CD, uset.VERSION_NUMBER
• FROM IGS_AD_UNITSETS_INT_ALL uset,
• IGS_AD_PS_APPL_INST_INT appl
• WHERE uset.INTERFACE_PS_APPL_INST_ID = appl.INTERFACE_PS_APPL_INST_ID
• AND appl.APPLICATION_STATUS = 'SUBMITTED';

Related Objects

The table maintains a direct and critical relationship with the applicant application interface table, as documented by its foreign key. The relationship is as follows:

• Parent Table: IGS_AD_PS_APPL_INST_INT
• Relationship: The column IGS_AD_UNITSETS_INT_ALL.INTERFACE_PS_APPL_INST_ID is a foreign key referencing the IGS_AD_PS_APPL_INST_INT table. This enforces that every unit set preference must be associated with a valid application interface record.

As an interface table, it is likely referenced by or feeds into standard Student System APIs or concurrent programs responsible for importing applicant data, though these are not explicitly listed in the provided metadata. Its data ultimately corresponds to transactional tables in the IGS product area, such as those managing student program enrollments and plans.