GPAU_STP_SUB_CAT_1GPAU_STP_SCA_VW(SQL View) |
Index Back |
|---|---|
Allowance ViewSTP Allowance View |
| SELECT PS_GPAU_STP_SUBCAT.GPAU_STP_SUB_CAT_1 , PS_GPAU_STP_SUBCAT.GPAU_STP_SUB_CAT , PS_GPAU_STP_SUBCAT.GPAU_STP_S_CAT_DES FROM PS_GPAU_STP_SUBCAT WHERE PS_GPAU_STP_SUBCAT.GPAU_STP_CAT IN ('ALLOWANCE', 'SS', 'RFB', 'SUPER', 'LUMPSUM', 'PAIDLEAVE') AND PS_GPAU_STP_SUBCAT.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GPAU_STP_SUBCAT A1 WHERE A1.GPAU_STP_CAT = PS_GPAU_STP_SUBCAT.GPAU_STP_CAT AND A1.GPAU_STP_SUB_CAT_1 = PS_GPAU_STP_SUBCAT.GPAU_STP_SUB_CAT_1 AND A1.EFFDT <= %CurrentDateIn) |
| # | 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 |