STDNT_AG_INP_VW(SQL View) |
Index Back |
|---|---|
Incoming Aggregate ViewThis view is used for isolating Incoming Aggregate data from all aggregate data |
| SELECT A.EMPLID , A.AGGREGATE_AREA , A.AID_YEAR , A.AGGREGATE_LEVEL , A.CPS_SCHOOL_CODE , A.AGGREGATE_STATUS , A.EXPECTED_AWARD , A.ACTUAL_AWARD , A.SCHEDULED_AWARD , A.TERM_COUNT , A.ACAD_YEAR , A.CURRENCY_CD FROM PS_STDNT_AGGR_SCHL A WHERE A.AGGREGATE_STATUS='I' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | AGGREGATE_AREA |
Character(10) | VARCHAR2(10) NOT NULL | Aggregate Area |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: FED_AID_YR_TBL |
| 4 | AGGREGATE_LEVEL |
Character(2) | VARCHAR2(2) NOT NULL |
Aggregate Level
Prompt Table: AGGR_LVL_VW |
| 5 | CPS_SCHOOL_CODE |
Character(6) | VARCHAR2(6) NOT NULL |
CPS School Code. Also known as Title IV School Code
Prompt Table: SCHL_CODE_SRCH |
| 6 | AGGREGATE_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Aggregate Status
I=Imported R=Internal to System Default Value: I |
| 7 | EXPECTED_AWARD | Number(12,2) | DECIMAL(11,2) NOT NULL | Expected Award |
| 8 | ACTUAL_AWARD | Number(12,2) | DECIMAL(11,2) NOT NULL | Actual Award |
| 9 | SCHEDULED_AWARD | Number(12,2) | DECIMAL(11,2) NOT NULL | Scheduled Award |
| 10 | TERM_COUNT | Number(2,0) | SMALLINT NOT NULL | Terms for Level |
| 11 | ACAD_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Academic Year
Default Value: STDNT_AG_INP_VW.AID_YEAR |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |