Search Results igs_ad_per_stm_typ




Overview
Explore in AI Chat

Overview

The table IGS_AD_PER_STM_TYP is a core data definition table within the Oracle E-Business Suite (EBS) Student System (IGS), specifically in the Admissions module. Its primary function is to serve as a reference or lookup table for categorizing different types of personal statements submitted by applicants during the admissions process. These personal statement types allow institutions to define and manage various narrative components required for an application, such as a statement of purpose, a diversity essay, or a research proposal. As indicated by the ETRM metadata, this table is part of the "Student System (Obsolete)" product line, signifying it belongs to a legacy codebase that may have been superseded by later versions of Oracle's Student Management product. The metadata also explicitly notes "Not implemented in this database," which suggests this specific table may not be populated or actively used in a standard EBS 12.1.1 or 12.2.2 installation without the corresponding IGS module.

Key Information Stored

The table's structure is centered on a single primary key column that defines the statement type code. Based on the provided relationship data, the key column is PERSL_STAT_TYPE. This column stores the unique identifier or code for each type of personal statement (e.g., 'PURPOSE', 'DIVERSITY'). The table also contains a foreign key column, STEP_CATALOG_CD, which references the IGS_TR_STEP_CTLG_ALL table. This relationship implies that personal statement types can be linked to specific steps or tasks within a defined process catalog, potentially for workflow or requirement tracking. While the full column list is not provided, typical supporting columns in such a reference table would include a description field (e.g., DESCRIPTION), an active/inactive indicator (e.g., CLOSED_IND), and standard WHO columns for tracking creation and modification details.

Common Use Cases and Queries

The primary use case is to validate and categorize the personal statement data entered against an application. When an applicant submits a narrative, it is stored in a related table (like IGS_AD_APPL_PERSTAT) with a foreign key pointing to the PERSL_STAT_TYPE in this table. Common operational and reporting queries would involve joining to this table to translate codes into meaningful descriptions. For instance, a query to list all personal statements for an application would join IGS_AD_APPL_PERSTAT to IGS_AD_PER_STM_TYP. Administrators might also run maintenance queries to manage the list of active statement types. A sample SQL pattern to fetch all defined types would be: SELECT persl_stat_type, description FROM igs_ad_per_stm_typ WHERE closed_ind = 'N';. Reporting on application completeness by required statement type would also be a typical use case, leveraging the relationship to the process step catalog.

Related Objects

The ETRM documentation specifies clear foreign key relationships for this table, defining its integration points within the Admissions module.

  • Referenced by this table (Outgoing FK): The column STEP_CATALOG_CD in IGS_AD_PER_STM_TYP references the IGS_TR_STEP_CTLG_ALL table. This links a personal statement type to a step in a transactional process catalog.
  • References this table (Incoming FKs):
    • The table IGS_AD_APPL_PERSTAT references IGS_AD_PER_STM_TYP via its PERSL_STAT_TYPE column. This is the primary transactional link, storing the actual personal statement content for an application against a specific type.
    • The table IGS_AD_APTYP_PESTAT references IGS_AD_PER_STM_TYP via its PERSL_STAT_TYPE column. This table likely governs which personal statement types are required or allowed for specific application types, establishing business rules.