Search Results igf_sl_dl_lor_crresp

Overview

The IGF_SL_DL_LOR_CRRESP view is a Financial Aid (IGF) reporting and integration object that resides in the APPS schema of an Oracle E-Business Suite environment. It is registered as a VALID database object in both the 12.1.1 and 12.2.2 releases. The object provides a multi-tenant secured projection over the underlying loan credit response data used by the Direct Loan (DL) processing components of the Oracle Financial Aid product. In EBS terms, this view functions as a business-facing access layer that filters rows according to the operating unit context established by the session, rather than exposing every row of the physical table to every querying application or user.

The underlying data captured by the view relates to loan origination and credit review responses — the outcome of a lender or servicer evaluating a borrower's eligibility for a Direct Loan. Because credit decisions, Master Promissory Note (MPN) statuses, and endorser amounts must be reconciled between the financial aid institution and the Common Origination and Disbursement (COD) process, this view is commonly referenced in concurrent programs, inbound/outbound interfaces, and ad hoc reporting that must be scoped to the correct organization.

Underlying Base Objects

The view is defined over a single base table, IGF_SL_DL_LOR_CRRESP_ALL, aliased within the view text as DLLORCRR. The _ALL suffix indicates that the base table stores rows for all operating units, and the view's defining WHERE clause is responsible for restricting the result set to the current organization. The row identifier exposed as ROW_ID is the physical ROWID of the base table, which supports direct row addressing for updates or joins to less-derived column values. No other documented base objects are referenced; the view performs no joins or unions, so row cardinality matches the qualifying rows of the base table.

Key Columns

• ROW_ID — the physical ROWID of the IGF_SL_DL_LOR_CRRESP_ALL row.
• LOR_RESP_NUM — the loan origination response number, a primary business identifier for the response record.
• DBTH_ID — the borrower/debtor identifier linking the response back to the student or borrower record.
• LOAN_NUMBER — the Direct Loan identifier assigned to the origination.
• CREDIT_OVERRIDE and CREDIT_DECISION_DATE — capture the credit evaluation outcome and its timestamp.
• STATUS — the processing status of the credit response record.
• ENDORSER_AMOUNT — the amount guaranteed by an endorser, relevant to PLUS loan processing.
• MPN_ID, MPN_TYPE, MPN_STATUS, MPN_INDICATOR — the Master Promissory Note linkage and its current state.
• ORG_ID — the operating unit that determines visibility under the view's security predicate.
• Audit/WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus the concurrent program context columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical usage includes reconciling credit decision responses for a loan, reporting MPN status by operating unit, and joining the view to borrower or loan tables using DBTH_ID or LOAN_NUMBER. Because the view applies organization-level security through USERENV('CLIENT_INFO'), a valid operating unit must be initialized in the session before reliable results are returned. The following query illustrates retrieving credit response records:

SELECT lor_resp_num, dbth_id, loan_number, status,
       credit_decision_date, mpn_status, org_id
FROM   apps.igf_sl_dl_lor_crresp
WHERE  loan_number = :loan_number;

For integration or feed extraction, the WHO and concurrent program columns allow a process to identify records created by a specific request:

SELECT row_id, lor_resp_num, loan_number, endorser_amount
FROM   apps.igf_sl_dl_lor_crresp
WHERE  request_id = :request_id
AND    status = 'NEW';