Results for “disp_order”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_SS_APPL_PGS is a transactional configuration table within the Oracle E-Business Suite Student System (IGS) product family. It holds the Self Service page names that are attached to an Admission Application Type, effectively defining which self-service pages (steps, forms, or informational screens) are presented to an applicant when they work through a specific admission application type in the self-service admissions flow.

In Oracle EBS 12.1.1 and 12.2.2, the IGS schema underpins the Student System modules. This table acts as the presentation-layer configuration that maps application types to the pages a prospective student must view, complete, or acknowledge during the online admission application process. It therefore controls both the composition and the ordering of the self-service application experience.

From a Data Vault modeling perspective, the heuristic classification of this table is satellite-leaning. Its primary key is composed entirely of business keys (PAGE_NAME and ADMISSION_APPLICATION_TYPE), and it carries descriptive attributes such as INCLUDE_IND, REQUIRED_IND, and DISP_ORDER. In Data Vault terms, these descriptive attributes would typically reside in a satellite attached to a link between the page and application type hubs, rather than in a hub or link itself. This is a modeling suggestion only; the physical object remains a conventional relational configuration table.

Key Information Stored

The table contains eleven documented columns. The most important include:

• PAGE_NAME — Identifier of the self-service page. Part of the composite primary key and of the unique business-key index.
• ADMISSION_APPLICATION_TYPE — The admission application type to which the page is attached. Also part of the composite primary key and unique index. References IGS_AD_SS_APPL_TYP.
• INCLUDE_IND — Indicator controlling whether the page is included for the given application type.
• REQUIRED_IND — Indicator controlling whether the applicant is required to complete or view the page.
• DISP_ORDER — Numeric sequence governing the display order of pages within the application flow.
• PAGE_DISP_NAME — The display name presented to the applicant for the page.

Standard Oracle EBS audit columns are also present: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. The surrogate primary key is IGS_AD_SS_APPL_PGS_PK, defined over PAGE_NAME and ADMISSION_APPLICATION_TYPE together. The unique index IGS_AD_SS_APPL_PGS_U1 covers the same pair and serves as the documented business-key candidate, confirming that the combination of page and application type is unique.

Common Use Cases and Queries

Typical usage focuses on configuring and auditing the self-service admission application flow. Administrators query this table to understand which pages appear for a given application type, in what order, and whether each is required. Reporting queries commonly join to IGS_AD_SS_APPL_TYP to retrieve descriptive admission application type information.

• Listing all pages for an application type, ordered by display sequence: SELECT PAGE_NAME, PAGE_DISP_NAME, REQUIRED_IND, DISP_ORDER FROM IGS_AD_SS_APPL_PGS WHERE ADMISSION_APPLICATION_TYPE = :appl_type ORDER BY DISP_ORDER;
• Identifying required pages: filter on REQUIRED_IND = 'Y' to produce a checklist of mandatory steps.
• Auditing configuration changes: query on LAST_UPDATE_DATE and LAST_UPDATED_BY to trace recent modifications.
• Verifying coverage: left-join against IGS_AD_SS_APPL_COMPS using PAGE_NAME and ADMISSION_APPLICATION_TYPE to confirm that configured pages have corresponding component definitions.

Related Objects

The following objects are directly related to IGS_AD_SS_APPL_PGS through documented foreign key and primary key relationships:

• IGS_AD_SS_APPL_TYP — Referenced by IGS_AD_SS_APPL_PGS.ADMISSION_APPLICATION_TYPE; the parent admission application type definition.
• IGS_AD_SS_APPL_COMPS — References this table via PAGE_NAME and ADMISSION_APPLICATION_TYPE; holds the component-level detail for each self-service page.
• IGS_AD_SS_APPL_PGS_PK — Primary key constraint on PAGE_NAME and ADMISSION_APPLICATION_TYPE.
• IGS_AD_SS_APPL_PGS_U1 — Unique business-key index on PAGE_NAME and ADMISSION_APPLICATION_TYPE.

These relationships position IGS_AD_SS_APPL_PGS as the bridge between application types and the page-level components that render the self-service admissions experience in Oracle EBS.