Search Results igf_db_cl_disb_resp_all




Overview
Explore in AI Chat

Overview

IGF_DB_CL_DISB_RESP_ALL is a Financial Aid (IGF) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores all records received through the disbursement roster file — the inbound interface response that confirms, rejects, or adjusts loan and grant disbursements processed against a CommonLine (CL) disbursement batch. Each row represents a single disbursement response record tied to a parent batch, carrying borrower, school, lender, guarantor, and disbursement amount details along with error codes and status values returned by the processing agency.

Under a heuristic Data Vault classification mined from its foreign key structure, this table is satellite-leaning: it hangs off the batch parent through CBTH_ID and records descriptive, time-stamped attributes about each disbursement event rather than serving as a standalone hub or a pure many-to-many link. In practice, treat it as a child detail table subordinate to IGF_SL_CL_BATCH_ALL.

Key Information Stored

The 77 documented columns provide far richer detail than the list above; the surrogate key CDBR_ID is the only documented unique business-key candidate, so joins and lookups should key on it rather than on natural columns such as LOAN_NUMBER.

Common Use Cases and Queries

Typical scenarios include reconciling inbound disbursement responses against outbound roster submissions, reporting disbursement rejects by error code, and auditing monetary totals per batch or per school.

SELECT r.CDBR_ID, r.LOAN_NUMBER, r.DISB_NUM,
       r.GROSS_DISB_AMT, r.NET_DISB_AMT,
       r.ERR_CODE1, r.ERR_CODE2, r.STATUS
FROM   IGF.IGF_DB_CL_DISB_RESP_ALL r
WHERE  r.CDBR_ID = :cdbr_id;

To aggregate results per parent batch:

SELECT b.CBTH_ID, COUNT(*) recs,
       SUM(r.GROSS_DISB_AMT) gross_total,
       SUM(r.NET_DISB_AMT)   net_total
FROM   IGF.IGF_DB_CL_DISB_RESP_ALL r,
       IGF.IGF_SL_CL_BATCH_ALL     b
WHERE  r.CBTH_ID = b.CBTH_ID
GROUP  BY b.CBTH_ID;

Rejection analysis groups rows with any non-null error code by ERR_CODE1 through ERR_CODE5 to identify systematic agency rejects for remediation.

Related Objects

  • IGF_SL_CL_BATCH_ALL — parent batch table; join on IGF_DB_CL_DISB_RESP_ALL.CBTH_ID = IGF_SL_CL_BATCH_ALL.CBTH_ID (the sole documented foreign key).
  • IGF_DB_CL_DISB_RESP_ALL_PK — the unique index backing the CDBR_ID primary key.
  • CommonLine disbursement processing concurrent programs and roster loaders that populate this table from inbound files.
  • Financial Aid reporting views that summarize disbursement responses by borrower, school, or lender for reconciliation.

Because the metadata documents only one foreign key, additional integration points should be validated against the live IGF schema before use.