Search Results step_catalog_cd




Overview
Explore in AI Chat

Overview

The IGS_AD_PER_STM_TYP table is a core reference data table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. Its primary function is to define and maintain the different types of personal statements that can be required from applicants during the admissions process. Personal statements are narrative components of an application, such as statements of purpose, essays, or letters of intent. This table acts as a master catalog for these statement types, enabling the configuration and tracking of specific requirements across different application types and programs.

Key Information Stored

The table stores the definitional attributes for each personal statement type. The primary column, PERSL_STAT_TYPE, is a unique 30-character identifier serving as the primary key. Each type is further described by the PERSL_STAT_TYPE_DESC column. A critical functional column is STEP_CATALOG_CD, which holds a foreign key reference to the IGS_TR_STEP_CTLG_ALL table. This link associates the personal statement type with a specific step in a transactional catalog, likely governing the workflow, rules, or user interface for submitting the statement. The CLOSED_IND column manages the lifecycle, indicating whether a statement type is active or archived. Standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) complete the record for auditing.

Common Use Cases and Queries

This table is central to configuring admissions requirements and reporting on applicant submissions. Common operational scenarios include setting up application types to require specific personal statements, listing all active statement types for a user interface drop-down, or identifying which statement types are linked to particular workflow steps. A frequent reporting need is to join this table with applicant data to see which statements have been submitted. A foundational query to retrieve all active personal statement types and their associated workflow steps is:

  • SELECT persl_stat_type, persl_stat_type_desc, step_catalog_cd FROM igs.igs_ad_per_stm_typ WHERE closed_ind = 'N';

For integration or data validation, a key query involves checking the integrity of the STEP_CATALOG_CD foreign key relationship or finding statement types that are not linked to any catalog step (where STEP_CATALOG_CD IS NULL).

Related Objects

The IGS_AD_PER_STM_TYP table has defined relationships with several other EBS objects, forming a key part of the admissions data model. Its primary key is referenced by two application-related tables:

  • IGS_AD_APPL_PERSTAT: The PERSL_STAT_TYPE column in this table references IGS_AD_PER_STM_TYP, linking specific personal statement submissions from an applicant to their defined type.
  • IGS_AD_APTYP_PESTAT: The PERSL_STAT_TYPE column here also references IGS_AD_PER_STM_TYP, establishing which personal statement types are required for a given application type.

Conversely, the STEP_CATALOG_CD column in IGS_AD_PER_STM_TYP is a foreign key that references the IGS_TR_STEP_CTLG_ALL table. This relationship integrates personal statement requirements with the broader transactional step catalog, which manages process flows and business rules within the system.