Search Results admission_application_type




Overview
Explore in AI Chat

Overview

The IGS_AD_APTYP_PESTAT table is a configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, under the IGS (iGrants) schema. Its primary function is to define the relationship between admission application types and the personal statements required from applicants. The table acts as a junction entity, mapping which personal statement types are applicable to a given application type, thereby enforcing business rules for the admissions process. This configuration is critical for guiding applicants through the submission of required narrative components and for administrative validation of application completeness.

Key Information Stored

The table stores the core mapping data and associated control attributes. The primary business columns are ADMISSION_APPLICATION_TYPE and PERSL_STAT_TYPE, which together form the table's unique primary key. The GROUP_NUMBER column allows for the logical grouping of multiple personal statements, potentially for presentation or processing order. The MANDATORY column is a critical control flag indicating whether a specific personal statement type is compulsory for the associated application type. Standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information for each record.

Common Use Cases and Queries

A primary use case is the dynamic generation of the personal statement requirements section within an online application form, based on the applicant's chosen application type. System administrators use this table to maintain admission rules. Common reporting and validation queries include listing all mandatory statements for an application type or identifying all application types that require a specific personal statement. A typical query to retrieve the full configuration for a specific application type would be:

  • SELECT persl_stat_type, group_number, mandatory
  • FROM igs.igs_ad_aptyp_pestat
  • WHERE admission_application_type = '&APPLICATION_TYPE_CODE'
  • ORDER BY group_number;

Another common pattern is a validation check within a PL/SQL procedure to confirm an applicant has submitted all required statements before allowing final submission.

Related Objects

The table maintains strict referential integrity through defined foreign key relationships, ensuring that only valid codes are used in its configuration. It references two key master tables:

  • IGS_AD_SS_APPL_TYP: The foreign key from the ADMISSION_APPLICATION_TYPE column ensures the mapping is linked to a valid, defined admission application type within the system.
  • IGS_AD_PER_STM_TYP: The foreign key from the PERSL_STAT_TYPE column ensures the personal statement type is a valid, pre-configured statement category (e.g., "Statement of Purpose," "Diversity Essay").

The table itself is referenced by the APPS synonym IGS_AD_APTYP_PESTAT, which is the standard access point for all application-tier code and reports. Its primary key constraint is named IGS_AD_APTYP_PERSTAT_PK.