[Home] [Help] [Dependency Information]
Object Name: | IGFBV_DL_ORIGINATION_CHANGES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFBV_DL_ORIGINATION_CHANGES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Base 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_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_ID
, CHANGE_RECORD_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFBV_DL_ORIGINATION_CHANGES;
APPS.IGFBV_DL_ORIGINATION_CHANGES is not referenced by any database object
|
|
|