SFA_PERK_AY_VW

(SQL View)
 Index Back

SELECT A.EMPLID , A.AID_YEAR , D.INSTITUTION , SUM(A.EXPECTED_AWARD) , SUM(A.ACTUAL_AWARD) FROM PS_STDNT_AGGR_SCHL A , PS_AGGR_LIMIT_TBL B , PS_INST_SCHOOL_CDS D WHERE A.AGGREGATE_AREA = B.AGGREGATE_AREA AND A.AID_YEAR = B.AID_YEAR AND A.AID_YEAR = D.AID_YEAR AND A.CPS_SCHOOL_CODE = D.CPS_SCHOOL_CODE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_AGGR_LIMIT_TBL B1 WHERE B1.AGGREGATE_AREA = B.AGGREGATE_AREA AND B1.AID_YEAR = B.AID_YEAR AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND B.FEDERAL_ID = 'PERK' AND A.EXPECTED_AWARD > 0 GROUP BY A.EMPLID , A.AID_YEAR , D.INSTITUTION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
4 EXPECTED_AWARD Number(12,2) DECIMAL(11,2) NOT NULL Expected Award
5 ACTUAL_AWARD Number(12,2) DECIMAL(11,2) NOT NULL Actual Award