Search Results igs_ad_appl_stat_v

Overview

IGS_AD_APPL_STAT_V is a database view in the Oracle E-Business Suite Student System (IGS) product family. It presents a denormalized, human-readable representation of admission application status codes by joining the base application status table to the Oracle Applications lookup facility. In the context of EBS 12.1.1 and 12.2.2, this view belongs to the legacy IGS footprint, which Oracle has classified as obsolete; the ETRM documentation lists it under "IGS - Student System (Obsolete)" and explicitly states that it is "Not implemented in this database" in the documented environment.

The view is significant because it resolves the raw code value stored on the base table (S_ADM_APPL_STATUS) against the ADM_APPL_STATUS lookup type, surfacing the descriptive MEANING text used throughout admissions reporting. This makes it a reporting-friendly layer for status analysis without requiring callers to hard-code lookup joins. Outside the IGS component in which it originated, it has no general application in Financials, Supply Chain, or HR reporting.

Underlying Base Objects

The documented view text defines a two-table join:

• IGS_AD_APPL_STAT — aliased DRVTAB, the driving table holding the stored admission application status rows. All persistent columns (DESCRIPTION, SYSTEM_DEFAULT_IND, CLOSED_IND, and the standard WHO audit columns) originate here.
• IGS_LOOKUPS_VIEW — aliased LKUP, the lookups view that supplies the translated MEANING and the lookup's own CLOSED_IND (projected as DSP_CLOSED_IND).

The join is an equality filter on LOOKUP_TYPE = 'ADM_APPL_STATUS' and LOOKUP_CODE = DRVTAB.S_ADM_APPL_STATUS. The ETRM metadata for 12.2.2 documents no additional referenced base objects, and the "Implementation/DBA Data" section records the view as not deployed in the documented database. Because of this, customers must confirm existence in their own instance (for example, via DBA_VIEWS or FND_VIEWS) before depending on it.

Key Columns

• ROW_ID — the base table ROWID, exposed for row-level identification and update-through-view scenarios.
• S_ADM_APPL_STATUS — the stored status code; the primary join key to the lookup.
• MEANING — the translated lookup meaning, the user-facing status description.
• ADM_APPL_STATUS — an additional status attribute carried on the base table.
• DESCRIPTION — free-text description of the status record.
• SYSTEM_DEFAULT_IND — identifies whether the status is the system default.
• CLOSED_IND / DSP_CLOSED_IND — the base table closed flag and the lookup's closed flag.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Primary uses are admissions-status reporting and validation of status-code-to-meaning translation. A representative query follows:

SELECT s_adm_appl_status, meaning, description,
system_default_ind, dsp_closed_ind
FROM igs_ad_appl_stat_v
WHERE NVL(dsp_closed_ind, 'N') = 'N'
ORDER BY meaning;

Analysts may also aggregate application counts by status meaning, or reconcile the lookup configuration against the status table to detect orphaned codes (codes present in IGS_AD_APPL_STAT with no matching lookup row, which the inner join would suppress). Because the object is documented as obsolete and not implemented, all such queries should be treated as subject to availability verification, and any functional requirement met by this view should be evaluated against Oracle's supported replacement functionality before continued reliance.