Search Results igs_ad_ss_appl_comps_pk

Overview

The IGS_AD_SS_APPL_COMPS table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a configuration and mapping table that defines the user interface components available to applicants during the online admission process. Its primary role is to manage the association between specific Self Service web pages, their constituent components (such as fields, sections, or blocks), and defined Admission Application Types. This enables institutions to tailor the online application experience dynamically based on the type of application being submitted, ensuring that applicants only see relevant data entry screens and questions.

Key Information Stored

The table's structure is defined by a composite primary key, which uniquely identifies each configuration record. The key columns are ADMISSION_APPLICATION_TYPE, which categorizes the application (e.g., undergraduate, graduate, international); PAGE_NAME, which identifies the specific Self Service page within the application flow; and COMPONENT_CODE, which specifies the individual UI component rendered on that page. Collectively, these columns store the essential mapping that dictates the composition of the online application form. The table does not store the component's data or logic but serves as a junction point linking application types to their required page components.

Common Use Cases and Queries

A primary use case is the administrative setup and maintenance of online application forms. An administrator can query this table to audit or modify the components attached to a specific application type. For reporting, it is often joined with the IGS_AD_SS_APPL_PGS table to get descriptive page information. Common SQL patterns include listing all components for a given application type and page, or identifying which application types use a specific component. For example:

• SELECT component_code FROM igs_ad_ss_appl_comps WHERE admission_application_type = 'UG' AND page_name = 'PERSONAL_INFO';
• SELECT aat.page_name, comp.component_code FROM igs_ad_ss_appl_comps comp JOIN igs_ad_ss_appl_pgs aat ON comp.page_name = aat.page_name AND comp.admission_application_type = aat.admission_application_type WHERE comp.admission_application_type = 'GRAD';

Related Objects

The table maintains a critical foreign key relationship with the IGS_AD_SS_APPL_PGS table, which defines the Self Service pages themselves. The join is performed on two columns: PAGE_NAME and ADMISSION_APPLICATION_TYPE. This relationship ensures referential integrity, meaning a component can only be assigned to a page that is already defined for that specific admission application type. The primary key constraint IGS_AD_SS_APPL_COMPS_PK enforces uniqueness for these combinations. As a configuration table for the admission self-service flow, it is indirectly referenced by the underlying application engine and user interface logic that renders the online forms.