Results for “igs_ad_per_stm_typ_v”

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

Overview

IGS_AD_PER_STM_TYP_V is a database view in the Oracle E-Business Suite IGS (Student System) product family, documented as the Admission Personal Statements Type view. It presents the configuration of personal statement types used during the admissions process, where applicants supply free-form narrative responses as part of their application. The view joins the personal statement type definition to its associated tracking step catalog entry, exposing both the internal type code and the descriptive text that end users recognize. Its principal reporting role is to provide a denormalized, human-readable lookup of personal statement types and their catalog descriptions for use in admissions reports, extracts, and integrations.

Within the ETRM 12.1.1 and 12.2.2 documentation, this object is flagged as belonging to IGS – Student System (Obsolete), and the implementation notes state "Not implemented in this database." In practice, the view exists in legacy or historical IGS installations but is not present in the queried environment. The user search term persl_stat_type_desc maps directly to the PERSL_STAT_TYPE_DESC column, which is the display name for a personal statement type and is the most commonly referenced attribute when building admissions-related queries.

Underlying Base Objects

The view text is defined over two base tables:

• IGS_AD_PER_STM_TYP PST — the primary table holding personal statement type definitions.
• IGS_TR_STEP_CTLG TSC — the tracking step catalog, supplying step-level descriptions and step type classification.

The join is an outer join from the catalog side: PST.STEP_CATALOG_CD = TSC.STEP_CATALOG_CD (+) combined with TSC.S_TRACKING_STEP_TYPE (+) = 'PERSONAL_STATEMENT'. Because the catalog is outer-joined and additionally constrained to the PERSONAL_STATEMENT step type, personal statement types whose catalog code has no matching step—or whose matching step is of a different type—still appear in the result set, with the catalog description columns returning null. This makes the view effectively a master list of personal statement types enriched wherever possible with tracking step metadata.

Key Columns

• ROW_ID — the row identifier carried forward from the base table (PST.ROWID), exposed for uniqueness and locking purposes.
• PERSL_STAT_TYPE — the internal code identifying the personal statement type.
• PERSL_STAT_TYPE_DESC — the descriptive name of the personal statement type; this is the column targeted by the search term persl_stat_type_desc and is typically the field displayed in reports.
• STEP_CATALOG_CD — the tracking step catalog code linked to the type.
• STEP_CODE_DESCRIPTION — the catalog description sourced from IGS_TR_STEP_CTLG.DESCRIPTION.
• CLOSED_IND — indicates whether the personal statement type is closed (inactive) or open for use.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle audit columns tracking who created and last modified each record and when.

Common Use Cases and Queries

Typical uses include populating pick lists of active personal statement types, reporting on admissions configuration, and reconciling personal statement types against tracking step catalog entries. The following query returns all open personal statement types with their catalog descriptions:

SELECT persl_stat_type,
       persl_stat_type_desc,
       step_catalog_cd,
       step_code_description
FROM   igs_ad_per_stm_typ_v
WHERE  closed_ind = 'N'
ORDER BY persl_stat_type_desc;

To locate a specific statement type by description, filtering on the searched column is the most direct approach:

SELECT persl_stat_type, persl_stat_type_desc, step_catalog_cd
FROM   igs_ad_per_stm_typ_v
WHERE  UPPER(persl_stat_type_desc) LIKE UPPER('%TRANSCRIPT%');

A third common pattern identifies configuration gaps, where a personal statement type has no matching tracking step catalog description:

SELECT p.persl_stat_type, p.persl_stat_type_desc, p.step_catalog_cd
FROM   igs_ad_per_stm_typ_v p
WHERE  p.step_code_description IS NULL;

Because the object is documented as not implemented in the current database and belongs to an obsolete IGS module, queries should be validated for availability in the target environment before deployment. Where the view is absent, equivalent results can ordinarily be obtained by querying IGS_AD_PER_STM_TYP and IGS_TR_STEP_CTLG directly and applying the same outer-join and step-type conditions.