Results for “credit_decision_date”

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

Overview

IGFBV_DL_ORIG_CREDIT_RESPONSES is a base database view within the Oracle E-Business Suite Financial Aid (IGF) module. Its documented purpose is to expose the entity that holds Financial Aid Direct Loan Origination Credit Responses. In the EBS 12.1.1 and 12.2.2 data models, the IGF product line implemented federal student aid processing, including the origination of Direct Loan records and the exchange of credit response data with the Common Origination and Disbursement (COD) system. This view serves as the reporting and integration layer over that data, allowing inquiry forms, concurrent reports, and interface programs to read credit response records without directly accessing the underlying transaction table.

It is important to note that the ETRM metadata explicitly marks this object as part of "IGF - Financial Aid (Obsolete)." The implementation note states "Not implemented in this database," and no referenced base objects are documented in the 12.2.2 metadata. Consequently, the view is retained for historical and upgrade reference rather than active use in current releases. The presence of the credit_decision_date column is directly relevant to the user's search, as this is the principal attribute indicating when a lender or guarantor returned a credit decision on an origination response.

Underlying Base Objects

The view text defines the view over a single base table:

• IGF_SL_DL_LOR_CRRESP_ALL — aliased as DLLORCRR — the Direct Loan Origination Credit Response table. The _ALL suffix indicates a multi-organization (partitioned by operating unit) table, meaning the view inherits the row-level operating unit context of the underlying table.

The query is defined with the WITH READ ONLY clause, confirming that the view is non-updatable and intended purely for query access. Each column is projected directly from the base table without joins, aggregation, or filtering, making it a thin projection layer that preserves the base table's grain — one row per origination credit response record. Although the 12.2.2 metadata lists no referenced base objects, the embedded view text unambiguously identifies IGF_SL_DL_LOR_CRRESP_ALL as the source.

Key Columns

• LOAN_NUMBER — the Direct Loan identifier associated with the response.
• CREDIT_DECISION_DATE — the date on which the credit decision was rendered, the focal column for credit-decision reporting.
• _LA:CREDIT_OVERRIDE — a descriptive flexfield-style value derived via IGF_SL_CREDIT_OVERRIDE lookup, exposing the credit override meaning.
• _LA:RECORD_STATUS — the response status, decoded through IGF_SL_DL_RESP_STATUS.
• ENDORSER_AMOUNT — monetary amount guaranteed by an endorser.
• _LA:MASTER_PROM_NOTE_STATUS / _LA:MASTER_PROM_NOTE_TYPE — Master Promissory Note attributes decoded via IGF_SL_PNOTE_STATUS and IGF_SL_PNOTE_TYPE.
• MASTER_PROM_NOTE_ID / MASTER_PROM_NOTE_INDICATOR — MPN identity and indicator flags.
• BATCH_ID — the processing batch that produced the response.
• ORIG_CREDIT_RESPONSE_NUMBER — the unique response sequence number.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

Typical reporting scenarios include credit decision tracking, response status monitoring, and reconciliation between origination records and COD responses. A representative query to retrieve credit decisions by date is:

SELECT LOAN_NUMBER, "CREDIT_DECISION_DATE", "_LA:RECORD_STATUS" FROM IGFBV_DL_ORIG_CREDIT_RESPONSES WHERE "CREDIT_DECISION_DATE" IS NOT NULL ORDER BY "CREDIT_DECISION_DATE";

Analysts may aggregate responses by status to monitor volumes, or join LOAN_NUMBER back to origination tables for end-to-end Direct Loan tracking. Because the view is read-only and built on a multi-org table, queries executed without proper operating unit context may return incomplete results. Given the object's obsolete status, these queries are primarily relevant to historical data extraction, migration, or archival reporting rather than live production processes in 12.1.1 and 12.2.2.