Results for “igf_sl_dl_lor_crresp_all”

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

Overview

IGF_SL_DL_LOR_CRRESP_ALL is a transaction and reporting table within the IGF (Financial Aid) product family of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. The table maintains the credit history response returned by the Loan Origination Center (LOC) for the parent or endorser associated with a Federal Direct Loan origination record in the Oracle Student Financial Aid / Financial Aid module. Each row captures the outcome of a credit check processed during loan origination, including the credit decision, override indicators, and Master Promissory Note (MPN) attributes relevant to that response.

From a dimensional modeling perspective, the metadata characterises this object as satellite-leaning. In Data Vault terms, a satellite table stores descriptive, time-variant attributes that hang off a hub or link. Here, the natural hub relationship is provided by the foreign key to IGF_SL_DL_BATCH_ALL via DBTH_ID, while the credit decision, status, and MPN attributes behave as satellite payload. This classification is a heuristic suggestion derived from the foreign-key topology rather than a formally documented ETRM designation.

Key Information Stored

The table contains 21 documented columns. The following are the most operationally significant:

• LOR_RESP_NUM — surrogate primary key of the table and the single column comprising the unique index IGF_SL_DL_LOR_CRRESP_ALL_U1. It also serves as the only documented business-key candidate.
• DBTH_ID — foreign key to IGF_SL_DL_BATCH_ALL, linking each credit response to its originating loan batch.
• LOAN_NUMBER — the loan identifier to which the credit response applies.
• CREDIT_OVERRIDE — indicates whether the system or an operator overrode the automated credit decision.
• CREDIT_DECISION_DATE — the date the credit decision was rendered by the Loan Origination Center.
• STATUS — the processing status of the credit response record.
• ENDORSER_AMOUNT — the monetary amount associated with an endorser's credit approval, used in PLUS loan adjudication.
• MPN_ID, MPN_STATUS, MPN_TYPE, MPN_INDICATOR — the Master Promissory Note identifier, its lifecycle status, its type, and a Boolean-style indicator controlling whether the MPN is applicable.
• ORG_ID — the operating unit discriminator supporting multi-org security.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — the standard EBS WHO-column audit and concurrent-program context set.

Common Use Cases and Queries

Typical reporting scenarios include reconciling credit decisions back to their origination batches, auditing overrides for compliance, and tracking MPN status by loan. A representative join to the batch table is:

• SELECT r.LOR_RESP_NUM, r.LOAN_NUMBER, r.CREDIT_OVERRIDE, r.STATUS, r.CREDIT_DECISION_DATE, b.* FROM igf.igf_sl_dl_lor_crresp_all r JOIN igf.igf_sl_dl_batch_all b ON r.dbth_id = b.dbth_id WHERE r.org_id = :p_org_id;
• Override analysis: filter on CREDIT_OVERRIDE and group by CREDIT_DECISION_DATE to identify periods of elevated manual intervention.
• MPN reconciliation: select rows where MPN_INDICATOR is set and compare MPN_STATUS against downstream promissory note tables.

Related Objects

The following objects are most significant in relation to this table:

• IGF_SL_DL_BATCH_ALL — parent table for this record; join on DBTH_ID.
• IGF_SL_DL_LOR_CRRESP_ALL_PK — primary key constraint on LOR_RESP_NUM.
• IGF_SL_DL_LOR_CRRESP_ALL_U1 — unique index on LOR_RESP_NUM, the documented business-key candidate.
• Related Financial Aid loan origination and MPN tables in the IGF schema that consume the credit decision, loan number, and MPN identifiers recorded here.