[Home] [Help] [Dependency Information]
Object Name: | IGFFV_DL_ORI_CHG_BAT_RESPONSES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFFV_DL_ORI_CHG_BAT_RESPONSES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds Financial Aid Direct Loan Origination Change Batch Responses
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAN_NUMBER | VARCHAR2 | (30) | Yes | Indicates Direct Loan's loan identifier |
CHANGE_CODE | VARCHAR2 | (30) | Yes | Indicates change code |
_LA:REJECT_CODE | CHAR | (72) | Indicates reject code description | |
NEW_VALUE | VARCHAR2 | (4000) | Indicates maximum string length for field in change file | |
_LA:LOAN_IDENT_ERROR_CODE | CHAR | (80) | Indicates error code for loan | |
_LA:RECORD_STATUS | CHAR | (65) | Keeps track of all records processed and successfully updated. Values successfully updated, not updated loan origination record, old data, or invalid loan number | |
BATCH_FILE_ID | VARCHAR2 | (40) | Yes | Batch identifier for file created or loaded |
BATCH_FILE_CREATION_DATE | DATE | Yes | Indicates date on which file was created | |
_LA:BATCH_REJECTION_CODE | CHAR | (69) | Indicates reason for Loan Origination Center rejecting entire batch. Values are duplicate batch identifier number, school code indicates non-direct loan participant, file contains non-ASCII keyboard printable characters, batch not processed, invalid message class, or not in use | |
BATCH_TYPE | VARCHAR2 | (30) | Indicates batch type, which was sent to Loan Origination Center or received from Loan Origination Center. Values are Stafford full origination, PLUS full origination, import PLUS credit decision, origination change, disbursement details, or booking notification from Loan Origination Center | |
BATCH_FILE_TYPE | VARCHAR2 | (30) | Indicate send file or response file | |
_LA:BATCH_STATUS | CHAR | (64) | Indicates all batches processed and successfully updated for internal tracking. Values are successfully updated, not updated loan origination record, or error response file not uploaded | |
CHANGE_BATCH_ID | VARCHAR2 | (40) | Yes | Indicates change batch identifier from change record |
BATCH_ID | NUMBER | (15) | Yes | Identifier for Direct Loan batch |
CHANGE_RESPONSE_RECORD_ID | NUMBER | (12) | Yes | Identifier for Direct Loan's change 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 LOAN_NUMBER
, CHANGE_CODE
, _LA:REJECT_CODE
, NEW_VALUE
, _LA:LOAN_IDENT_ERROR_CODE
, _LA:RECORD_STATUS
, BATCH_FILE_ID
, BATCH_FILE_CREATION_DATE
, _LA:BATCH_REJECTION_CODE
, BATCH_TYPE
, BATCH_FILE_TYPE
, _LA:BATCH_STATUS
, CHANGE_BATCH_ID
, BATCH_ID
, CHANGE_RESPONSE_RECORD_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFFV_DL_ORI_CHG_BAT_RESPONSES;
APPS.IGFFV_DL_ORI_CHG_BAT_RESPONSES is not referenced by any database object
|
|
|