Search Results igf_gr_db_resp_dtls




Overview
Explore in AI Chat

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.

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.