Search Results s_adm_offer_resp_status




Overview
Explore in AI Chat

Overview

The IGS_AD_OFR_RESP_STAT_V view is a seeded, VALID database object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. Its name decomposes into the functional domains it serves: AD (Admissions), OFR (Offer), RESP (Response), and STAT (Status). The view therefore exists to present the configurable set of admission offer response statuses — for example, values such as Accepted, Declined, Deferred, or Withdrawn — that an institution may assign to an applicant's response to an offer of admission.

Its role in EBS reporting and integration is essentially that of a decoded lookup wrapper. The underlying transactional status code is stored in the base table, but the view joins to the standard Oracle lookups repository so that reporting tools, OAF pages, and interfaces can retrieve both the coded value and its human-readable meaning in a single query. This makes the view a convenient reference source for validation, display, and cross-referencing, removing the need for consumers to hard-code lookup codes.

Underlying Base Objects

The view is defined over two sources, both resident in the APPS schema:

  • IGS_AD_OFR_RESP_STAT (aliased AORS) — the primary admissions offer response status table in the IGS Student System. It holds the status code, the descriptive text, the associated system lookup code, system default flag, closed indicator, and the standard WHO audit columns.
  • IGS_LOOKUPS_VIEW (aliased LKUPV) — the standard Oracle Applications lookups view, filtered on LOOKUP_TYPE = 'ADM_OFFER_RESP_STATUS'. This supplies the looked-up MEANING and an independent CLOSED_IND.

The two are joined on a single predicate: LKUPV.LOOKUP_CODE = AORS.S_ADM_OFFER_RESP_STATUS. The ETRM 12.2.2 metadata lists no referenced base objects separately, but the view text confirms the dependency above. Note that because the lookup view typically restricts to the current, enabled lookup values, the join can act as an implicit filter on the rows returned.

Key Columns

The view exposes thirteen columns, several of which are worth distinguishing clearly:

  • ROW_ID — the base table ROWID; although present, it is not a stable primary key for persisted reference.
  • ADM_OFFER_RESP_STATUS — the primary status attribute as defined in the base table.
  • S_ADM_OFFER_RESP_STATUS — the system-defined lookup code, used as the join key to the lookups view.
  • DESCRIPTION — descriptive text held on the base table.
  • MEANING — the display meaning sourced from the lookup, generally preferred for user-facing output.
  • DSP_CLOSED_IND — the closed indicator derived from the lookup view, intended for display logic.
  • SYSTEM_DEFAULT_IND — flags the status delivered as the system default.
  • CLOSED_IND — the closed indicator held on the base table, distinct from DSP_CLOSED_IND; reconciliation between the two can reveal configuration drift.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard audit (WHO) columns.

Common Use Cases and Queries

Typical scenarios include populating a status list of values, validating an incoming status code in an interface, and reporting on admission offer responses. A basic query returning active statuses with their meanings:

  • SELECT adm_offer_resp_status, s_adm_offer_resp_status, meaning
  • FROM igs_ad_ofr_resp_stat_v
  • WHERE closed_ind = 'N'
  • ORDER BY meaning;

To identify the default status:

  • SELECT adm_offer_resp_status, meaning
  • FROM igs_ad_ofr_resp_stat_v
  • WHERE system_default_ind = 'Y';

In reporting and integration, the view is best used as a read-only lookup source rather than a transaction target; updates must be directed to the base table or through the supported Admissions forms and APIs. Because it depends on the lookups view and the admissions table, access should be granted via the standard APPS synonym and responsibility, consistent with the ETRM metadata recorded for release 12.2.2.