Results for “s_signature_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGF_SL_CL_RESP_R1_ALL table is a Financial Aid module object within Oracle E-Business Suite, documented as obsolete in the ETRM metadata for releases 12.1.1 and 12.2.2. It maintains the CommonLine response (Record Type 1) received from an external student loan processor, serving as the primary response header that anchors borrower, school, lender, and guarantor information returned during the CommonLine loan origination and guarantee cycle. The table is owned by the IGF schema and, per the documented implementation data, is not implemented in the current database, though its 136-column physical definition and foreign key relationships remain cataloged for upgrade and migration purposes.

Applying the heuristic Data Vault classification derived from the foreign key structure, this object is hub-leaning. It behaves as a business hub because it carries a single-column surrogate primary key (CLRP1_ID) that is propagated to numerous dependent satellites and detail tables. Modelers may treat CLRP1_ID as the hub key, with the remaining descriptive attributes distributed across satellite structures keyed on that same identifier.

Key Information Stored

The table's primary key is defined by the constraint IGF_SL_CL_RESP_R1_ALL_PK on the column CLRP1_ID, and a separate unique index, IGF_SL_CL_RESP_R1_ALL_U1, is also documented on CLRP1_ID as the business-key candidate. The most operationally significant attributes include:

• CLRP1_ID — surrogate primary key and business-key candidate; the parent identifier propagated to all dependent response detail tables.
• CBTH_ID — foreign key to the CommonLine batch header, tying the response to its inbound file transmission batch.
• REC_CODE / REC_TYPE_IND — CommonLine record code and record type indicator identifying the response layout.
• LOAN_NUMBER / CL_SEQ_NUMBER — the loan identifier and CommonLine sequence number for the returned record.
• B_LAST_NAME, B_FIRST_NAME, B_SSN, B_DATE_OF_BIRTH — borrower identity fields as returned by the processor.
• SCHOOL_ID / DUNS_SCHOOL_ID — school identification, with the foreign key SCHOOL_ID referencing PER_JP_SCHOOL_LOOKUPS.
• LENDER_ID / DUNS_LENDER_ID — lender identification, with LENDER_ID referencing IGF_SL_LENDER.
• GUARANTOR_ID / DUNS_GUARNT_ID — guarantor identification, with GUARANTOR_ID referencing IGF_SL_GUARANTOR.
• REQ_LOAN_AMT, FLS_APPROVED_AMT, FLU_APPROVED_AMT, FLP_APPROVED_AMT, ALT_APPROVED_AMT — requested and approved loan amounts by loan type.
• GUARANTEE_DATE / GUARANTEE_AMT / GUARNT_STATUS_CODE — guarantee outcome data returned in the response.
• ERR_MESG_1 through ERR_MESG_5 — processor error messages associated with the response.
• RESP_RECORD_STATUS / CL_REC_STATUS — processing status flags for the inbound response record.
• ORG_ID and the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) — multi-org and audit context.

Common Use Cases and Queries

Typical usage centers on reconciling outbound CommonLine loan requests against inbound processor responses and on reporting guarantee and disbursement outcomes. A frequent pattern joins the response header to its batch and to the school and lender reference tables:

• Batch reconciliation: SELECT r.CLRP1_ID, r.LOAN_NUMBER, r.RESP_RECORD_STATUS FROM IGF_SL_CL_RESP_R1_ALL r, IGF_SL_CL_BATCH_ALL b WHERE r.CBTH_ID = b.CBTH_ID.
• Error analysis: querying rows where ERR_MESG_1 IS NOT NULL to isolate rejected or edit-failed responses by batch.
• Guarantee tracking: aggregating GUARANTEE_AMT by GUARANTOR_ID and GUARNT_STATUS_CODE to monitor guarantee volumes.
• Lender and school rollups: joining LENDER_ID to IGF_SL_LENDER and SCHOOL_ID to PER_JP_SCHOOL_LOOKUPS for institutional reporting.
• Discrepancy detection: comparing REQ_LOAN_AMT against FLS_APPROVED_AMT, FLU_APPROVED_AMT, and FLP_APPROVED_AMT to identify partially approved loans.

Related Objects

The table participates in a dense foreign key web. It references IGF_SL_CL_BATCH_ALL through CBTH_ID, PER_JP_SCHOOL_LOOKUPS through SCHOOL_ID, IGF_SL_LENDER through LENDER_ID, and IGF_SL_GUARANTOR through GUARANTOR_ID. Several dependent objects point back to it via CLRP1_ID, including the response detail tables IGF_SL_CL_RESP_R4_ALL, IGF_SL_CL_RESP_R8_ALL, IGF_SL_CL_RESP_R2_DTLS, IGF_SL_CL_RESP_R3_DTLS, and the charge detail table IGF_SL_CLCHRS_DTLS. These relationships confirm the table's hub-leaning role as the central anchor for CommonLine response processing.