EMPLIDCPS_SCHOOL_CODESFA_PERKAGGR_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , A.CPS_SCHOOL_CODE , SUM(A.EXPECTED_AWARD) , SUM(A.ACTUAL_AWARD) , A.CURRENCY_CD FROM PS_STDNT_AGGR_SCHL A , PS_AGGR_LIMIT_TBL B WHERE A.AGGREGATE_AREA = B.AGGREGATE_AREA AND A.AID_YEAR = B.AID_YEAR 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' GROUP BY A.EMPLID, A.CPS_SCHOOL_CODE, A.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CPS_SCHOOL_CODE |
Character(6) | VARCHAR2(6) NOT NULL | CPS School Code. Also known as Title IV School Code |
| 3 | EXPECTED_AWARD | Number(12,2) | DECIMAL(11,2) NOT NULL | Expected Award |
| 4 | ACTUAL_AWARD | Number(12,2) | DECIMAL(11,2) NOT NULL | Actual Award |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |