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: IGF_AW_ADISB_COA_MATCH_V

Product:	IGF - Financial Aid (Obsolete)
Description:	Retrieves the awards that a student has to the extent of his common Cost of Attendance terms.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AWD.BASE_ID
, AWD.FUND_ID
, DISB.AWARD_ID
, DISB.DISB_NUM
, DISB.LD_CAL_TYPE
, DISB.LD_SEQUENCE_NUMBER
, DISB.DISB_GROSS_AMT
, DISB.DISB_NET_AMT
, DISB.DISB_DATE
, DISB.TRANS_TYPE
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_AWD_DISB_ALL DISB
, IGF_AW_COA_ITM_TERMS COA
WHERE AWD.AWARD_ID = DISB.AWARD_ID
AND AWD.AWARD_STATUS IN ('OFFERED'
, 'ACCEPTED')
AND AWD.BASE_ID = COA.BASE_ID
AND DISB.LD_CAL_TYPE = COA.LD_CAL_TYPE
AND DISB.LD_SEQUENCE_NUMBER = COA.LD_SEQUENCE_NUMBER

Columns

Name
BASE_ID
FUND_ID
AWARD_ID
DISB_NUM
LD_CAL_TYPE
LD_SEQUENCE_NUMBER
DISB_GROSS_AMT
DISB_NET_AMT
DISB_DATE
TRANS_TYPE