Search Results s_adm_fee_status




Overview
Explore in AI Chat

Overview

The view IGS_AD_FEE_STAT_V is a seeded database object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. It exists to present admissions fee status information in a denormalized, user-facing format suitable for forms, concurrent programs, reports, and integration interfaces. Rather than exposing raw internal codes, the view resolves descriptive meaning text so that consumers of the data see human-readable status descriptions alongside the underlying stored values. Its status is VALID, confirming that it is a supported, compiled object in both release 12.1.1 and 12.2.2.

The view is intended for reporting and inquiry scenarios where admissions fee status codes must be translated for display. It functions as a read-only presentation layer over the admissions fee status base table and the shared lookup framework, and therefore carries no independent data of its own.

Underlying Base Objects

The view text defines a join across two data sources. The driving table is IGS_AD_FEE_STAT, aliased as DRVTAB, which stores the admissions fee status definitions, their descriptions, default and closed indicators, and standard audit columns. The lookup source is IGS_LOOKUPS_VIEW, aliased as LKUP, which supplies the decoded meaning for the lookup code.

The join is constrained on two predicates: the lookup type must equal 'ADM_FEE_STATUS', and the lookup code must equal the stored S_ADM_FEE_STATUS value. In effect, the view returns one row per admissions fee status record whose lookup code has a matching entry in the ADM_FEE_STATUS lookup type. Records lacking a corresponding lookup code will not appear in the result set, which is a standard behavior of the Oracle lookups view pattern used throughout the IGS schema.

Key Columns

  • ROW_ID — The physical row identifier of the underlying IGS_AD_FEE_STAT record, useful for retrieving the base row in forms or update logic.
  • S_ADM_FEE_STATUS — The stored (internal) admissions fee status code, keyed to the ADM_FEE_STATUS lookup type.
  • MEANING — The decoded, translatable description of the lookup code, obtained from the lookups view.
  • ADM_FEE_STATUS — The primary descriptive or alternate status value held on the base table.
  • DESCRIPTION — Free-text description of the fee status.
  • SYSTEM_DEFAULT_IND — Indicates whether the status is the system default for the associated context.
  • CLOSED_IND — Flag on the base record showing whether the status is closed.
  • DSP_CLOSED_IND — The closed indicator sourced from the lookup definition, which may differ from the base table indicator; this supports consistent display behavior across lookups.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard who-columns supporting audit and concurrency.

Common Use Cases and Queries

The view is typically queried to populate lists of values, validate status codes during admission processing, or drive reporting. A basic retrieval demonstrating the join to lookup meanings is:

SELECT s_adm_fee_status,
       adm_fee_status,
       meaning,
       description,
       system_default_ind,
       closed_ind
FROM   apps.igs_ad_fee_stat_v
ORDER BY meaning;

To isolate the system default status:

SELECT *
FROM   apps.igs_ad_fee_stat_v
WHERE  system_default_ind = 'Y';

To restrict to open statuses, filtering on the lookup-derived indicator:

SELECT *
FROM   apps.igs_ad_fee_stat_v
WHERE  dsp_closed_ind = 'N';

Because the join relies on the ADM_FEE_STATUS lookup type, any customization or new lookup codes must be configured in the standard lookups maintenance form before records become visible through this view. This dependency should be accounted for during implementation, testing, and data migration activities.