EMPLIDAGGREGATE_PROGRAMDLHL=DIRECT - HEAL
DSTF=DIRECT - STAFFORD
FLHL=FFELP - HEAL
FSTF=FFELP - STAFFORD
AID_YEARSFA_STU_AGRPRG2(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , C.AGGREGATE_PROGRAM , A.AID_YEAR , SUM(A.UNDRGRAD_TOTAL) , SUM(A.GRADUATE_TOTAL) FROM PS_STDNT_AGGR_LIFE A , PS_AGGR_LIMIT_TBL B , PS_AGGR_PROG_TBL C WHERE A.AGGREGATE_AREA = B.AGGREGATE_AREA AND A.AID_YEAR = B.AID_YEAR AND B.AGGREGATE_PROGRAM = C.AGGREGATE_PROGRAM 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) GROUP BY A.EMPLID, C.AGGREGATE_PROGRAM, A.AID_YEAR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | AGGREGATE_PROGRAM |
Character(4) | VARCHAR2(4) NOT NULL |
Aggregate Program
DLHL=DIRECT - HEAL DSTF=DIRECT - STAFFORD FLHL=FFELP - HEAL FSTF=FFELP - STAFFORD |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 4 | UNDRGRAD_TOTAL | Number(12,2) | DECIMAL(11,2) NOT NULL | Total Undergrad |
| 5 | GRADUATE_TOTAL | Number(12,2) | DECIMAL(11,2) NOT NULL | Total Graduate |