Search Results s_adm_appl_status




Overview
Explore in AI Chat

Overview

The view APPS.IGS_AD_APPL_STAT_V is a validation and descriptive view within the Oracle E-Business Suite (EBS) Student Systems / Oracle Student System (OSS) product family, specifically the Admissions module. The object name searched, s_adm_appl_status, corresponds directly to the S_ADM_APPL_STATUS column projected by this view, confirming that IGS_AD_APPL_STAT_V is the intended lookup surface for admission application status codes.

The view presents the set of valid admission application statuses used to drive the lifecycle of an applicant record, from initial entry through decision, offer, acceptance, and closure. Its principal function is to join the underlying status definition table with the Oracle EBS lookup mechanism so that each stored status code is accompanied by its user-facing meaning and its closed indicator. This design allows forms, concurrent programs, and reports to display decoded status values without reimplementing lookup logic, and it provides referential integrity between an application status code and the ADM_APPL_STATUS lookup type.

Because it is defined in the APPS schema and is a view rather than a table, it is read-only for reporting and integration purposes. Any maintenance of status definitions is performed against the underlying base table and the lookup repository, not the view itself.

Underlying Base Objects

The view is defined over two source objects, as documented in the ETRM view text:

  • IGS_AD_APPL_STAT (aliased DRVTAB) — the driving base table that stores the admission application status definitions, including the code, description, default flag, closed flag, and audit columns.
  • IGS_LOOKUPS_VIEW (aliased LKUP) — the lookup repository view that supplies the decoded MEANING and the lookup-level CLOSED_IND.

The join is an equi-join constrained by LKUP.LOOKUP_TYPE = 'ADM_APPL_STATUS' and LKUP.LOOKUP_CODE = DRVTAB.S_ADM_APPL_STATUS. This means a row is returned only when the stored status code exists as a lookup code under the ADM_APPL_STATUS lookup type. The documented metadata lists no additional referenced base objects, so the two objects above constitute the complete dependency set.

Key Columns

  • ROW_ID — the ROWID of the driving table row, provided for row identification.
  • S_ADM_APPL_STATUS — the primary status code stored in the base table and matched to the lookup code.
  • MEANING — the descriptive meaning of the lookup code, sourced from IGS_LOOKUPS_VIEW.
  • ADM_APPL_STATUS — the application status value held on the base table.
  • DESCRIPTION — the base table description of the status.
  • SYSTEM_DEFAULT_IND — indicates whether the status is the system default for new applications.
  • CLOSED_IND — the base table flag indicating whether the status is a closed state.
  • DSP_CLOSED_IND — the closed indicator from the lookup repository, exposed under this display alias.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard audit columns inherited from the base table.

Common Use Cases and Queries

Typical uses include populating status list-of-values items on admission forms, validating status codes during data migration or interface loading, and reporting on open versus closed application populations.

Retrieve all available application statuses with their decoded meanings:

SELECT S_ADM_APPL_STATUS, MEANING, DESCRIPTION, CLOSED_IND
FROM APPS.IGS_AD_APPL_STAT_V
ORDER BY S_ADM_APPL_STATUS;

Identify the system default status:

SELECT S_ADM_APPL_STATUS, MEANING
FROM APPS.IGS_AD_APPL_STAT_V
WHERE SYSTEM_DEFAULT_IND = 'Y';

List only active (non-closed) statuses:

SELECT S_ADM_APPL_STATUS, MEANING
FROM APPS.IGS_AD_APPL_STAT_V
WHERE NVL(CLOSED_IND,'N') = 'N';