[Home] [Help] [Dependency Information]
Object Name: | IGFBV_DL_ORIG_BATCH_RESPONSES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFBV_DL_ORIG_BATCH_RESPONSES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Base view for the entity that holds Direct Loan Origination Batch Responses
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORIG_BATCH_ID | VARCHAR2 | (40) | Yes | Indicates batch identifier contained in loan origination record sent to LOC |
LOAN_NUMBER | VARCHAR2 | (30) | Yes | Indicates loan number associated with origination |
ORIG_ACK_DATE | DATE | Yes | Indicates origination acknowledgement date | |
_LA:ORIG_STATUS_FLAG | CHAR | (76) | Indicates origination status flag. Values are accepted origination - Stafford only, rejected origination, accepted origination or credit check accepted - PLUS only, accepted origination or credit check denied - PLUS only, accepted origination or credit check pending - PLUS only | |
ORIG_REJECT_REASONS | VARCHAR2 | (10) | Indicates reasons for rejection of origination | |
_LA:PROM_NOTE_STATUS | CHAR | (71) | Indicates status of promissory note. Values are accepted master promissory note at LOC, master promissory note not on file at LOC, inactive, closed, rejected, pending master promissory note at LOC, unknown, request to print forwarded to lender, promissory note print request on hold awaiting error resolution, awaiting download by borrower, promissory note printed, guarantor awaiting promissory note, received by guarantor-needs follow up, received by guarantor-returned to borrower, note forwarded to lender-servicer, lender-servicer awaiting promissory note, received by lender-servicer-needs follow up, received by lender or servicer-returned to borrower, approved by lender-servicer | |
PROM_NOTE_ID | VARCHAR2 | (30) | Indicates promissory note identifier | |
PROM_NOTE_ACCEPT_AMT | NUMBER | (12) | Indicates promissory note accepted amount | |
LOAN_AMOUNT_ACCEPTED | NUMBER | (12) | Indicates loan amount accepted. Sent for PLUS loans only | |
_LA:ORIG_BATCH_STATUS | CHAR | (64) | Keeps track of all records processed and successfully updated. Values are successfully updated, loan origination record not updated, old data not updated, or invalid loan number | |
E_MASTER_PROM_NOTE_IND | VARCHAR2 | (30) | Electronic Master Promissory Note Indicator | |
BATCH_ID | NUMBER | (15) | Yes | Identifier for batch |
LOAN_ORIG_RESPONSE_NUMBER | NUMBER | (15) | Yes | Identifier for Direct Loan's loan origination response records |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT ORIG_BATCH_ID
, LOAN_NUMBER
, ORIG_ACK_DATE
, _LA:ORIG_STATUS_FLAG
, ORIG_REJECT_REASONS
, _LA:PROM_NOTE_STATUS
, PROM_NOTE_ID
, PROM_NOTE_ACCEPT_AMT
, LOAN_AMOUNT_ACCEPTED
, _LA:ORIG_BATCH_STATUS
, E_MASTER_PROM_NOTE_IND
, BATCH_ID
, LOAN_ORIG_RESPONSE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFBV_DL_ORIG_BATCH_RESPONSES;
APPS.IGFBV_DL_ORIG_BATCH_RESPONSES is not referenced by any database object
|
|
|