[Home] [Help] [Dependency Information]
Object Name: | IGF_DB_YTD_DTL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_DB_YTD_DTL |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Stores the data loaded through the year to date disbursement data file.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
YTDD_ID | NUMBER | (15) | Yes | Indicates the unique identifier for the data loaded through the year to date disbursement data file. |
DL_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 | |
BATCH_ID | VARCHAR2 | (30) | Indicates the Unique Identifier for Batch | |
SCHOOL_CODE | VARCHAR2 | (6) | Indicates the School Code | |
STAT_END_DT | DATE | Indicates the Statement End Date for the report | ||
PROCESS_DT | DATE | Indicates the Process date | ||
LOAN_NUMBER | VARCHAR2 | (30) | Indicates the Loan Number | |
LOAN_BKD_DT | DATE | Indicates the Date on which the Loan was booked. | ||
DISB_BKD_DT | DATE | Indicates the Date on which the Disbursement was booked. | ||
DISB_GROSS | NUMBER | (15) | Indicates the Disbursement Gross Amount | |
DISB_FEE | NUMBER | (15) | Indicates the Disbursement Fee | |
DISB_INT_REBATE | NUMBER | (15) | Indicates the Disbursement Interest Rebate Amount | |
DISB_NET | NUMBER | (15) | Indicates the Disbursement Net Amount | |
DISB_NET_ADJ | NUMBER | (15) | Indicates the Disbursement Net Adjustment Amount | |
DISB_NUM | NUMBER | (2) | Indicates the Disbursement Number | |
DISB_SEQ_NUM | NUMBER | (2) | Indicates the Disbursement Sequence Number | |
TRANS_TYPE | VARCHAR2 | (30) | Indicates the Disbursement Type | |
TRANS_DT | DATE | Indicates the Transaction Type Date | ||
TOTAL_GROSS | NUMBER | (15) | Indicates the Total Gross Amount | |
TOTAL_FEE | NUMBER | (15) | Indicates the Total Fee | |
TOTAL_INT_REBATE | NUMBER | (15) | Indicates the Total Interest Rebate Amount | |
TOTAL_NET | NUMBER | (15) | Indicates the Total Net Amount | |
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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent program | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column for concurrent program | |
PROGRAM_ID | NUMBER | (15) | Standard Who column for concurrent program | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent program | ||
REGION_CODE | VARCHAR2 | (2) | Indicates Region Code | |
STATE_CODE | VARCHAR2 | (2) | Indicates State Code | |
REC_COUNT | NUMBER | Indicates Record Count Sequence |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, YTDD_ID
, DL_VERSION
, RECORD_TYPE
, BATCH_ID
, SCHOOL_CODE
, STAT_END_DT
, PROCESS_DT
, LOAN_NUMBER
, LOAN_BKD_DT
, DISB_BKD_DT
, DISB_GROSS
, DISB_FEE
, DISB_INT_REBATE
, DISB_NET
, DISB_NET_ADJ
, DISB_NUM
, DISB_SEQ_NUM
, TRANS_TYPE
, TRANS_DT
, TOTAL_GROSS
, TOTAL_FEE
, TOTAL_INT_REBATE
, TOTAL_NET
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REGION_CODE
, STATE_CODE
, REC_COUNT
FROM APPS.IGF_DB_YTD_DTL;
|
|
|