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_SL_REP_SMRY_V

Product:	IGF - Financial Aid (Obsolete)
Description:	View used for reproting the financial summary tag in the outbound XML for Direct Loan
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, FIN_AWARD_YEAR
, LOAN_TYPE
, DECODE (LOAN_TYPE
, 'DLS'
, 'DLSUBSIDIZED'
, 'DLP'
, 'DLPLUS'
, 'DLU'
, 'DLUNSUBSIDIZED') FIN_AWARD_TYPE
, COUNT(DISTINCT BASE_ID) TOT_CNT_NUM
, SUM(LOAN_AMT_ACCEPTED) TOT_REP_AWD_AMT
, SUM(NVL(DISB_AMT
, 0)) TOT_REP_DISB_AMT
FROM IGF_SL_LOR_LOC_ALL LOC1
, (SELECT LOC2.AWARD_ID
, SUM(DISB2.DISB_ACCEPTED_AMT) DISB_AMT FROM IGF_AW_DB_COD_DTLS DISB2
, IGF_SL_LOR_LOC_ALL LOC2 WHERE LOC2.AWARD_ID = DISB2.AWARD_ID GROUP BY LOC2.AWARD_ID )DISB1
WHERE LOC1.AWARD_ID = DISB1.AWARD_ID (+)
AND LOC1.LOAN_TYPE IN ('DLP'
, 'DLS'
, 'DLU') GROUP BY DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, FIN_AWARD_YEAR
, LOAN_TYPE

Columns

Name
DOCUMENT_ID_TXT
REP_ENTITY_ID_TXT
FIN_AWARD_YEAR
LOAN_TYPE
FIN_AWARD_TYPE
TOT_CNT_NUM
TOT_REP_AWD_AMT
TOT_REP_DISB_AMT