GPAU_STP_SUB_CAT_1GPAU_STP_SCD_VW(SQL View) |
Index Back |
|---|---|
Deduction ViewSTP Deduction View |
| SELECT GPAU_STP_SUB_CAT_1 , GPAU_STP_SUB_CAT , GPAU_STP_S_CAT_DES FROM PS_GPAU_STP_SUBCAT WHERE GPAU_STP_CAT = 'DEDUCTION' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPAU_STP_SUB_CAT_1 |
Character(30) | VARCHAR2(30) NOT NULL | STP Sub-Category to maintain Key Structure |
| 2 | GPAU_STP_SUB_CAT | Character(30) | VARCHAR2(30) NOT NULL | STP Sub-Category |
| 3 | GPAU_STP_S_CAT_DES | Character(40) | VARCHAR2(40) NOT NULL | STP Category Description |