Search Results igf_sl_cl_resp_r4_all




Overview
Explore in AI Chat

Overview

IGF_SL_CL_RESP_R4_ALL is a Financial Aid module table in Oracle E-Business Suite (12.1.1 and 12.2.2) that stores the detailed data returned within the @4 record type during processing of the CommonLine Origination Acknowledgment Process. CommonLine is the legacy industry standard for electronic student loan origination and disbursement messaging; within EBS, the IGF schema handled the exchange of these fixed-format records between institutions and lenders/guarantors. The @4 record type carries the expanded borrower and co-signer reference data associated with a loan acknowledgment response. The table is classified as obsolete in current documentation and, per the ETRM metadata, is not implemented in this database — it is retained for historical reference and upgrade context only. Under a heuristic Data Vault classification, the FK structure suggests a satellite-leaning design: it hangs off a parent response record keyed by CLRP1_ID and is itself referenced by a detail table, which is consistent with a descriptive satellite rather than an independent hub or link.

Key Information Stored

The table is documented with 90 columns in the IGF schema. The most operationally significant data falls into these groups:

Common Use Cases and Queries

Typical usage centers on reconciliation and audit of origination acknowledgments, retrieving co-signer detail for servicing, and tracing a loan acknowledgment to its parent CommonLine response. A representative join back to the parent table:

SELECT r4.LOAN_NUMBER,
       r4.COSNR_1_LAST_NAME,
       r4.COSNR_1_SSN,
       r4.INT_RATE_OPT,
       r4.REPAYMENT_OPT_CODE
FROM   IGF_SL_CL_RESP_R4_ALL r4,
       IGF_SL_CL_RESP_R1_ALL r1
WHERE  r4.CLRP1_ID = r1.CLRP1_ID
AND    r4.LOAN_NUMBER = :loan_number;

A reporting scenario might aggregate outstanding borrower debt by loan to feed a portfolio summary, or list co-signers whose electronic-signature flag is populated for compliance review. Because concurrent programs populate the table, filtering by REQUEST_ID is a practical way to isolate the output of a specific Origination Acknowledgment run. Reporting queries should restrict by ORG_ID in multi-org installations.

Related Objects

The FK and PK relationships documented for this object connect it to the following significant tables:

  • IGF_SL_CL_RESP_R1_ALL — the parent response table; joined on CLRP1_ID (IGF_SL_CL_RESP_R4_ALL.CLRP1_ID references IGF_SL_CL_RESP_R1_ALL).
  • IGF_SL_CL_RESP_R7_DTLS — the detail table that references this table via IGF_SL_CL_RESP_R7_DTLS.CLRP1_ID, linking @4 record data to further @7 detail records.
  • IGF_SL_CL_RESP_R4_ALL_PK / _U1 — the primary-key constraint and unique index that enforce the CLRP1_ID key.

These three tables together form the CommonLine Origination Acknowledgment response chain: the R1 parent, the R4 borrower/co-signer expansion, and the R7 detail records. Because the object is marked obsolete and not implemented in the ETRM database, references in custom code should be validated against the installation before use.