Search Results igs_ad_pestat_group




Overview
Explore in AI Chat

Overview

The IGS_AD_PESTAT_GROUP table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It serves as a configuration and control table for managing personal statements submitted as part of the admission process. The table's primary role is to define logical groupings for personal statements, allowing institutions to organize and associate multiple statements with specific types of admission applications. This structure supports a flexible admissions workflow where different application types may require distinct sets of personal essays or statements from prospective students.

Key Information Stored

The table stores the essential linkage between a personal statement group identifier and an application type. Its structure is defined by a composite primary key. The critical columns are:

  • GROUP_NUMBER: A numeric identifier for a specific personal statement group. This is part of the primary key.
  • ADMISSION_APPLICATION_TYPE: A code that identifies the type of admission application (e.g., undergraduate, graduate, transfer). This column is both part of the primary key and a foreign key referencing the IGS_AD_SS_APPL_TYP table, ensuring data integrity by linking groups only to valid, predefined application types.

Together, these columns enforce a rule that a unique group is defined for each combination of group number and application type, preventing duplicate configurations.

Common Use Cases and Queries

This table is primarily accessed during the setup and execution of the admissions process. Administrators use it to configure which personal statement prompts or groups are required for a given application type. A common operational use case is retrieving all configured statement groups for a specific application type to display to an applicant or to validate that an application submission is complete. A typical query would join this table to the application type master table for descriptive information:

  • Sample Query: SELECT g.group_number, t.application_type_name FROM igs_ad_pestat_group g, igs_ad_ss_appl_typ t WHERE g.admission_application_type = t.admission_application_type AND t.admission_application_type = 'UG_FRESHMAN';

Reporting use cases include auditing admission configurations and analyzing the relationship between application types and the personal statement requirements imposed on applicants.

Related Objects

The IGS_AD_PESTAT_GROUP table has a direct, documented relationship with one other key table in the Student System schema, as defined by its foreign key constraint.

  • IGS_AD_SS_APPL_TYP: This is the master table for admission application types. The relationship is established via the ADMISSION_APPLICATION_TYPE column in IGS_AD_PESTAT_GROUP, which references the corresponding column in IGS_AD_SS_APPL_TYP. This ensures that every personal statement group is associated with a valid and existing application type. The primary key of IGS_AD_PESTAT_GROUP itself (GROUP_NUMBER, ADMISSION_APPLICATION_TYPE) is likely referenced by other transactional tables (such as those storing actual statement text) which, while not listed in the provided metadata, are standard in this functional area.