Stores the Student Total Offered Amount,Accepted Amount and Paid Amount
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT FA. PERSON_ID , SUM(NVL(AWD.OFFERED_AMT , 0)) , SUM(NVL(AWD.ACCEPTED_AMT , 0)) , SUM(NVL(AWD.PAID_AMT , 0)) FROM IGF_AW_AWARD AWD , IGF_AP_FA_BASE_REC FA WHERE AWD.BASE_ID = FA.BASE_ID AND AWD.AWARD_STATUS IN ('OFFERED' , 'ACCEPTED') GROUP BY FA.PERSON_ID