View: IGF_SE_WORK_AWD_PRG_V

Product:	IGF - Financial Aid
Description:	View that holds student work award progress information in an award year
Implementation/DBA Data:	APPS.IGF_SE_WORK_AWD_PRG_V

View Text

SELECT SE.ROWID ROW_ID
, AWD.BASE_ID
, AWD.AWARD_ID
, AWD.FUND_ID
, FM.FUND_CODE
, FM.DESCRIPTION FUND_CODE_DESC
, FC.FED_FUND_CODE
, AWD.AWARD_STATUS
, SE.AUTH_ID
, SE.AUTHORIZATION_DATE
, AWD.OFFERED_AMT
, AWD.ACCEPTED_AMT
, SE.ACCEPTED_AMNT
, AWD.PAID_AMT
, (NVL(AWD.ACCEPTED_AMT
, 0) - NVL(AWD.PAID_AMT
, 0)) REMAINING_AMT
, DECODE(NVL(AWD.ACCEPTED_AMT
, 0)
, 0
, 0
, ROUND(NVL(AWD.PAID_AMT
, 0) * 100/ AWD.ACCEPTED_AMT)) PROGRESS_TWDS_LMT
, SE.NOTIFICATION_DATE
, AWD.LEGACY_RECORD_FLAG
, SE.CREATED_BY
, SE.CREATION_DATE
, SE.LAST_UPDATED_BY
, SE.LAST_UPDATE_DATE
, SE.LAST_UPDATE_LOGIN
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_FUND_MAST_ALL FM
, IGF_AW_FUND_CAT FC
, IGF_SE_AUTH SE
WHERE SE.AWARD_ID(+) = AWD.AWARD_ID
AND AWD.FUND_ID = FM.FUND_ID
AND FM.FUND_CODE = FC.FUND_CODE
AND FC.FED_FUND_CODE = 'FWS'
AND SE.FLAG(+) = 'A'

Columns