Search Results clchgrsp_id




Overview
Explore in AI Chat

Overview

The IGF.IGF_SL_CLCHRS_DTLS table is a CommonLine Change Send Response Table within the Oracle E-Business Suite student loan/servicing module (IGF schema). It stores responses returned for change transactions submitted by an institution or servicer. When a Change Transaction Send File is transmitted to the CommonLine processor, the corresponding response records — including any errors encountered during processing — are persisted in this table. From a Data Vault modeling perspective (heuristic classification: satellite-leaning), this object behaves as a satellite attached to the change-response hub/link represented by its parent response table, since it carries descriptive attributes and error context keyed to a single parent reference (CLRP1_ID) and a sequence-generated surrogate key.

Key Information Stored

The table contains 19 documented columns. The columns of greatest business significance are:

Only CLCHGRSP_ID is enforced as unique; no separate business-key candidate unique index is documented beyond the primary key.

Common Use Cases and Queries

Typical uses include reconciliations of transmitted change files against returned responses, error-frequency analysis across the five error message codes, and audit reporting by concurrent request. A common pattern retrieves responses joined to their parent header:

  • Lookup by primary key: SELECT * FROM IGF.IGF_SL_CLCHRS_DTLS WHERE CLCHGRSP_ID = :p_id;
  • Join to parent: SELECT d.*, r.* FROM IGF.IGF_SL_CLCHRS_DTLS d JOIN IGF.IGF_SL_CL_RESP_R1_ALL r ON r.CLRP1_ID = d.CLRP1_ID;
  • Error aggregation: group by the five ERROR_MESSAGE_n_CODE columns to identify recurring rejection causes.
  • Request-based audit: filter on REQUEST_ID and PROGRAM_APPLICATION_ID to reconcile a specific concurrent run.
  • Content search: query SEND_RECORD_TXT, leveraging the non-unique index, to trace a specific submitted record.

Related Objects

  • IGF.IGF_SL_CL_RESP_R1_ALL — Parent response table; join CLRP1_ID to its primary key.
  • IGF.IGF_SL_CLCHRS_DTLS_PK — Unique index on CLCHGRSP_ID.
  • IGF.IGF_SL_CLCHRS_DTLS_N1 — Non-unique index on SEND_RECORD_TXT.
  • Change Transaction Send File processing concurrent programs (referenced via REQUEST_ID/PROGRAM_APPLICATION_ID).
  • Sibling CommonLine response detail tables in the IGF schema that share the response header structure.