Results for “disb_amt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGF_GR_DB_RESP_DTLS table is a Financial Aid (IGF) module object in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores Pell Disbursement Record Response Elements parsed from the response XML file returned by the U.S. Department of Education's Common Origination and Disbursement (COD) system. Within the Title IV federal student aid integration flow, this table captures the granular, per-disbursement outcome data that results after a Pell Grant disbursement record has been transmitted and subsequently acknowledged or rejected by the federal processor.

Its role in Oracle EBS is relatively narrow but operationally significant: it is the persistence layer for inbound disbursement-level response detail, enabling Financial Aid administrators to reconcile what was reported to COD against what COD accepted, corrected, or rejected. Heuristically, the mined foreign-key structure classifies this object as satellite-leaning, suggesting that in a Data Vault model it would function as a satellite table attached to a hub or link representing the disbursement record itself. The table is owned by the IGF schema and is marked VALID.

Key Information Stored

The physical schema documented for 12.1.1 contains 21 columns. The most important are summarized below.

• DISB_RESP_ID — the surrogate primary key, defined by the unique index IGF_GR_DB_RESP_DTLS_PK. This is the sole business-key candidate documented and uniquely identifies each response detail row.
• PELL_RESP_ID — the foreign key linking back to IGF_GR_RESP_DTLS, establishing the parent Pell response context under which the disbursement detail was received.
• DISB_NUM / DISB_SEQ_NUM / PREV_SEQ_NUM — the disbursement number and sequence identifiers used to order and relate disbursement records, including the prior sequence reference.
• DISB_AMT / DISB_DATE — the disbursement amount and disbursement date as reflected in the response.
• DISB_REL_FLAG — a release flag indicating the disbursement release status.
• PYMNT_PER_START_DATE — the payment period start date associated with the disbursement.
• STATUS_CODE / RESP_CODE — the processing status and response code returned by COD, central to determining acceptance versus rejection.
• NOTE_MESSAGE — free-text notes or messages accompanying the response element.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID provide standard EBS who-columns and concurrent request traceability.

Common Use Cases and Queries

Typical scenarios include reconciliation of COD responses against originated disbursements, identifying rejected disbursements for correction and resubmission, and financial aid reporting on disbursement timing and amounts. A common query joins the detail rows to their parent response header:

• Join pattern: SELECT d.* FROM igf.igf_gr_db_resp_dtls d, igf.igf_gr_resp_dtls r WHERE d.pell_resp_id = r.pell_resp_id
• Rejected disbursements: filter by STATUS_CODE or RESP_CODE to isolate non-accepted records for the current aid year.
• Disbursement totals: aggregate DISB_AMT grouped by DISB_DATE or PYMNT_PER_START_DATE for period reporting.
• Request traceability: query by REQUEST_ID to trace all detail rows produced by a specific concurrent COD response import.

Related Objects

• IGF_GR_RESP_DTLS — the direct parent; joined on IGF_GR_DB_RESP_DTLS.PELL_RESP_ID = IGF_GR_RESP_DTLS.PELL_RESP_ID. This is the primary documented foreign-key relationship.
• IGF_GR_DB_RESP and associated COD response header tables — the broader response import hierarchy that feeds detail rows.
• IGF_GR_DB_ORIG / Pell origination tables — the outbound origination counterparts used for reconciliation.
• Pell disbursement and COD import concurrent programs — the batch processes that parse response XML and populate this table via the REQUEST_ID.
• FINANCIAL AID reporting views within the IGF schema that aggregate disbursement response data for institutional and federal reporting.