PY_W4_STG_VW(SQL View) |
Index Back |
|---|---|
W4 Stage View for ApprovalsW4 Stage Data View for the Approvals Component |
| SELECT EMPLID , COMPANY , STATE , SESSION_ID , SEQ_NBR , SPECIAL_FWT_STATUS , FWT_MAR_STATUS , MARRIED_FILE_SINGL , FWT_ALLOWANCES , RESIDENT , FWT_ADDL_AMT , SPECIAL_SWT_STATUS , SWT_MAR_STATUS , SWT_ALLOWANCES , SWT_ADDL_ALLOWNCES , PERCENT_OF_FWT , SWT_ADDL_AMT , ADDL_AMT_ADJ , ANNL_EXEMPTION_AMT , FWT_FORM_VERSION , FWT_MULTI_JOBS , FWT_TTL_DEP_AMT , FWT_OTH_INCOME , FWT_DED_ADJ , RES_ADDL_ALLOW FROM PS_PY_W4_STG_STATE UNION SELECT EMPLID , COMPANY , STATE , SESSION_ID , SEQ_NBR , SPECIAL_FWT_STATUS , FWT_MAR_STATUS , MARRIED_FILE_SINGL , FWT_ALLOWANCES , RESIDENT , FWT_ADDL_AMT , SPECIAL_SWT_STATUS , SWT_MAR_STATUS , SWT_ALLOWANCES , SWT_ADDL_ALLOWNCES , PERCENT_OF_FWT , SWT_ADDL_AMT , ADDL_AMT_ADJ , ANNL_EXEMPTION_AMT , FWT_FORM_VERSION , FWT_MULTI_JOBS , FWT_TTL_DEP_AMT , FWT_OTH_INCOME , FWT_DED_ADJ , RES_ADDL_ALLOW FROM PS_PY_W4_HIS_STATE WHERE SEQ_NBR=1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 4 | SESSION_ID |
Character(36) | VARCHAR2(36) NOT NULL | Session ID |
| 5 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | SPECIAL_FWT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Special FWT Status
A=Nonresident alien E=No taxable gross; no tax taken G=Maintain taxable gross N=None |
| 7 | FWT_MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
FWT Marital Status
H=Head of Household M=Married S=Single X=Exempt |
| 8 | MARRIED_FILE_SINGL | Character(1) | VARCHAR2(1) NOT NULL | Married Filing Single |
| 9 | FWT_ALLOWANCES | Number(3,0) | SMALLINT NOT NULL | FWT Allowances |
| 10 | RESIDENT | Character(1) | VARCHAR2(1) NOT NULL | Resident |
| 11 | FWT_ADDL_AMT | Number(8,2) | DECIMAL(7,2) NOT NULL | FWT Additional Amount |
| 12 | 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 |
| 13 | SWT_MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
SWT Marital/Tax Status
Prompt Table: SWT_MARSTAT_TBL |
| 14 | SWT_ALLOWANCES | Number(3,0) | SMALLINT NOT NULL | Withholding Allowances |
| 15 | SWT_ADDL_ALLOWNCES | Number(3,0) | SMALLINT NOT NULL | Additional Allowances |
| 16 | PERCENT_OF_FWT | Number(6,3) | DECIMAL(5,3) NOT NULL | AZ Withholding Percent |
| 17 | SWT_ADDL_AMT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | SWT Additional Amount |
| 18 | ADDL_AMT_ADJ | Character(1) | VARCHAR2(1) NOT NULL |
Additional Amount Adjustment
D=Decrease Additional Amount I=Increase Additional Amount |
| 19 | ANNL_EXEMPTION_AMT | Number(8,0) | INTEGER NOT NULL | MS Annual Exemption Amount |
| 20 | 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 |
| 21 | FWT_MULTI_JOBS | Character(1) | VARCHAR2(1) NOT NULL | 2020 W4 changes - Multiple Jobs Indicator |
| 22 | FWT_TTL_DEP_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Total Dependent Amount |
| 23 | FWT_OTH_INCOME | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Other Income |
| 24 | FWT_DED_ADJ | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Deduction Adjustment |
| 25 | RES_ADDL_ALLOW | Number(3,0) | SMALLINT NOT NULL | Res State Addl Allowances |