[Home] [Help] [Dependency Information]
Object Name: | IGFBV_DL_YTD_SUMMARY |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFBV_DL_YTD_SUMMARY |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Base view for the entity that holds Year to Date Direct Loan Summary
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 | ||
DISBURSEMENT_SUMMARY_TYPE | VARCHAR2 | (2) | Indicates the Disbursement Summary Type | |
BOOKED_GROSS_AMOUNT | NUMBER | (15) | Indicates the Gross Amount Booked | |
BOOKED_FEES_AMOUNT | NUMBER | (15) | Indicates the Fee for the Gross Amount Booked | |
BOOKED_INTEREST_REBATE | NUMBER | (15) | Indicates the Disbursement Interest Rebate Amount for the Booked Amount | |
BOOKED_NET_AMOUNT | NUMBER | (15) | Indicates the Net Amount Booked | |
UNBOOKED_GROSS_AMOUNT | NUMBER | (15) | Indicates the Gross Amount not booked | |
UNBOOKED_FEES_AMOUNT | NUMBER | (15) | Indicates the Fee for the Gross Amount not booked | |
UNBOOKED_INTEREST_REBATE | NUMBER | (15) | Indicates the Disbursement Interest Rebate Amount for the not booked Amount | |
UNBOOKED_NET_AMOUNT | NUMBER | (15) | Indicates the Net not booked Amount | |
BATCH_ID | VARCHAR2 | (30) | Indicates the Unique Identifier for Batch | |
YEAR_TO_DATE_DISB_SUMMARY_ID | NUMBER | (15) | Yes | Indicates the unique identifier for the summary of the year to date data for disbursement |
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 DIRECT_LOAN_SPEC_VERSION
, RECORD_TYPE
, SCHOOL_CODE
, REGION_CODE
, STATE_CODE
, RECORD_COUNT
, STATEMENT_END_DATE
, PROCESS_DATE
, DISBURSEMENT_SUMMARY_TYPE
, BOOKED_GROSS_AMOUNT
, BOOKED_FEES_AMOUNT
, BOOKED_INTEREST_REBATE
, BOOKED_NET_AMOUNT
, UNBOOKED_GROSS_AMOUNT
, UNBOOKED_FEES_AMOUNT
, UNBOOKED_INTEREST_REBATE
, UNBOOKED_NET_AMOUNT
, BATCH_ID
, YEAR_TO_DATE_DISB_SUMMARY_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFBV_DL_YTD_SUMMARY;
APPS.IGFBV_DL_YTD_SUMMARY is not referenced by any database object
|
|
|