INSTITUTIONAID_YEARPRT_INC_FROMPRT_INC_TOPRT_WKLY_OSL_VW(SQL View) |
Index Back |
|---|
| SELECT INSTITUTION, AID_YEAR, PRT_INC_FROM, PRT_INC_TO, PRT_NET_INC_PCT, PRT_BASE, PRT_ADI_PCT FROM PS_PRT_WKLY_OSL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 3 | PRT_INC_FROM |
Signed Number(7,0) | DECIMAL(6) NOT NULL | Parent Inc From |
| 4 | PRT_INC_TO |
Number(6,0) | INTEGER NOT NULL | Parent Inc To |
| 5 | PRT_NET_INC_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Parent Net Inc Pct |
| 6 | PRT_BASE | Number(6,0) | INTEGER NOT NULL | Parent Base |
| 7 | PRT_ADI_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Parent ADI Percent |