GPAR_INC_ACTIONEFFDTDefault Value: %date
GPAR_INC_ACTN_RSNGPAR_ACTRSN2_VW(SQL View) |
Index Back |
|---|---|
Action/Reason CombinationsAction/Reason Combinations Increase |
| SELECT A.ACTION , A.EFFDT , A.ACTION_REASON , A.DESCR FROM PS_ACTN_REASON_TBL A , PS_ACTION_TBL B , PS_ACTION_STAT_TBL C WHERE A.ACTION = B.ACTION AND B.ACTION = C.ACTION AND C.EMPL_STATUS NOT IN ('T', 'U') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPAR_INC_ACTION |
Character(3) | VARCHAR2(3) NOT NULL | Increase Action |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GPAR_INC_ACTN_RSN |
Character(3) | VARCHAR2(3) NOT NULL | Increase Action Reason |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |