Search Results igs_fi_bill_pln_crd

Overview

The IGF_AW_AWD_DISB_ALL table is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It serves as the central repository for storing detailed transactional records for each individual disbursement of a financial aid award. In the context of EBS 12.1.1 and 12.2.2, this table is fundamental to managing the lifecycle of an award, from its scheduled disbursement to its actual payment. It tracks the planned and actual release of funds to a student, enabling critical processes such as disbursement scheduling, hold management, loan origination, and financial accounting. Its "ALL" suffix indicates it is a multi-organization access controlled table, storing data across multiple operating units.

Key Information Stored

The table's structure is designed to capture the complete disbursement event. Its primary key is a composite of AWARD_ID and DISB_NUM, uniquely identifying each disbursement line for a specific award. Key columns include AWARD_ID, which links to the parent award in IGF_AW_AWARD_ALL, and DISB_NUM, which sequences multiple disbursements for that award. The table stores critical dates and amounts, such as the scheduled disbursement date and disbursement gross amount. It also maintains links to the academic calendar via columns like TP_CAL_TYPE and TP_SEQUENCE_NUMBER (Teaching Period) and LD_CAL_TYPE and LD_SEQUENCE_NUMBER (Loan Period), which are foreign keys to IGS_CA_INST_ALL. Status flags and revision history are tracked, with RVSN_ID linking to the revision reason table (IGF_AW_AWD_RVSN_RSN_ALL).

Common Use Cases and Queries

This table is central to numerous operational and reporting functions. Common use cases include generating disbursement rosters for financial aid offices, creating files for electronic funds transfer (EFT) to banks, calculating earned versus disbursed aid for Return to Title IV (R2T4) calculations, and supporting student account billing integration. A typical query might join to the award and student tables to list all pending disbursements for a specific term:

SELECT disb.awd_disb_date, disb.disb_gross_amt, awd.award_fmly_contribution
FROM igf_aw_awd_disb_all disb,
igf_aw_award_all awd
WHERE disb.award_id = awd.award_id
AND awd.person_id = :student_id
AND disb.tp_cal_type = :term_cal_type
AND disb.tp_sequence_number = :term_seq_num
AND disb.disb_status = 'PENDING';

Another critical pattern involves aggregating disbursed amounts by award type for institutional reporting.

Related Objects

The table maintains integral relationships with several other EBS objects, as documented by its foreign key constraints. It is a child of the IGF_AW_AWARD_ALL table via the AWARD_ID column. It references the IGS_CA_INST_ALL table twice for calendar information (teaching period and loan period). It also references IGF_AW_AWD_RVSN_RSN_ALL for revision tracking. Crucially, IGF_AW_AWD_DISB_ALL is a parent table to several key transactional entities:

• IGF_DB_AWD_DISB_DTL_ALL: Links on AWARD_ID, DISB_NUM for disbursement batch details.
• IGS_FI_BILL_PLN_CRD: Links on AWARD_ID, DISB_NUM for student billing and credits.
• IGF_DB_DISB_HOLDS_ALL: Links on AWARD_ID, DISB_NUM for managing disbursement holds.
• IGF_SL_DISB_LOC_HISTORY: Links on AWARD_ID and DISBURSEMENT_NUMBER (mapped to DISB_NUM) for student loan disbursement location history.