Search Results igf_sl_cl_batch_all




Overview
Explore in AI Chat

Overview

IGF_SL_CL_BATCH_ALL is a table owned by the IGF schema within the Oracle E-Business Suite Financial Aid (IGF) module. It maintains the CommonLine batch file information for send files created by the module, as well as response files received and loaded into the module. CommonLine is the standardized electronic data exchange protocol used by the U.S. federal student loan community, and this table serves as the header-level registry that ties together the demographic and disbursement records exchanged with lenders, guarantors, and servicers.

From a Data Vault modeling perspective, the heuristic classification of this table is hub-leaning. That is a modeling suggestion: CBTH_ID behaves as a durable, unique business key that anchors the batch identity, while the surrounding descriptive and monetary columns resemble satellite attributes. Downstream tables in the IGF schema reference the hub through CBTH_ID as a foreign key, reinforcing the hub interpretation rather than a pure transactional link.

Key Information Stored

The table contains 29 documented columns. The most significant are described below.

Standard audit and ownership columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and ORG_ID — are also present and are commonly used for multi-org filtering and concurrency tracking.

Common Use Cases and Queries

Typical scenarios include batch reconciliation, transmission auditing, and response-file processing. A common control-total reconciliation query compares the batch header sum against detail records:

SELECT b.cbth_id, b.batch_id, b.send_resp,
       b.record_count_num, b.total_net_disb_amt
FROM   igf.igf_sl_cl_batch_all b
WHERE  b.file_trans_date BETWEEN :p_from AND :p_to
AND    b.org_id = :p_org;

To locate batches that have generated a response, join to IGF_SL_CL_RESP_R1_ALL on CBTH_ID. For disbursement response analysis, join to IGF_DB_CL_DISB_RESP_ALL on CBTH_ID. Reporting use cases include daily CommonLine transmission logs, disbursement control-total verification, and month-end reconciliation of net disbursement and cancellation amounts.

Related Objects

The following tables depend on IGF_SL_CL_BATCH_ALL through documented foreign keys:

  • IGF_DB_CL_DISB_RESP_ALL — references IGF_SL_CL_BATCH_ALL via CBTH_ID; holds disbursement response detail.
  • IGF_SL_CL_RESP_R1_ALL — references IGF_SL_CL_BATCH_ALL via CBTH_ID; holds CommonLine response R1 records.
  • IGF_SL_CL_BATCH_ALL_PK — the primary key constraint/index on CBTH_ID.
  • IGF_SL_CL_BATCH_ALL_U1 — the unique index on CBTH_ID supporting business-key interpretation.

These relationships support tracing a batch header to every disbursement and response record exchanged with external CommonLine partners.