Results for “igs_ad_aptyp_pestat”

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

Overview

IGS_AD_APTYP_PESTAT is a configuration table in the Oracle E-Business Suite Student System (IGS) module. It records the personal statement requirements that apply to a given admission application type. In practice, the table answers the question: for a particular category of admission application, which personal statement types are required or permitted, and in what grouping?

The table is delivered in the IGS schema and is marked VALID in the documented metadata for release 12.1.1, with the same structure carried forward in 12.2.x. The ETRM description is "Application Type Personal Statements". The table contains nine documented columns and is governed by the primary key constraint IGS_AD_APTYP_PERSTAT_PK over (ADMISSION_APPLICATION_TYPE, PERSL_STAT_TYPE), supported by the unique index IGS_AD_APTYP_PESTAT_U1 on the same column pair.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is best modelled as a link. It resolves a many-to-many relationship between admission application types and personal statement types, carrying descriptive attributes (MANDATORY, GROUP_NUMBER) that qualify the association.

Key Information Stored

The most significant columns are:

• ADMISSION_APPLICATION_TYPE — part of the composite primary key; identifies the admission application type to which the personal statement rule applies. Foreign key to IGS_AD_SS_APPL_TYP.
• PERSL_STAT_TYPE — part of the composite primary key; identifies the personal statement type. Foreign key to IGS_AD_PER_STM_TYP.
• MANDATORY — flag indicating whether the personal statement is compulsory for the associated application type.
• GROUP_NUMBER — groups related personal statement requirements, allowing several statements to be treated as a set.
• CREATED_BY, CREATION_DATE — standard WHO audit columns recording creation context.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns recording the most recent modification.

The surrogate primary key is IGS_AD_APTYP_PERSTAT_PK. The business-key candidate, as evidenced by the unique index IGS_AD_APTYP_PESTAT_U1, is the pair (ADMISSION_APPLICATION_TYPE, PERSL_STAT_TYPE): no two rows may define the same statement rule twice for one application type.

Common Use Cases and Queries

The principal use case is determining the personal statement checklist presented to an applicant during the admissions process. A typical query lists mandatory statements for an application type:

• SELECT persl_stat_type, group_number FROM igs_ad_aptyp_pestat WHERE admission_application_type = :app_type AND mandatory = 'Y';
• SELECT a.admission_application_type, a.persl_stat_type, t.description FROM igs_ad_aptyp_pestat a, igs_ad_per_stm_typ t WHERE a.persl_stat_type = t.persl_stat_type;

Reporting scenarios include auditing which application types enforce personal statements, comparing voluntary versus mandatory statements across application types, and validating admission setup after a configuration migration. Setup validation queries commonly join to IGS_AD_SS_APPL_TYP to resolve application type descriptions for user-facing reports.

Related Objects

The following objects are most significant in relation to this table:

• IGS_AD_PER_STM_TYP — referenced through PERSL_STAT_TYPE; the personal statement type definition.
• IGS_AD_SS_APPL_TYP — referenced through ADMISSION_APPLICATION_TYPE; the admission application type definition.
• IGS_AD_APTYP_PESTAT_U1 — the unique index enforcing the business key.
• IGS_AD_APTYP_PERSTAT_PK — the primary key constraint.

These relationships confirm that IGS_AD_APTYP_PESTAT functions as the associative link connecting application types and personal statement types within the Oracle Student System admissions configuration model.