Search Results personal_statement




Overview
Explore in AI Chat

Overview

IGS_AD_PER_STM_TYP_V is a database view owned by the APPS schema in Oracle E-Business Suite, belonging to the Student System (IGS) product family and more specifically to the Admissions (AD) module. It exposes configuration and reference data describing personal statement types — the categories of personal statements that applicants may be required or permitted to submit as part of an admissions application. Each row represents one personal statement type, joined to the corresponding student tracking step catalog definition.

For users who search on the term "personal_statement," this view is the principal reporting and integration access point. The literal value 'PERSONAL_STATEMENT' appears as a filter predicate inside the view definition itself, restricting the step catalog join to those tracking step definitions that are typed as personal statements. Consequently the view presents a clean, pre-filtered list of personal statement types without requiring callers to know the underlying tracking step type code. It is typically consumed by forms, concurrent programs, OAF pages, and custom reporting or inbound/outbound interfaces that need to resolve a personal statement type code to its descriptive text.

Underlying Base Objects

The view is defined over two base tables, joined with an outer join construct:

  • IGS_AD_PER_STM_TYP PST — the driving table holding personal statement type definitions. The view aliases it as PST and sources the majority of its columns from here.
  • IGS_TR_STEP_CTLG TSC — the student tracking step catalog, aliased as TSC. It supplies the catalog description associated with each statement type's step catalog code.

The join is expressed as PST.STEP_CATALOG_CD = TSC.STEP_CATALOG_CD (+), with an additional outer-join predicate TSC.S_TRACKING_STEP_TYPE(+) = 'PERSONAL_STATEMENT'. The (+) notation indicates Oracle's legacy outer join syntax, making the step catalog the optional side: a personal statement type still appears even when no matching step catalog row of the personal statement type exists, in which case the catalog description columns return NULL. Although the documented referenced base objects list is empty, the view text unambiguously identifies these two tables as the sources.

Key Columns

  • ROWID — the row identifier of the underlying IGS_AD_PER_STM_TYP row, exposed for updatable-view and DML support.
  • PERSL_STAT_TYPE — the unique code identifying the personal statement type.
  • PERSL_STAT_TYPE_DESC — the descriptive name of the personal statement type, typically the value displayed to end users.
  • STEP_CATALOG_CD — the code linking the statement type to a student tracking step catalog entry.
  • DESCRIPTION — the description of the associated tracking step catalog row; NULL when no matching personal statement step exists.
  • CLOSED_IND — indicates whether the personal statement type is closed (inactive) and therefore unavailable for new use.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO columns recording audit and concurrency information.

Common Use Cases and Queries

Typical uses include populating a list of values for personal statement type selection, validating an incoming statement type code during application processing, and reporting on active statement types. A basic retrieval of all open personal statement types follows:

  • SELECT persl_stat_type, persl_stat_type_desc, step_catalog_cd, description FROM apps.igs_ad_per_stm_typ_v WHERE closed_ind = 'N' ORDER BY persl_stat_type_desc;
  • SELECT persl_stat_type_desc, description FROM apps.igs_ad_per_stm_typ_v WHERE persl_stat_type = :p_type;

Reporting queries frequently join the view to admission application and tracking tables to show which statement types an applicant has been assigned. Because the view already constrains the step catalog to the PERSONAL_STATEMENT type, consumers need not supply that filter, reducing the risk of mismatched step types in integration code.