Search Results igs_ad_ps_appl_inst_int

Overview

The IGS_AD_PS_APPL_INST_INT table is a core interface table within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to serve as a staging area for application instance details related to a person's admission application. As an interface table, it is designed to receive data from external or feeder systems, such as online application portals, before this data is validated and processed into the main transactional tables of the Oracle EBS application. This design pattern ensures data integrity and allows for error correction before committing records to the production environment. The table is owned by the IGS schema and is a critical component in the admissions data flow.

Key Information Stored

While the provided metadata does not list specific column names beyond key identifiers, the table's structure is defined by its primary and foreign key relationships. The central column is INTERFACE_PS_APPL_INST_ID, which serves as the unique primary key for each application instance record staged in the interface. Another crucial column is INTERFACE_APPL_ID, a foreign key that links each application instance to its parent application header record in the IGS_AD_APL_INT table. This establishes the fundamental hierarchy. Typically, interface tables in this context also store data such as the academic program applied for, the intended admission term or period, the application status within the interface, and various dates related to the application instance. The table's purpose is to hold this detailed instance information in a normalized structure, separate from the main application header.

Common Use Cases and Queries

The primary use case for this table is the batch processing of admissions application data. Data is inserted into IGS_AD_PS_APPL_INST_INT and its related interface tables, after which a concurrent request or API validates and transfers the data into the base EBS tables. Common operational queries involve checking for unprocessed records, identifying records with validation errors, or reconciling data between the interface and the base tables. A typical reporting query might join this table to the parent application interface table to get a complete view of staged applications.

• Finding Staged Application Instances for a Specific Program: SELECT * FROM igs.igs_ad_ps_appl_inst_int i WHERE i.program_code = :p_program AND i.process_status = 'PENDING';
• Counting Application Instances by Interface Run: SELECT interface_run_id, COUNT(interface_ps_appl_inst_id) FROM igs.igs_ad_ps_appl_inst_int GROUP BY interface_run_id;
• Joining to Parent Application Header: SELECT a.applicant_number, i.* FROM igs.igs_ad_apl_int a, igs.igs_ad_ps_appl_inst_int i WHERE a.interface_appl_id = i.interface_appl_id;

Related Objects

The IGS_AD_PS_APPL_INST_INT table sits at the center of a network of related interface tables, managing detailed sub-components of an application instance. It references the parent application header via a foreign key and is itself referenced by several detail tables.

• Parent Table (Foreign Key Reference):
  • IGS_AD_APL_INT: Linked via IGS_AD_PS_APPL_INST_INT.INTERFACE_APPL_ID. This is the primary application header interface table.
• Child Tables (Referenced by Foreign Keys):
  • IGS_AD_UNITSETS_INT: Links via INTERFACE_PS_APPL_INST_ID. Holds interface data for unit sets (majors/minors) requested for this application instance.
  • IGS_AD_UNITSETS_INT_ALL: Links via INTERFACE_PS_APPL_INST_ID. Likely an "all" version for hierarchical security.
  • IGS_AD_NOTES_INT: Links via INTERFACE_PS_APPL_INST_ID. Holds interface data for notes attached to this application instance.
  • IGS_AD_NOTES_INT_ALL: Links via INTERFACE_PS_APPL_INST_ID. An "all" version for notes.
  • IGS_AD_EDUGOAL_INT: Links via INTERFACE_PS_APPL_INST_ID. Holds interface data for educational goals related to this application instance.
  • IGS_AD_EDUGOAL_INT_ALL: Links via INTERFACE_PS_APPL_INST_ID. An "all" version for educational goals.