EFFDTDefault Value: %date
GPAU_WL_CTL_VAL1GPAU_WL_CTL_VAL2GPAU_PIN_DED_NUMPrompt Table: %GP_EDIT_FLD2
GPAU_NRP_WL2_VW(SQL View) |
Index Back |
|---|---|
Withholding limit ded. prtyWithholding limit tax deductions priority/order |
| SELECT EFFDT ,GPAU_WL_CTL_VAL1 ,GPAU_WL_CTL_VAL2 ,GPAU_PIN_DED_NUM + 50000000 ,GPAU_WL_DED_ORD FROM PS_GPAU_WL_DED_ORD |
| # | 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 |
| 3 | GPAU_WL_CTL_VAL2 |
Character(22) | VARCHAR2(22) NOT NULL | Withholding limit control field value2 |
| 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. |