PY_W4_MAIN(SQL Table) |
Index Back |
|---|---|
Tax Withholding JurisdictionsParent record created to temporarily store informaton for Tax Withholding Forms. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
| 6 | W4_FORM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Form Type
F=Federal L=Local S=State |
| 7 | W4_JURISDICTION | Character(20) | VARCHAR2(20) NOT NULL | Tax Withholding Forms |
| 8 | W4_STATE_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Jurisdiction |
| 9 | PY_DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Company |
| 10 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 11 | W4_TAX_STATUS | Character(15) | VARCHAR2(15) NOT NULL | Tax Status |
| 12 | RESIDENT | Character(1) | VARCHAR2(1) NOT NULL | Resident |
| 13 | SWT_ALLOWANCES | Number(3,0) | SMALLINT NOT NULL | Withholding Allowances |
| 14 | ADDL_AMT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Additional Withholding Amount |
| 15 | SWT_ADDL_ALLOWNCES | Number(3,0) | SMALLINT NOT NULL | Additional Allowances |
| 16 | ADDL_PCT | Number(6,3) | DECIMAL(5,3) NOT NULL | Additional Withholding Percent |
| 17 | ANNL_EXEMPTION_AMT | Number(8,0) | INTEGER NOT NULL | MS Annual Exemption Amount |
| 18 | RES_ADDL_ALLOW | Number(3,0) | SMALLINT NOT NULL | Res State Addl Allowances |
| 19 | W4_OTHER | Character(1) | VARCHAR2(1) NOT NULL |
Other
A=Non-Resident Alien L=Lock-in Letter M=Multiple Jobs/Spouse Works |
| 20 | SPECIAL_SWT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Special Tax Status
A=Nonresident alien (Fed Rules) E=No taxable gross; no tax taken G=Maintain taxable gross N=None |
| 21 | W4_APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
A=Approved D=Denied P=Pending Approval |
| 22 | SESSION_ID | Character(36) | VARCHAR2(36) NOT NULL | Session ID |
| 23 | ORDERNO | Number(5,0) | INTEGER NOT NULL | Sort Order |
| 24 | PY_HIDE_UPD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicator to hide state withholding form
Y/N Table Edit |
| 25 | FWT_FORM_VERSION | Character(1) | VARCHAR2(1) NOT NULL |
2020 W4 - to indicate if the tax data is based on 2019 W4 form or 2020 W4 form.
A=W-4 - 2019 or Earlier B=W-4 - 2020 or Later C=W-4P - 2022 or Later D=W-4R - 2022 or Later |
| 26 | FWT_MULTI_JOBS | Character(1) | VARCHAR2(1) NOT NULL | 2020 W4 changes - Multiple Jobs Indicator |
| 27 | FWT_TTL_DEP_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Total Dependent Amount |
| 28 | FWT_OTH_INCOME | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Other Income |
| 29 | FWT_DED_ADJ | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Deduction Adjustment |