Results for “endorser_amount”
25 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view IGFFV_DL_ORIG_CREDIT_RESPONSES (owned by the APPS schema) is a full-view entity within the Oracle E-Business Suite Financial Aid module (IGF). It exposes the data set that holds Financial Aid Direct Loan origination credit responses — the records returned by the Common Origination and Disbursement (COD) system in reaction to a Direct Loan origination request submitted by the institution. In EBS 12.1.1 and 12.2.2 the object is documented as VALID and classified as a VIEW, meaning it is a read-only, reporting-facing projection rather than a transaction table.
Its role is to present credit decision data — most notably the decision date, status, and override indicators — in a denormalized, user-friendly form suitable for inquiry screens, reports, and downstream integrations. The view text includes embedded value-set translation markers (the "_LA:..." pseudo-columns) that the Oracle Forms/ADF layer uses to substitute lookup meanings for raw codes, signalling that this object is intended to feed an end-user inquiry or extract rather than raw SQL processing alone. A WITH READ ONLY clause guarantees that no DML can be issued against it.
Underlying Base Objects
Per the documented view definition, IGFFV_DL_ORIG_CREDIT_RESPONSES is defined over two base tables joined on the batch identifier:
IGF_SL_DL_LOR_RESP_ALL(aliased DLLORCRR) — the "all" org-striped table holding the individual Direct Loan origination credit response rows.IGF_SL_DL_BATCH_ALL(aliased BATCH) — the batch header table describing the COD batch with which each response was received.
The join predicate is DLLORCRR.DBTH_ID = BATCH.DBTH_ID, linking each credit response to its parent batch. The documented metadata states that no referenced base objects are listed in the ETRM 12.2.2 record, but the view SQL itself confirms the two _ALL tables above. Because both are multi-org (_ALL) tables, a reporting query will typically also constrain by operating unit or rely on the view's own recorded context.
Key Columns
The view exposes the following principal columns, with the lookup-backed columns shown by their logical role:
LOAN_NUMBER— the Direct Loan identifier being originated.CREDIT_DECISION_DATE— the date on which the credit decision was rendered; this is the column the user is seeking and is the anchor for most credit-response reporting."_LA:CREDIT_OVERRIDE"(CREDIT_OVERRIDE) — override indicator, translated via theIGF_SL_CREDIT_OVERRIDElookup."_LA:RECORD_STATUS"(STATUS) — the credit response status, translated viaIGF_SL_DL_RESP_STATUS.ENDORSER_AMOUNT— endorser amount associated with the response."_LA:MASTER_PROM_NOTE_STATUS"(MPN_STATUS),MASTER_PROM_NOTE_ID(MPN_ID),"_LA:MASTER_PROM_NOTE_TYPE"(MPN_TYPE), andMASTER_PROM_NOTE_INDICATOR(MPN_INDICATOR) — Master Promissory Note attributes and their lookups.- Batch columns:
BATCH_FILE_ID,BATCH_FILE_CREATION_DATE,"_LA:BATCH_REJECTION_CODE",BATCH_TYPE,BATCH_FILE_TYPE,"_LA:BATCH_STATUS", andBATCH_ID. - System/audit columns:
ORIG_CREDIT_RESPONSE_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE.
Common Use Cases and Queries
Typical scenarios include identifying credit decisions recorded on or after a given date, reconciling batch receipts against individual responses, and surfacing overrides on rejected originations. A representative query filtering on the credit decision date is:
SELECT loan_number, credit_decision_date, batch_id, batch_type FROM apps.igffv_dl_orig_credit_responses WHERE credit_decision_date >= :p_from_date ORDER BY credit_decision_date;- Join-free inquiry by loan number:
SELECT * FROM apps.igffv_dl_orig_credit_responses WHERE loan_number = :p_loan; - Override audit:
SELECT loan_number, credit_decision_date, "_LA:CREDIT_OVERRIDE" FROM apps.igffv_dl_orig_credit_responses WHERE "_LA:CREDIT_OVERRIDE" IS NOT NULL;
Because the view is read-only and combines response and batch context in one row, it is the preferred source for point-in-time reporting of Direct Loan origination credit outcomes across EBS 12.1.1 and 12.2.2.
-
Full View for the Entity that holds Financial Aid Direct Loan Origination Credit Responses
APPS.IGFFV_DL_ORIG_CREDIT_RESPONSES·↳ IGF_SL_DL_BATCH_ALL·↳ IGF_SL_DL_LOR_CRRESP_ALL·Explore IGF module →
-
Base view for the entity that holds Financial Aid Direct Loan Origination Credit Responses
APPS.IGFBV_DL_ORIG_CREDIT_RESPONSES·↳ IGF_SL_DL_LOR_CRRESP_ALL·Explore IGF module →
-
Legacy Direct Loans Origination Interface Table
-
View: IGF_SL_DL_LOR_CRRESP 12.1.1
APPS.IGF_SL_DL_LOR_CRRESP·↳ IGF_SL_DL_LOR_CRRESP_ALL·Explore IGF module →
-
Maintains the loan origination's parent's credit history response from the Loan Origination Center
-
Base view for the entity that holds Financial Aid Direct Loan Originations
APPS.IGFBV_DIRECT_LOAN_ORIGINATIONS·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_FUND_CAT_ALL·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Originations
APPS.IGFFV_DIRECT_LOAN_ORIGINATIONS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Origination Credit Responses
Not implemented in this database·Explore IGF module →
-
Base view for the entity that holds Financial Aid Direct Loan Origination Credit Responses
Not implemented in this database·Explore IGF module →
-
View: IGF_SL_DL_LOR_CRRESP 12.2.2
Not implemented in this database·Explore IGF module →
-
Base view for the entity that holds Financial Aid Direct Loan Originations
Not implemented in this database·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Originations
Not implemented in this database·Explore IGF module →
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program