Results for “s_adm_outcome_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_OU_STAT_V is an Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 view owned by the APPS schema in the IGS (Student System) product family. It presents the user-defined admission outcome statuses that an institution maintains for its admissions process — for example "offer to be made," "conditional offer to be made," "unsuccessful," "reject," and "offer revoked." Each user-defined (descriptive) status is joined to the corresponding system admission outcome status that Oracle Student System functionality actually recognizes, producing a single denormalized row per status pair. The view is therefore best understood as a reporting and integration convenience layer: it exposes the descriptive flexfield-style meaning of the lookup code alongside the raw lookup code value, so reports, concurrent programs, OBIEE extracts, and custom interfaces do not each have to re-implement the lookup join. A user searching for "s_adm_outcome_status" is typically looking at exactly this mapping — the S_ADM_OUTCOME_STATUS column is the system lookup code, and MEANING is its human-readable description.

Underlying Base Objects

The view is defined over two objects, joined in its WHERE clause:

• IGS_AD_OU_STAT (aliased AOS) — the base table holding the institution's admission outcome status definitions, including the descriptive status, its description, the mapped system status, and audit columns.
• IGS_LOOKUPS_VIEW (aliased LKUPV) — the standard EBS lookup view, filtered here by LOOKUP_TYPE = 'ADM_OUTCOME_STATUS', which supplies the MEANING (display text) and CLOSED_IND for the system status.

The join condition is AOS.S_ADM_OUTCOME_STATUS = LKUPV.LOOKUP_CODE. The trailing predicate (LKUPV.CLOSED_IND = 'N' OR AOS.S_ADM_OUTCOME_STATUS = LKUPV.LOOKUP_CODE) ensures that only active system lookup values are surfaced, while still permitting rows whose lookup has been closed. No additional referenced base objects are documented for this view in the ETRM 12.2.2 metadata.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_AD_OU_STAT row, used for direct updates through the view where permitted.
• ADM_OUTCOME_STATUS — the user-defined admission outcome status identifier, the primary key of the descriptive status.
• DESCRIPTION — the free-text description of the user-defined status.
• S_ADM_OUTCOME_STATUS — the system admission outcome status lookup code; this is the value referenced by other IGS entities.
• MEANING — the display meaning of S_ADM_OUTCOME_STATUS from IGS_LOOKUPS_VIEW.
• SYSTEM_DEFAULT_IND — indicates whether this status is the system-supplied default for admissions processing.
• CLOSED_IND — flags the user-defined status record as closed; DSP_CLOSED_IND is the corresponding closed indicator on the lookup definition.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include validating admissions status configuration, building status-to-meaning reference lists for offers and rejections, and driving lookups in applicant or offer-letter reports. A common query resolves the descriptive status against its system lookup meaning:

SELECT adm_outcome_status, s_adm_outcome_status, meaning, system_default_ind
FROM apps.igs_ad_ou_stat_v
WHERE closed_ind = 'N'
ORDER BY meaning;

To find the default status applied automatically during admissions processing:

SELECT adm_outcome_status, description, s_adm_outcome_status
FROM apps.igs_ad_ou_stat_v
WHERE system_default_ind = 'Y';

To reconcile user-defined statuses against the system lookup values that recognize them, join by LOOKUP_TYPE = 'ADM_OUTCOME_STATUS' using S_ADM_OUTCOME_STATUS. Reports and interfaces that translate a stored status code into a display label should select MEANING rather than DESCRIPTION, since MEANING is the lookup text recognized by system functionality.