Search Results adm_offer_dfrmnt_status




Overview
Explore in AI Chat

Overview

The view APPS.IGS_AD_OFRDFRMT_STAT_V exposes admission offer deferment status definitions within the Oracle E-Business Suite Student System (formerly Oracle Student System, now marketed as Oracle Student Information Management / Student Records) product family. The base object name IGS_AD_OFRDFRMT_STAT resolves to "Admissions Offer Deferment Status," and forms part of the IGS (Institution of Higher/Graduate Studies) schema that underpins Oracle's higher-education admissions and recruitment modules. The "_V" suffix indicates a database view rather than a table, and the view exists to join internal code values to their external, user-facing meanings maintained in the Oracle lookup framework.

Functionally, the view presents the code-value list used to classify the deferment status of an offer made to an applicant — for example, whether an offer has been deferred, reinstated, or allowed to lapse. Because the view already decodes the internal code through the lookup meaning, it is the preferred object for reporting, concurrent program queries, and interfaces that must present human-readable status text rather than opaque internal codes. Users querying by the search term "adm_offer_dfrmnt_status" are effectively searching for the lookup type and the underlying status table, both of which surface through this view.

Underlying Base Objects

The view is defined over two objects joined in its SQL text:

  • IGS_AD_OFRDFRMT_STAT AODS — the primary admission offer deferment status table, aliased AODS. It supplies the internal status identifier, description, system-default flag, closed indicator, and standard WHO audit columns.
  • IGS_LOOKUPS_VIEW LKUPV — the lookup view, filtered to LOOKUP_TYPE = 'ADM_OFFER_DFRMNT_STATUS'. It supplies the external meaning and the display closed indicator.

The join is a code-value lookup relationship rather than a foreign-key to another business table: LKUPV.LOOKUP_CODE = AODS.S_ADM_OFFER_DFRMNT_STATUS. The prefixed column name S_ADM_OFFER_DFRMNT_STATUS (the "S_" convention) denotes the stored, language-independent lookup code, while the accompanying ADM_OFFER_DFRMNT_STATUS column holds the operative status value used by dependent admission offer records. The view is therefore a decoding layer: it does not introduce new business data, but resolves each status row against the seeded lookup type. Documented ETRM metadata lists no additional referenced base objects, confirming the two-object definition above.

Key Columns

  • ROW_ID — the base table ROWID, exposed for use by Oracle Forms and programmatic row identification.
  • ADM_OFFER_DFRMNT_STATUS — the primary status value used by downstream admission offer records.
  • DESCRIPTION — the descriptive text stored on the status row itself.
  • S_ADM_OFFER_DFRMNT_STATUS — the stored, internal lookup code referenced by the lookup framework.
  • MEANING — the decoded, user-facing interpretation retrieved from the lookup, suitable for display and reporting.
  • DSP_CLOSED_IND — the lookup's closed indicator, used to determine whether the status is terminal for display or workflow purposes.
  • SYSTEM_DEFAULT_IND — flags whether this status is the system default applied when no status is explicitly specified.
  • CLOSED_IND — the status row's own closed flag, retained alongside the lookup-derived indicator.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, inherited from the base table.

Common Use Cases and Queries

Typical uses include LOV (List of Values) population in admission offer forms, validation of an entered deferment status, and reporting on the deferment statuses available in a given environment. Because the view decodes the lookup automatically, callers avoid writing their own lookup join.

Listing all active, non-closed statuses with their displayed meaning:

SELECT ADM_OFFER_DFRMNT_STATUS, S_ADM_OFFER_DFRMNT_STATUS, MEANING, SYSTEM_DEFAULT_IND
FROM APPS.IGS_AD_OFRDFRMT_STAT_V
WHERE CLOSED_IND = 'N'
ORDER BY MEANING;

Retrieving the system default deferment status:

SELECT MEANING, S_ADM_OFFER_DFRMNT_STATUS
FROM APPS.IGS_AD_OFRDFRMT_STAT_V
WHERE SYSTEM_DEFAULT_IND = 'Y';

Resolving a stored code to its meaning for an offer record:

SELECT o.OFFER_ID, v.MEANING AS DEFERMENT_STATUS
FROM IGS_AD_OFFERS_ALL o, APPS.IGS_AD_OFRDFRMT_STAT_V v
WHERE v.S_ADM_OFFER_DFRMNT_STATUS = o.DEFERMENT_STATUS_CODE;

Queries should generally be qualified with the APPS schema and constrained to avoid returning statuses that have been end-dated in the lookup, which the view does not itself filter.