Search Results appl_perstat_id




Overview
Explore in AI Chat

Overview

The IGS_AD_APPL_PERSTAT table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. It serves as the definitive store for personal statement details associated with an applicant's admission application. Its primary role is to track and manage supplementary narrative materials submitted by prospective students, linking each statement to a specific applicant, application number, and defined statement type. This structured storage is critical for application completeness reviews, decision-making workflows, and maintaining a comprehensive applicant profile.

Key Information Stored

The table's structure captures the essential metadata for each personal statement record. The key business columns include APPL_PERSTAT_ID (the unique system-generated identifier), PERSON_ID and ADMISSION_APPL_NUMBER (which together link the statement to a specific application), and the pivotal PERSL_STAT_TYPE. The PERSL_STAT_TYPE column defines the category or purpose of the attached statement (e.g., Statement of Purpose, Diversity Essay). The DATE_RECEIVED column tracks when the statement was formally logged. Standard EBS WHO columns (CREATED_BY, CREATION_DATE, etc.) and Concurrent Program columns (REQUEST_ID, PROGRAM_ID, etc.) provide audit trails and process integration context.

Common Use Cases and Queries

A primary use case is generating reports on application document completeness, such as identifying applicants who have or have not submitted a required personal statement type. Administrators also query this table to retrieve statements for review by an admissions committee. Common SQL patterns involve joining to person and application header tables. For instance, to find all personal statements for a specific application, one would use:

  • SELECT pst.PERSL_STAT_TYPE, pst.DATE_RECEIVED FROM IGS_AD_APPL_PERSTAT pst WHERE pst.PERSON_ID = :1 AND pst.ADMISSION_APPL_NUMBER = :2;

Another frequent query leverages the non-unique index on PERSL_STAT_TYPE (IGS_AD_APPL_PERSTAT_N2) to find all applications that include a particular type of statement, which is essential for batch processing or compliance checks.

Related Objects

The table maintains defined referential integrity through foreign key relationships, ensuring data consistency across the admissions subsystem. As documented in the relationship data:

  • The PERSON_ID and ADMISSION_APPL_NUMBER columns reference the core application entity, TABLE: IGS.IGS_AD_APPL_ALL. This links each personal statement to its parent application record.
  • The PERSL_STAT_TYPE column references TABLE: IGS.IGS_AD_PER_STM_TYP. This validates the statement type against a configured list of valid types maintained within the application.

The table's primary key, IGS_AD_APPL_PERSTAT_PK, is referenced by other objects within the APPS schema, indicating it is a foundational entity for building application personal statement functionality in the user interface and related processes.