Search Results igf_aw_db_cod_dtls_pk

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.

• AWARD_ID — foreign key to IGF_AW_AWARD_ALL, anchoring each row to its parent award.
• DISB_NUM and DISB_SEQ_NUM — the disbursement number and sequence, distinguishing multiple disbursements and their revisions within an award.
• DOCUMENT_ID_TXT — the COD document identifier used for submission and reconciliation.
• DISB_ACCEPTED_AMT — the amount accepted by COD for the disbursement.
• DISB_NET_AMT and ORIG_FEE_AMT — net disbursement amount and the origination fee applied, respectively.
• INTEREST_REBATE_AMT — rebate credited on Direct Loan disbursements.
• DISB_DATE and DISB_REL_FLAG — the disbursement date and a release indicator.
• FIRST_DISB_FLAG — indicates whether the row is the first disbursement of the award.
• DISB_CONF_FLAG — COD confirmation status for the disbursement.
• REP_ENTITY_ID_TXT and ATD_ENTITY_ID_TXT — reporting and additional entity identifiers required by COD.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, and REQUEST_ID — concurrent program context identifying the process that created or updated the record.

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.