EMPLIDAGGREGATE_PROGRAMDLHL=DIRECT - HEAL
DSTF=DIRECT - STAFFORD
FLHL=FFELP - HEAL
FSTF=FFELP - STAFFORD
AGGREGATE_AREASFA_STU_PRGAREA(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.EMPLID , C.AGGREGATE_PROGRAM , A.AGGREGATE_AREA 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) |
| # | 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 | AGGREGATE_AREA |
Character(10) | VARCHAR2(10) NOT NULL | Aggregate Area |