Search Results igf_db_awd_disb_dtl_all




Overview
Explore in AI Chat

Overview

The table IGF_DB_AWD_DISB_DTL_ALL is a core data repository within the Oracle E-Business Suite's Financial Aid module (IGF). Its primary role is to serve as the system of record for finalized financial aid disbursement transactions. Specifically, it stores all actual disbursement transactions and any subsequent adjustments made to them after they have been successfully posted to the student finance interface. It is critical to note that this table is not used for planned or scheduled disbursements; it is populated only upon the successful execution and posting of an actual disbursement. The metadata explicitly marks the IGF module as "Obsolete," indicating this table is part of a legacy code stream that may be deprecated in future releases, though it remains functional in versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to uniquely identify and detail each disbursement transaction. Its primary key is a composite of three columns: AWARD_ID, DISB_NUM, and DISB_SEQ_NUM. This combination ensures a unique record for each individual disbursement instance associated with a specific award. While the full column list is not provided in the excerpt, the foreign key relationships imply the table stores critical linkage data. Key inferred data points include the award identifier, the disbursement number, a sequence number for the transaction, and calendar information (LD_CAL_TYPE, LD_SEQUENCE_NUMBER) linking the disbursement to a specific academic term or period. The table fundamentally holds the financial and transactional details resulting from the disbursement process.

Common Use Cases and Queries

This table is central to post-disbursement auditing, reconciliation, and historical reporting. Common operational and analytical queries include retrieving the complete disbursement history for a specific student award, summarizing total disbursed amounts by term or award type, and identifying all adjustment transactions posted against an original disbursement. A typical reporting query would join this table to award and student master tables. For example:

  • Disbursement Detail by Award: SELECT * FROM igf_db_awd_disb_dtl_all ddtl WHERE ddtl.award_id = :p_award_id ORDER BY ddtl.disb_num, ddtl.disb_seq_num;
  • Reconciliation Reporting: Joining to IGF_AW_AWD_DISB_ALL to compare planned versus actual disbursement amounts and dates.
  • Financial Audit Trails: Tracing the complete lifecycle of a disbursement, from its initial posting through any correcting entries, by querying records based on the primary key and related sequence numbers.

Related Objects

IGF_DB_AWD_DISB_DTL_ALL is integrally connected to other core Financial Aid tables. Its primary foreign key relationship is with IGF_AW_AWD_DISB_ALL, which holds the planned disbursement schedule. This link is established via the AWARD_ID and DISB_NUM columns, creating the critical bridge between the planned disbursement and its executed counterpart. A secondary foreign key relationship exists with IGS_CA_INST_ALL (the Institutional Calendar table) via the LD_CAL_TYPE and LD_SEQUENCE_NUMBER columns, tying each disbursement detail to an academic calendar period. As the source of posted transactions, this table is also a likely source for downstream general ledger interfaces and student account receivable updates within the system.