Results for “igs_ad_per_stm_typ”

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

Overview

The IGS_AD_PER_STM_TYP table belongs to the IGS – Student System product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the defining reference table for Personal Statement Types used in the admissions and application processing flow of the Oracle Student System. A personal statement is a free-text or structured declaration submitted by an applicant as part of an admissions application, and the type codes stored in this table classify and control how each statement is presented, validated, and processed downstream. The table carries the description "This table holds the Personal Statement Types" and exposes nine documented columns in the 12.1.1 physical schema owned by the IGS schema.

The ETRM implementation notes state that the object is "Not implemented in this database," indicating that in many installations the table exists as a shipped seed or stub object without populated rows, and that any use is highly dependent on whether the Student System modules for admissions have been deployed. Its heuristic Data Vault classification is hub-leaning, which suggests modeling it as a hub entity keyed on the personal statement type code, with dependent descriptive attributes treated as satellite data rather than as part of the key. This classification is a modeling suggestion derived from the surrounding foreign-key topology, not a documented physical constraint.

Key Information Stored

The table's primary key is IGS_AD_PER_STM_TYP_PK, defined on the single column PERSL_STAT_TYPE. Because this column is also the sole business-key candidate in the unique index, PERSL_STAT_TYPE functions simultaneously as the surrogate identifier and the natural business key for the personal statement type.

• PERSL_STAT_TYPE — the primary key and business identifier for each personal statement type.
• PERSL_STAT_TYPE_DESC — the descriptive label presented to users when selecting or reporting on statement types.
• STEP_CATALOG_CD — foreign key to IGS_TR_STEP_CTLG_ALL, linking the statement type to an admissions processing step in the step catalog.
• CLOSED_IND — flag indicating whether the personal statement type is closed for new use, providing soft-retirement control without deletion.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO columns for audit and concurrency tracking.

Common Use Cases and Queries

Typical reporting and validation scenarios resolve personal statement types against applicant records and step catalog definitions. A frequent pattern joins the type to the step catalog to present a complete admissions requirement line:

SELECT p.PERSL_STAT_TYPE, p.PERSL_STAT_TYPE_DESC, p.CLOSED_IND, s.STEP_CATALOG_CD
FROM IGS_AD_PER_STM_TYP p
LEFT JOIN IGS_TR_STEP_CTLG_ALL s ON p.STEP_CATALOG_CD = s.STEP_CATALOG_CD;

Admissions users query the table to populate value lists for statement type selection and to identify active versus closed types. Integration and audit queries count dependent records by joining to IGS_AD_APPL_PERSTAT and IGS_AD_APTYP_PESTAT on PERSL_STAT_TYPE. Because the object may be unimplemented, production queries should first confirm seed data presence.

Related Objects

• IGS_TR_STEP_CTLG_ALL — referenced via IGS_AD_PER_STM_TYP.STEP_CATALOG_CD, the parent step catalog definition.
• IGS_AD_APPL_PERSTAT — references this table through PERSL_STAT_TYPE, storing applicant-level personal statements.
• IGS_AD_APTYP_PESTAT — references this table through PERSL_STAT_TYPE, defining which statement types apply to each application type.
• IGS_AD_PER_STM_TYP_PK — the primary key index supporting lookups and FK enforcement.

Together these objects form the admissions personal-statement configuration chain from step catalog through type definition to applicant submission.