[Home] [Help] [Dependency Information]
Object Name: | IGFFV_DL_ORIGINATION_CHANGES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFFV_DL_ORIGINATION_CHANGES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds Financial Aid Direct Loan Origination Changes
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAN_NUMBER | VARCHAR2 | (30) | Yes | Indicates Direct Loan's loan identifier |
CHANGE_CODE | VARCHAR2 | (30) | Yes | Indicates change code for database field name whose value changes |
NEW_VALUE | VARCHAR2 | (4000) | Indicates maximum string length for field in change file | |
_LA:CHANGED_RECORD_STATUS | CHAR | (60) | Keeps track status of changed records. Values are ready to send or sent to LOC | |
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 | |
BATCH_ID | NUMBER | (15) | Yes | Identifier for batch |
CHANGE_RECORD_ID | NUMBER | (12) | Yes | Identifier for Direct Loan's value change 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
, NEW_VALUE
, _LA:CHANGED_RECORD_STATUS
, BATCH_FILE_ID
, BATCH_FILE_CREATION_DATE
, _LA:BATCH_REJECTION_CODE
, BATCH_TYPE
, BATCH_FILE_TYPE
, _LA:BATCH_STATUS
, BATCH_ID
, CHANGE_RECORD_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFFV_DL_ORIGINATION_CHANGES;
APPS.IGFFV_DL_ORIGINATION_CHANGES is not referenced by any database object
|
|
|