EFFDTDefault Value: %date
GPAU_WL_CTL_VAL1Prompt Table: %GP_EDIT_FLD5
GPAU_WL_CTL_VAL2Prompt Table: %GP_EDIT_FLD6
GPAU_PIN_DED_NUMPrompt Table: %GP_EDIT_FLD2
GPAU_WL_DEDS_VW(SQL View) |
Index Back |
|---|---|
WH lim deduction sequenceWithholding limit deduction execution sequence |
| SELECT C.EFFDT ,C.GPAU_WL_CTL_VAL1 ,C.GPAU_WL_CTL_VAL2 ,C.GPAU_PIN_DED_NUM ,C.GPAU_WL_DED_ORD FROM PS_GPAU_WL_DED_ORD C |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 2 | GPAU_WL_CTL_VAL1 |
Character(22) | VARCHAR2(22) NOT NULL |
Withholding limit control field value1
Prompt Table: %GP_EDIT_FLD5 |
| 3 | GPAU_WL_CTL_VAL2 |
Character(22) | VARCHAR2(22) NOT NULL |
Withholding limit control field value2
Prompt Table: %GP_EDIT_FLD6 |
| 4 | GPAU_PIN_DED_NUM |
Number(8,0) | INTEGER NOT NULL |
GPAUS - Stores the deduction Pin Number for employees with SuperEC deductions.
Prompt Table: %GP_EDIT_FLD2 |
| 5 | GPAU_WL_DED_ORD | Number(3,0) | SMALLINT NOT NULL | Withholding limit deduction processing order/priority. |