Search Results igf_db_awd_disb_v

Overview

IGF_DB_AWD_DISB_V is a reporting and integration view owned by the APPS schema within the IGF (Financial Aid) product family of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. The view presents combined award and disbursement detail, joining award-level attributes from an award view (aliased AWDV) to disbursement-level records from a disbursement table (aliased ADISB). Its principal role is to expose a denormalized, query-friendly projection of student financial aid awards alongside the individual disbursement transactions scheduled or released against those awards.

The view is documented under the title "View: IGF_DB_AWD_DISB_V" with description "Award disbursement details." It is widely used as a source for operational reporting, downstream extracts, integration interfaces, and ad hoc inquiry into disbursement status. The user search term "fund_status_date" corresponds directly to the FUND_STATUS_DATE column exposed by this view, which records the effective date associated with the current fund status of a disbursement.

Underlying Base Objects

The ETRM documentation records no separately named base tables; the view text is defined as an inline SELECT joining two logical sources: AWDV, the award-side source supplying award, student, fund, and calendar attributes, and ADISB, the disbursement-side source supplying transaction, fee, status, and lifecycle columns. The ROW_ID column is drawn from ADISB.ROW_ID, indicating the disbursement record is the driving grain of the view.

Because the view is a join of award and disbursement data, each row represents one disbursement line for an award. The award identifier (AWARD_ID) plus the disbursement number (DISB_NUM) provides the natural business key used to reconcile records against award and disbursement base entities. The view includes standard EBS WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — together with concurrent program context columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Key Columns

• AWARD_ID, BASE_ID, DISB_NUM — Award identity, base identifier, and the disbursement sequence number.
• STUDENT_ID, PERSON_NUMBER, SSN, FULL_NAME — Student identification attributes carried from the award side.
• FUND_ID, FUND_CODE, FUND_DESCRIPTION, FUND_TYPE, FED_FUND_CODE, SYS_FUND_TYPE — Fund classification, including federal fund coding used for regulatory reporting.
• OFFERED_AMT, ACCEPTED_AMT — Award amounts offered versus accepted by the student.
• DISB_GROSS_AMT, FEE_1, FEE_2, DISB_NET_AMT — Disbursement gross amount, applicable fees, and resulting net amount.
• DISB_DATE, DISB_EXP_DT — Actual disbursement date and expected disbursement date.
• ELIG_STATUS, ELIG_STATUS_DATE — Eligibility status and its effective date.
• DISB_STATUS, DISB_STATUS_DATE — Disbursement status and status effective date.
• FUND_STATUS, FUND_STATUS_DATE — Fund status and the fund status effective date; the latter is the column returned by the "fund_status_date" search.
• FUND_RELEASE_DATE, CHEQUE_NUMBER, FUND_DIST_MTHD — Fund release, payment instrument, and distribution method details.
• MANUAL_HOLD_IND, HOLD_REL_IND, AFFIRM_FLAG, LATE_DISB_IND, PREV_REPORTED_IND — Hold, affirmation, lateness, and prior-reporting indicator flags.
• CI_* and TP_* calendar columns — Award and disbursement period calendar type, sequence, alternate code, and start/end dates.

Common Use Cases and Queries

Typical scenarios include tracking disbursements awaiting fund release, reconciling net disbursement amounts against fees, auditing eligibility and fund status transitions by date, and extracting award disbursement detail for interfaces. A representative query filtering on the searched column follows:

• Disbursements by fund status date: SELECT award_id, disb_num, fund_status, fund_status_date, disb_net_amt FROM apps.igf_db_awd_disb_v WHERE fund_status_date >= :p_from_date ORDER BY fund_status_date;
• Student-level disbursement history: SELECT student_id, fund_code, disb_date, disb_gross_amt, disb_net_amt FROM apps.igf_db_awd_disb_v WHERE person_number = :p_person_number;
• Hold and release analysis: SELECT award_id, disb_num, manual_hold_ind, hold_rel_ind, fund_release_date FROM apps.igf_db_awd_disb_v WHERE manual_hold_ind = 'Y';

Because the view exposes both award and disbursement grain, queries should filter on the intended level of detail and be secured against the appropriate business group and student data access to preserve row-level security obligations.