eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGFBV_DL_YTD_DETAILS

Product:	IGF - Financial Aid
Description:	Base view for the entity that holds Year to Date Direct Loan Details
Implementation/DBA Data:	APPS.IGFBV_DL_YTD_DETAILS

View Text

SELECT YTDD.DL_VERSION
, YTDD.RECORD_TYPE
, YTDD.SCHOOL_CODE
, YTDD.REGION_CODE
, YTDD.STATE_CODE
, YTDD.REC_COUNT
, YTDD.STAT_END_DT
, YTDD.PROCESS_DT
, YTDD.LOAN_NUMBER
, YTDD.LOAN_BKD_DT
, YTDD.DISB_BKD_DT
, YTDD.DISB_GROSS
, YTDD.DISB_FEE
, YTDD.DISB_INT_REBATE
, YTDD.DISB_NET
, YTDD.DISB_NET_ADJ
, YTDD.DISB_NUM
, YTDD.DISB_SEQ_NUM
, YTDD.TRANS_TYPE
, YTDD.TRANS_DT
, YTDD.TOTAL_GROSS
, YTDD.TOTAL_FEE
, YTDD.TOTAL_INT_REBATE
, YTDD.TOTAL_NET
, YTDD.BATCH_ID
, YTDD.YTDD_ID
, YTDD.CREATED_BY
, YTDD.CREATION_DATE
, YTDD.LAST_UPDATED_BY
, YTDD.LAST_UPDATE_DATE
, FABASE.PERSON_ID
FROM IGF_DB_YTD_DTL_ALL YTDD
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWD
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE YTDD.LOAN_NUMBER = LOANS.LOAN_NUMBER
AND AWD.AWARD_ID = LOANS.AWARD_ID
AND AWD.BASE_ID = FABASE.BASE_ID WITH READ ONLY

Columns

Name
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