FWT_FORM_VERSIONA=W-4 - 2019 or Earlier
B=W-4 - 2020 or Later
C=W-4P - 2022 or Later
D=W-4R - 2022 or Later
STATESWT_MAR_STATUSEFFDTDefault Value: %date
A=Active
I=Inactive
SWT_TAX_ST_VW(SQL View) |
Index Back |
|---|---|
State tax status view |
| SELECT 'B' ,STATE ,SWT_MAR_STATUS ,EFFDT ,EFF_STATUS FROM PS_SWT_MARSTAT_TBL WHERE STATE IN ('CO' ,'ND' ,'NM' ,'UT') UNION SELECT 'A' ,STATE ,SWT_MAR_STATUS ,EFFDT ,EFF_STATUS FROM PS_SWT_MARSTAT_TBL WHERE STATE IN ('CO' ,'ND' ,'NM' ,'UT') AND SWT_MAR_STATUS <> 'H' UNION SELECT 'A' ,STATE ,SWT_MAR_STATUS ,EFFDT ,EFF_STATUS FROM PS_SWT_MARSTAT_TBL WHERE STATE NOT IN ('CO' ,'ND' ,'NM' ,'UT') UNION SELECT 'B' ,STATE ,SWT_MAR_STATUS ,EFFDT ,EFF_STATUS FROM PS_SWT_MARSTAT_TBL WHERE STATE NOT IN ('CO' ,'ND' ,'NM' ,'UT') UNION SELECT 'C' ,STATE ,SWT_MAR_STATUS ,EFFDT ,EFF_STATUS FROM PS_SWT_MARSTAT_TBL UNION SELECT 'D' ,STATE ,SWT_MAR_STATUS ,EFFDT ,EFF_STATUS FROM PS_SWT_MARSTAT_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 3 | SWT_MAR_STATUS |
Character(1) | VARCHAR2(1) NOT NULL | SWT Marital/Tax Status |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |