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_FUND_DET_GRP_V

Product:	IGF - Financial Aid (Obsolete)
Description:	Stores the Fund Code wise Total Offered Amount ,Accepted Amount and Paid Amount for a student
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, FM.FUND_CODE
, SUM(NVL(AWD.OFFERED_AMT
, 0))
, SUM(NVL(AWD.ACCEPTED_AMT
, 0))
, SUM(NVL(AWD.PAID_AMT
, 0))
, FA.PERSON_NUMBER
FROM IGF_AW_AWARD_V AWD
, IGF_AW_FUND_MAST FM
, IGF_AP_FA_CON_V FA
, IGS_CA_INST CI
WHERE AWD.FUND_ID = FM.FUND_ID
AND CI.CAL_TYPE = FA.CI_CAL_TYPE
AND AWD.AWARD_STATUS IN ('OFFERED'
, 'ACCEPTED')
AND CI.SEQUENCE_NUMBER=FA.CI_SEQUENCE_NUMBER
AND AWD.BASE_ID=FA.BASE_ID GROUP BY FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, FM.FUND_CODE
, FA.PERSON_NUMBER

Columns

Name
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
CI_ALTERNATE_CODE
CI_START_DT
CI_END_DT
FUND_CODE
OFFRD_AMT
ACCPT_AMT
PAID_AMT
PERSON_NUMBER