Search Results igs_ad_aptyp_pestat




Overview
Explore in AI Chat

Overview

The table IGS_AD_APTYP_PESTAT is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a junction table that defines the valid relationships between admission application types and the types of personal statements required from applicants. Its primary role is to enforce business rules by controlling which personal statement types are applicable to a given application type, thereby ensuring data integrity and consistency in the admissions process. This configuration is essential for tailoring the application experience and capturing relevant applicant information based on the specific program or admission pathway.

Key Information Stored

The table's structure is defined by its two primary key columns, which together form the unique identifier IGS_AD_APTYP_PERSTAT_PK. The ADMISSION_APPLICATION_TYPE column stores the code identifying a specific category or process for admission applications. The PERSL_STAT_TYPE column stores the code for a defined type of personal statement or essay required from the applicant. The table does not store the personal statement content itself, but rather the rule that a particular statement type is mandatory or permissible for a specific application type. This simple yet critical structure acts as a master validation table for the admissions application entry forms.

Common Use Cases and Queries

A primary use case is the dynamic configuration of application interfaces. When an applicant begins a new application for a specific type, the system queries this table to determine which personal statement sections to present. Administrators use maintenance screens to manage these associations. Common reporting and validation queries include listing all personal statement types required for an application type or identifying application types that require a specific statement. A typical SQL pattern would be a join to the related descriptive tables:

  • To retrieve all configured rules with descriptions: SELECT aat.admission_appl_type_code, pst.persl_stat_type, aat.description appl_type_desc, pst.description stat_desc FROM igs_ad_aptyp_pestat aps JOIN igs_ad_ss_appl_typ aat ON aps.admission_application_type = aat.admission_appl_type_code JOIN igs_ad_per_stm_typ pst ON aps.persl_stat_type = pst.persl_stat_type;
  • To find all personal statement types for a given application type 'UG_FRESHMAN': SELECT persl_stat_type FROM igs_ad_aptyp_pestat WHERE admission_application_type = 'UG_FRESHMAN';

Related Objects

IGS_AD_APTYP_PESTAT maintains defined foreign key relationships with two key master tables, ensuring referential integrity. The table is centrally linked within the Admissions module's data model.

  • IGS_AD_SS_APPL_TYP: The ADMISSION_APPLICATION_TYPE column references this table, which defines all valid admission application types (e.g., Undergraduate, Graduate, Transfer).
  • IGS_AD_PER_STM_TYP: The PERSL_STAT_TYPE column references this table, which is the master list of all defined personal statement types (e.g., Statement of Purpose, Diversity Essay, Career Goals).

This table is likely referenced by application entry forms and APIs that validate or process applicant-submitted personal statements against the configured rules.