Search Results igf_sl_cl_disb_status

Overview

IGF_AW_AWD_DISB_V is a prebuilt Oracle E-Business Suite view owned by the APPS schema that presents award disbursement detail for the Student Financial Aid / Grants (IGF) module, most commonly associated with Oracle iGrants and the Award Disbursement functionality of the EBS Grants Management suite. The view consolidates disbursement scheduling and payment information for a given award, including gross and net disbursement amounts, fee calculations, disbursement status, eligibility status, fund distribution method, and release dates.

Its principal role is to provide a denormalized, reporting-friendly projection: rather than returning raw lookup codes, the view decodes many coded columns into human-readable meaning values by invoking the IGF_AW_GEN.LOOKUP_DESC function. This makes the view well suited to operational reporting, extract feeds, and integration interfaces where consumers expect descriptive labels while retaining the underlying identifiers. It is commonly consumed in EBS reporting and by integrations that surface award disbursement activity to downstream financial or sponsor-facing systems.

Underlying Base Objects

The ETRM view metadata does not enumerate the referenced base objects. Based on the view text, the primary table is the award disbursement table (aliased ADISB), which holds the disbursement records keyed by AWARD_ID and DISB_NUM. The view joins to the award calendar information (aliased CI) via TP_CAL_TYPE and TP_SEQUENCE_NUMBER, and to a second calendar reference (aliased LD) via LD_CAL_TYPE and LD_SEQUENCE_NUMBER for late disbursement period information. It also joins to a revision identifier source (aliased RVSN) via RVSN_ID to obtain the revision description, and to an attendance type table (aliased ATD) via ATTENDANCE_TYPE_CODE for the attendance type description. Lookup meaning columns are resolved at query time through the IGF_AW_GEN.LOOKUP_DESC function rather than through joins. Because the exact base table names are not documented in the supplied metadata, they must be confirmed against the EBS data dictionary for the specific release.

Key Columns

• ROW_ID, AWARD_ID, DISB_NUM — unique row identifier, parent award, and disbursement sequence number.
• TP_CAL_TYPE, TP_SEQUENCE_NUMBER, CI.ALTERNATE_CODE, CI.START_DT, CI.END_DT — the disbursement period calendar attributes.
• DISB_GROSS_AMT, FEE_1, FEE_2, DISB_NET_AMT, FEE_PAID_1, FEE_PAID_2 — gross and net disbursement values with associated fees and fee payments.
• DISB_DATE, DISB_EXP_DT, FUND_RELEASE_DATE — scheduled disbursement date, expiration, and fund release date.
• DISB_STATUS and its decoded description — disbursement status using lookup IGF_SL_CL_DISB_STATUS.
• FUND_DIST_MTHD and its decoded description — fund distribution method using lookup IGF_SL_CL_DB_FUND_DISB_METH, the value referenced in the user's search.
• ELIG_STATUS, AFFIRM_FLAG, HOLD_REL_IND, MANUAL_HOLD_IND, PREV_REPORTED_IND — eligibility and hold/affirmation indicators with decoded meanings.
• TRANS_TYPE, FUND_STATUS, FEE_CLASS, BASE_ATTENDANCE_TYPE_CODE — transaction, fund, fee, and attendance classifications with decoded labels.
• DISB_ACCEPTED_AMT, DISB_PAID_AMT, CHEQUE_NUMBER, INT_REBATE_AMT, MIN_CREDIT_PTS — acceptance, payment, cheque, interest rebate, and minimum credit point attributes.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and the concurrent program request identifiers.

Common Use Cases and Queries

Typical scenarios include reconciling net disbursed amounts against payments, monitoring disbursements in a particular status, and reporting fund distribution method usage across awards. For example, to count disbursements by fund distribution method for a given award:

• SELECT AWARD_ID, DISB_NUM, DISB_GROSS_AMT, DISB_NET_AMT, DISB_STATUS, FUND_DIST_MTHD FROM APPS.IGF_AW_AWD_DISB_V WHERE AWARD_ID = :p_award_id;
• SELECT FUND_DIST_MTHD, COUNT(*) FROM APPS.IGF_AW_AWD_DISB_V GROUP BY FUND_DIST_MTHD;
• SELECT AWARD_ID, DISB_DATE, DISB_PAID_AMT, FUND_STATUS FROM APPS.IGF_AW_AWD_DISB_V WHERE DISB_DATE BETWEEN :start_dt AND :end_dt AND DISB_STATUS = :status;

Because several columns are produced by calling IGF_AW_GEN.LOOKUP_DESC, queries returning large data sets should account for the function-call cost per row, and should filter on indexed columns such as AWARD_ID where possible.