Search Results elig_status_date




Overview
Explore in AI Chat

Overview

The view IGF_AW_AWD_DISB belongs to the IGF (Financial Aid) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM metadata classifies the product as "Obsolete," and explicitly records that the object is "Not implemented in this database." Consequently, the view should be treated as a legacy artifact rather than an active reporting or integration surface in a standard, current installation. Where it does exist, it presents award disbursement records — one row per disbursement against a financial aid award — exposing eligibility, disbursement status, fund handling, fee, and audit columns. Its principal value in historical or migrated environments lies in surfacing the ELIG_STATUS and related eligibility attributes alongside disbursement amounts and dates, allowing eligibility decisions to be reconciled with the amounts actually paid and released.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the view text itself makes the lineage clear: the view is defined over IGF_AW_AWD_DISB_ALL, aliased as ADISB. The "_ALL" suffix indicates a multi-organization (multi-org / ORG_ID) base table, which is consistent with the view text filtering by ORG_ID. The view is essentially a filtered projection of that table, carrying forward a broad column list including key financial aid attributes and the standard Oracle WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) plus concurrent program columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE). Because the metadata documents no intermediate views or joins, the relationship is direct: the view reads from IGF_AW_AWD_DISB_ALL and applies an organization/security predicate.

Key Columns

The columns most relevant to reporting and to the user's search term elig_status are:

Common Use Cases and Queries

Typical usage centers on eligibility and status reconciliation. A query filtering by ELIG_STATUS retrieves the disbursements affected by a given eligibility decision:

  • Eligibility audit: SELECT award_id, disb_num, elig_status, elig_status_date, disb_net_amt FROM igf_aw_awd_disb WHERE elig_status = :status;
  • Disbursement-to-payment reconciliation: compare DISB_ACCEPTED_AMT against DISB_PAID_AMT for a given award.
  • Hold and release monitoring: filter on HOLD_REL_IND, MANUAL_HOLD_IND, and FUND_STATUS.

Because ETRM marks the object "Not implemented" and the product "Obsolete," these queries should be validated against the target instance's data dictionary before reliance, and migrated implementations should confirm that IGF_AW_AWD_DISB_ALL and the view remain present.