Search Results igf_sl_cl_resp_r8_all




Overview
Explore in AI Chat

Overview

IGF_SL_CL_RESP_R8_ALL is a Financial Aid module table within Oracle E-Business Suite (12.1.1 and 12.2.2) that stores CommonLine response "@8" records received from an external student loan processor. The table is populated and maintained exclusively by the CommonLine response load process; no online form or concurrent program performs direct DML against it outside that pipeline. It is therefore an inbound staging/reference structure that captures the disbursement-related response segments returned by guaranty agencies and servicers.

The documented Data Vault classification for this object is satellite-leaning. In Data Vault terms this is a modeling suggestion: the table behaves as a descriptive satellite attached to a parent business key, rather than as an independent hub of business entities or a pure link resolving many-to-many relationships. The single foreign key to IGF_SL_CL_RESP_R1_ALL reinforces this reading, since the parent supplies the header-level CommonLine response identity.

Note that the ETRM documentation explicitly records this object as not implemented in this database and marks the IGF — Financial Aid product as obsolete. References to this table should be treated as legacy metadata, relevant for historical data migrations and archive reporting rather than new development.

Key Information Stored

The primary key is IGF_SL_CL_RESP_R8_ALL_PK, defined on the composed surrogate pair CLRP1_ID and CLRP8_ID. A unique index, IGF_SL_CL_RESP_R8_ALL_U1, is also documented on (CLRP1_ID, CLRP8_ID), making this composite the business-key candidate for the row. CLRP1_ID is the foreign key tying the row back to the CommonLine response header in IGF_SL_CL_RESP_R1_ALL; CLRP8_ID identifies the individual @8 detail segment.

The remaining columns fall into three functional groups. The disbursement and financial group holds DISB_DATE, DISB_GROSS_AMT, NET_DISB_AMT, ORIG_FEE, GUARANTEE_FEE, ORIG_FEE_PAID and GUARNT_FEE_PAID, capturing the amounts and fee reconciliation state of the disbursement. The status group holds DISB_STATUS, RESP_RECORD_STATUS and DISB_HOLD_REL_IND, describing processing state and hold release. The layout and audit group holds LAYOUT_OWNER_CODE_TXT, LAYOUT_VERSION_CODE_TXT, RECORD_CODE_TXT and DIRECT_TO_BORR_FLAG, alongside standard EBS WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, ORG_ID, plus PROGRAM_APPLICATION_ID, PROGRAM_ID and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical use is reconciliation of processor responses against disbursements, and audit of fee amounts retained or paid. Because loading is restricted to the CommonLine process, the REQUEST_ID column is the practical handle for tracing a load run.

  • Reconcile net versus gross disbursements: select CLRP1_ID, CLRP8_ID, DISB_GROSS_AMT, ORIG_FEE, GUARANTEE_FEE, NET_DISB_AMT from IGF_SL_CL_RESP_R8_ALL where DISB_STATUS = :status;
  • Trace a specific load batch: select * from IGF_SL_CL_RESP_R8_ALL where REQUEST_ID = :request_id;
  • Join to the response header: select r8.*, r1.* from IGF_SL_CL_RESP_R8_ALL r8, IGF_SL_CL_RESP_R1_ALL r1 where r8.CLRP1_ID = r1.CLRP1_ID;
  • Flag records awaiting hold release: select CLRP1_ID, CLRP8_ID from IGF_SL_CL_RESP_R8_ALL where DISB_HOLD_REL_IND = 'N';

Related Objects

  • IGF_SL_CL_RESP_R1_ALL — parent header table; joins on CLRP1_ID. This is the only documented FK relationship.
  • CommonLine response load process — the sole writer of this table.
  • IGF_SL_CL_RESP_R1_ALL_PK / IGF_SL_CL_RESP_R8_ALL_PK — key constraints governing uniqueness and referential integrity.
  • Other IGF_SL_CL_RESP_R_ALL sibling tables (R2–R7) — share the same CLRP1_ID parent for full response reconstruction.