[Home] [Help] [Dependency Information]
Object Name: | IGFBV_DL_YTD_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFBV_DL_YTD_DETAILS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Base view for the entity that holds Year to Date Direct Loan Details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIRECT_LOAN_SPEC_VERSION | VARCHAR2 | (30) | Yes | Indicates the Direct Loan File Format Version |
RECORD_TYPE | VARCHAR2 | (1) | Indicates the Record Type which is either Year-To-Date Summary or Monthly Summary information | |
SCHOOL_CODE | VARCHAR2 | (6) | Indicates the School Code | |
REGION_CODE | VARCHAR2 | (2) | Indicates Region Code | |
STATE_CODE | VARCHAR2 | (2) | Indicates State Code | |
RECORD_COUNT | NUMBER | Indicates Record Count Sequence | ||
STATEMENT_END_DATE | DATE | Indicates the Statement End Date for the report | ||
PROCESS_DATE | DATE | Indicates the Process date | ||
LOAN_NUMBER | VARCHAR2 | (30) | Indicates the Loan Number | |
LOAN_BOOKED_DATE | DATE | Indicates the Date on which the Loan was booked. | ||
DISBURSEMENT_BOOKED_DATE | DATE | Indicates the Date on which the Disbursement was booked. | ||
DISBURSEMENT_GROSS_AMOUNT | NUMBER | (15) | Indicates the Disbursement Gross Amount | |
DISBURSEMENT_FEE | NUMBER | (15) | Indicates the Disbursement Fee | |
DISBURSEMENT_INTEREST_REBATE | NUMBER | (15) | Indicates the Disbursement Interest Rebate Amount | |
DISBURSEMENT_NET_AMOUNT | NUMBER | (15) | Indicates the Disbursement Net Amount | |
DISBURSEMENT_NET_ADJUSTMENT | NUMBER | (15) | Indicates the Disbursement Net Adjustment Amount | |
DISBURSEMENT_NUMBER | NUMBER | (2) | Indicates the Disbursement Number | |
DISBURSEMENT_SEQUENCE_NUMBER | NUMBER | (2) | Indicates the Disbursement Sequence Number | |
DISBURSEMENT_TRANSACTION_TYPE | VARCHAR2 | (30) | Indicates the Disbursement Type | |
DISBURSEMENT_TRANSACTION_DATE | DATE | Indicates the Transaction Type Date | ||
TOTAL_GROSS_AMOUNT | NUMBER | (15) | Indicates the Total Gross Amount | |
TOTAL_FEE_AMOUNT | NUMBER | (15) | Indicates the Total Fee | |
TOTAL_INTEREST_REBATE_AMOUNT | NUMBER | (15) | Indicates the Total Interest Rebate Amount | |
TOTAL_NET_AMOUNT | NUMBER | (15) | Indicates the Total Net AMount | |
BATCH_ID | VARCHAR2 | (30) | Indicates the Unique Identifier for Batch | |
YEAR_TO_DATE_DISBURSEMENT_ID | NUMBER | (15) | Yes | Indicates the unique identifier for the data loaded through the year to date disbursement data file. |
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 | |
PERSON_ID | NUMBER | (15) | Yes | Person identifier |
Cut, paste (and edit) the following text to query this object:
SELECT DIRECT_LOAN_SPEC_VERSION
, RECORD_TYPE
, SCHOOL_CODE
, REGION_CODE
, STATE_CODE
, RECORD_COUNT
, STATEMENT_END_DATE
, PROCESS_DATE
, LOAN_NUMBER
, LOAN_BOOKED_DATE
, DISBURSEMENT_BOOKED_DATE
, DISBURSEMENT_GROSS_AMOUNT
, DISBURSEMENT_FEE
, DISBURSEMENT_INTEREST_REBATE
, DISBURSEMENT_NET_AMOUNT
, DISBURSEMENT_NET_ADJUSTMENT
, DISBURSEMENT_NUMBER
, DISBURSEMENT_SEQUENCE_NUMBER
, DISBURSEMENT_TRANSACTION_TYPE
, DISBURSEMENT_TRANSACTION_DATE
, TOTAL_GROSS_AMOUNT
, TOTAL_FEE_AMOUNT
, TOTAL_INTEREST_REBATE_AMOUNT
, TOTAL_NET_AMOUNT
, BATCH_ID
, YEAR_TO_DATE_DISBURSEMENT_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PERSON_ID
FROM APPS.IGFBV_DL_YTD_DETAILS;
APPS.IGFBV_DL_YTD_DETAILS is not referenced by any database object
|
|
|