Search Results igs_ad_doc_stat_v

Overview

The IGS_AD_DOC_STAT_V view is a seeded database object owned by the APPS schema within the Oracle EBS IGS – Student System product family. It exposes admissions document status reference data—the coded values that classify the state of documents associated with an applicant's admission record. In releases 12.1.1 and 12.2.2, this view is delivered as part of the Student System (formerly Oracle Student System) schema and is reported as VALID. Administrators and developers searching for the legacy identifier s_adm_doc_status are in fact searching on the descriptive flexfield-style lookup code column S_ADM_DOC_STATUS, which the view surfaces alongside a decoded meaning.

Functionally, the view presents a denormalized, report-friendly representation of the IGS_AD_DOC_STAT table joined to the generic lookup view IGS_LOOKUPS_VIEW. Its role is to supply both the internal status code and the user-facing lookup meaning in a single flattened result set, which simplifies reporting, LOV (List of Values) population, and integration extracts.

Underlying Base Objects

Although the documented metadata lists no referenced base objects, the published view text establishes the dependency clearly. The view is defined over two sources:

• IGS_AD_DOC_STAT (aliased ADS) – the primary admissions document status table, supplying the row identifier, descriptive attributes, audit columns, and the status code.
• IGS_LOOKUPS_VIEW (aliased LKUPV) – the standard lookups view, joined to translate the status code into an application-visible meaning.

The join condition links ADS.S_ADM_DOC_STATUS = LKUPV.LOOKUP_CODE and restricts the lookup type with LKUPV.LOOKUP_TYPE = 'ADM_DOC_STATUS'. The view exposes ADS.ROWID as ROW_ID, giving consumers a stable row reference suitable for forms and update operations.

Key Columns

• ROW_ID – the ROWID of the underlying IGS_AD_DOC_STAT row.
• ADM_DOC_STATUS – the primary admissions document status identifier.
• S_ADM_DOC_STATUS – the seeded/legacy status code; the column implied by the s_adm_doc_status search term.
• DESCRIPTION – free-text description of the status.
• SYSTEM_DEFAULT_IND – indicates whether the status is the system default.
• CLOSED_IND – indicates whether the status represents a closed state.
• MEANING – the decoded lookup meaning sourced from IGS_LOOKUPS_VIEW.
• DSP_CLOSED_IND – the display-oriented closed indicator derived from the lookup view.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard audit columns.

Common Use Cases and Queries

Typical uses include populating selection lists for admissions document statuses, decoding status codes in operational reports, and validating status values during data conversion. A report listing all active document statuses may be written as follows:

• SELECT adm_doc_status, s_adm_doc_status, meaning, description, closed_ind FROM igs_ad_doc_stat_v ORDER BY meaning;
• SELECT adm_doc_status, meaning FROM igs_ad_doc_stat_v WHERE system_default_ind = 'Y';
• SELECT v.adm_doc_status, v.meaning, d.document_id FROM igs_ad_doc_stat_v v, igs_ad_documents d WHERE d.adm_doc_status = v.adm_doc_status;

Because the view is read-only in intent and joins to the lookups view, it is best used for querying and reporting rather than as a maintenance interface; updates to document status definitions should be performed against the underlying IGS_AD_DOC_STAT table or through the supported Student System application forms.