Search Results igf_aw_db_cod_dtls




Overview
Explore in AI Chat

Overview

IGF_AW_DB_COD_DTLS is a Financial Aid (IGF) module table in Oracle E-Business Suite that stores disbursement-level details for Title IV federal student aid processed through the Common Origination and Disbursement (COD) system. It captures both Direct Loan disbursements and Pell Grant disbursements in the form in which they are transmitted to, and acknowledged by, COD. In practice, this table functions as the disbursement staging and reconciliation layer between the internal award and disbursement records held in Oracle Student Financial Aid and the external COD system that governs federal fund delivery.

Each row represents a single disbursement event against a specific award, identified by award, disbursement number, and disbursement sequence number. Because it also carries COD-facing identifiers and confirmation flags, the table supports both outbound reporting (origination of disbursement records to COD) and inbound processing (acceptance, adjustment, and reconciliation of COD responses).

Under a heuristic Data Vault classification, this object is satellite-leaning. Its composite primary key is inherited from the parent award, and it contributes descriptive, time-stamped attributes rather than defining new business entities or relationships. This suggests it should be modeled as a satellite attached to the award hub, with AWARD_ID as the linking key.

Key Information Stored

The primary key IGF_AW_DB_COD_DTLS_PK is defined over (AWARD_ID, DISB_NUM, DISB_SEQ_NUM), combining a foreign key to the parent award with the disbursement ordinal and sequence number. There is no separate surrogate key column in the documented metadata; the business identity and the relational identity coincide.

Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and PROGRAM_UPDATE_DATE are also present for traceability.

Common Use Cases and Queries

Typical usage centers on COD disbursement reconciliation: verifying that amounts reported to COD match internally accepted amounts, and identifying disbursements that remain unconfirmed.

  • Disbursement detail for an award: SELECT disb_num, disb_seq_num, disb_date, disb_net_amt, disb_accepted_amt, disb_conf_flag FROM igf.igf_aw_db_cod_dtls WHERE award_id = :award_id ORDER BY disb_num, disb_seq_num;
  • Unconfirmed disbursements requiring follow-up: filter on rows where DISB_CONF_FLAG is null or does not indicate acceptance.
  • Fee and rebate analysis: aggregate ORIG_FEE_AMT and INTEREST_REBATE_AMT by award to reconcile net versus gross disbursement totals.
  • First-disbursement reporting: use FIRST_DISB_FLAG to isolate the initial disbursement per award.
  • Auditing batch activity: group by REQUEST_ID or PROGRAM_ID with CREATION_DATE to trace which concurrent process produced each record.

Related Objects

  • IGF_AW_AWARD_ALL — parent award table; joined on IGF_AW_DB_COD_DTLS.AWARD_ID = IGF_AW_AWARD_ALL.AWARD_ID, the only documented foreign key relationship.
  • IGF_AW_DISB_ALL — internal award disbursement records, commonly joined to compare internal versus COD-facing amounts.
  • IGF_AW_AWARD_DISB — award-to-disbursement association used to trace disbursement records across the award lifecycle.
  • IGF_AP_COD_* / COD interface tables — staging objects used to transmit disbursement data to COD and receive responses.
  • Concurrent program definitions referenced by PROGRAM_APPLICATION_ID and PROGRAM_ID for batch identification.