[Home] [Help]
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
Name |
DOCUMENT_ID_TXT |
REP_ENTITY_ID_TXT |
FIN_AWARD_TYPE |
FIN_AWARD_YEAR |
TOT_CNT_NUM |
TOT_REP_AWD_AMT |
TOT_REP_DISB_AMT |