View: IGF_GR_REP_SMRY_V

Product:	IGF - Financial Aid
Description:	View used for reporting the financial summary tag in the outbound XML for Pell
Implementation/DBA Data:	APPS.IGF_GR_REP_SMRY_V

View Text

SELECT LOC1.DOCUMENT_ID_TXT
, TRIM(LOC1.REP_ENTITY_ID_TXT)
, 'PELL' FIN_AWARD_TYPE
, FIN_AWARD_YEAR
, COUNT(DISTINCT BASE_ID) TOT_CNT_NUM
, SUM(AWARD_AMT) TOT_REP_AWD_AMT
, SUM(DISB_AMT) TOT_REP_DISB_AMT
FROM IGF_GR_COD_DTLS LOC1
, (SELECT LOC2.AWARD_ID
, SUM(DISB2.DISB_ACCEPTED_AMT) DISB_AMT
FROM IGF_AW_DB_COD_DTLS DISB2
, IGF_GR_COD_DTLS LOC2
WHERE LOC2.AWARD_ID = DISB2.AWARD_ID GROUP BY LOC2.AWARD_ID ) DISB1
WHERE LOC1.AWARD_ID = DISB1.AWARD_ID GROUP BY DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, FIN_AWARD_YEAR

Columns