EMPLIDAGGREGATE_PROGRAMDLHL=DIRECT - HEAL
DSTF=DIRECT - STAFFORD
FLHL=FFELP - HEAL
FSTF=FFELP - STAFFORD
AGGREGATE_AREAAID_YEARC=Cumulative
D=Distinct
SFA_STU_AGRPRG3(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , P.AGGREGATE_PROGRAM , A.AGGREGATE_AREA , A.AID_YEAR , B.UNDRGRAD_LIMIT , B.GRADUATE_LIMIT , B.MAX_TERMS , B.GRAD_LIMIT_RULE , A.UNDRGRAD_TOTAL , A.GRADUATE_TOTAL , A.TOTAL_TERMS FROM PS_STDNT_AGGR_LIFE A , PS_AGGR_LIMIT_TBL B , PS_AGGR_PROG_TBL P WHERE A.AGGREGATE_AREA = B.AGGREGATE_AREA AND A.AID_YEAR = B.AID_YEAR AND B.AGGREGATE_PROGRAM = P.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 |
| 4 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 5 | UNDRGRAD_LIMIT | Number(12,2) | DECIMAL(11,2) NOT NULL | Undergrad Lifetime |
| 6 | GRADUATE_LIMIT | Number(12,2) | DECIMAL(11,2) NOT NULL | Graduate Lifetime |
| 7 | MAX_TERMS | Number(2,0) | SMALLINT NOT NULL | Max Terms |
| 8 | GRAD_LIMIT_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Graduate Limit Rule
C=Cumulative D=Distinct |
| 9 | UNDRGRAD_TOTAL | Number(12,2) | DECIMAL(11,2) NOT NULL | Total Undergrad |
| 10 | GRADUATE_TOTAL | Number(12,2) | DECIMAL(11,2) NOT NULL | Total Graduate |
| 11 | TOTAL_TERMS | Number(2,0) | SMALLINT NOT NULL | Total Terms |