Results for “adm_doc_status”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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_STATrow. - 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_statussearch 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.
-
Lookup Type: ADM_DOC_STATUS 12.1.1
Admission Documentation Status
-
Lookup Type: ADM_DOC_STATUS 12.2.2
Admission Documentation Status
-
View: IGS_AD_DOC_STAT_V 12.1.1
APPS.IGS_AD_DOC_STAT_V·↳ IGS_AD_DOC_STAT·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
APPS.IGS_AD_APPL_INST_MKDES_V·↳ IGS_AD_APPL·↳ IGS_AD_BASIS_FOR_AD·↳ IGS_AD_CD·Explore IGS module →
-
Describes user-defined admission documentation statuses which map to system-defined admission documentation statuses
-
Describes history of changes to admission program application instance
-
Request for program entry for an admission period
APPS.IGS_AD_PS_APLINSTHST_APLHIST_V·↳ IGS_AD_PS_APLINSTHST·↳ IGS_AD_PS_APPL_HIST·↳ IGS_GE_DATE·Explore IGS module →
-
View: IGS_AD_PS_APPL_INST 12.1.1
APPS.IGS_AD_PS_APPL_INST·↳ IGS_AD_PS_APPL_INST_ALL·Explore IGS module →
-
It returns the Missing items for Post Admission Requirements
APPS.IGS_AD_POSTADM_MISS_ITM_LTR_V·↳ HZ_PARTIES·↳ IGS_AD_APLINS_ADMREQ·↳ IGS_AD_APPL_ALL·Explore IGS module →
-
APPS.IGS_AD_PS_APLINSTHST_HISTORY_V·↳ IGS_AD_PS_APLINSTHST_APLHIST_V·↳ IGS_AD_PS_APPL·↳ IGS_AD_PS_APPL_INST_APLINST_V·Explore IGS module →
-
Returns the missing items. For processing application of the student, few documents are required by the admission module. When student forget to send any document or miss out any document , then these documents are treated as missing items
APPS.IGS_AD_MISSING_ITEMS_LETTER_V·↳ HZ_PARTIES·↳ IGS_AD_APLINS_ADMREQ·↳ IGS_AD_APPL_ALL·Explore IGS module →
-
View: IGS_AD_PS_APLINSTHST 12.1.1
APPS.IGS_AD_PS_APLINSTHST·↳ IGS_AD_PS_APLINSTHST_ALL·Explore IGS module →
-
Holds the request for program entry for an admission period
-
View of IGS_AD_PS_APPL_INST. Incorporates alternate codes and calendar instance start and end dates for both the Admission and Deferred Admission calendars. Also incorporates Admission Course Application details.
APPS.IGS_AD_PS_APPL_INST_APLINST_V·↳ HZ_PARTIES·↳ IGS_AD_APPL·↳ IGS_AD_BASIS_FOR_AD·Explore IGS module →
-
View: IGS_AD_PS_APPL_INST_SV 12.1.1
View of IGS_AD_PS_APPL_INST_ALL to secure the select operation on this table
APPS.IGS_AD_PS_APPL_INST_SV·↳ IGS_AD_PS_APPL_INST_ALL·Explore IGS module →
-
Holds the admission application instance history details that need to get imported for an application, during legacy import
-
View: IGS_AD_DOC_STAT_V 12.2.2
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_AD_DOC_STAT_V 12.1.1
-
TABLE: IGS.IGS_AD_DOC_STAT 12.1.1
-
VIEW: APPS.IGS_AD_DOC_STAT_V 12.1.1
-
Table: IGS_AD_DOC_STAT 12.2.2
Describes user-defined admission documentation statuses which map to system-defined admission documentation statuses
Not implemented in this database·Explore IGS module →
-
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_PS_APLINSTHST 12.2.2
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_AD_VAL_ADS 12.1.1
-
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_PS_APPL_INST 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_PS_APPL_INST_SV 12.2.2
View of IGS_AD_PS_APPL_INST_ALL to secure the select operation on this table
Not implemented in this database·Explore IGS module →
-
It returns the Missing items for Post Admission Requirements
Not implemented in this database·Explore IGS module →
-
Request for program entry for an admission period
Not implemented in this database·Explore IGS module →