STATETAXDAT_UPG (SQL Table)	Index Back
EE U.S. State Tax Data This record is used to define an employee's status for state tax purposes. If an employee works in multiple states or lives in a state other than the state of employment, a record for each state must be maintained. A view W3PY_W4_STX_VW based on this record has been created for the purpose of WEB-enabled W4 update. Changes made to the record STATE_TAX_DATA would need to be analyzed and made to W3PY_W4_STX_VW, if necessary.

STATETAXDAT_UPG

(SQL Table)

EE U.S. State Tax Data

This record is used to define an employee's status for state tax purposes. If an employee works in multiple states or lives in a state other than the state of employment, a record for each state must be maintained. A view W3PY_W4_STX_VW based on this record has been created for the purpose of WEB-enabled W4 update. Changes made to the record STATE_TAX_DATA would need to be analyzed and made to W3PY_W4_STX_VW, if necessary.

Parent Record Of LOCALTAXDAT_UPG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TAX_TBL

3 RESIDENT Character(1) VARCHAR2(1) NOT NULL Resident
Y/N Table Edit
Default Value: Y

4 NON_RES_DECLARED Character(1) VARCHAR2(1) NOT NULL Non-Residency Statement Filed
Y/N Table Edit
Default Value: N

5 SPECIAL_SWT_STATUS Character(1) VARCHAR2(1) NOT NULL Special Tax Status
A=Non-Resident Alien; Fed Rules
E=Exempt
G=Maintain gross
N=None

6 SWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL SWT Marital/Tax Status
2=Married
S=Single

7 SWT_ALLOWANCES Number(3,0) SMALLINT NOT NULL Withholding Allowances

8 SWT_EST_ALLOW Number(3,0) SMALLINT NOT NULL Estimated Allowances

9 SWT_ADDL_ALLOWNCES Number(3,0) SMALLINT NOT NULL Additional Allowances

10 SWT_ADDL_AMT Signed Number(9,2) DECIMAL(7,2) NOT NULL SWT Additional Amount

11 SWT_EST_AMT Signed Number(9,2) DECIMAL(7,2) NOT NULL SWT Estimated Amount

12 SWT_SP_EST_AMT Signed Number(9,2) DECIMAL(7,2) NOT NULL SWT Special Exemption Amount

13 SWT_ADDL_PCT Number(6,3) DECIMAL(5,3) NOT NULL SWT Additional Percentage

14 UI_JURISDICTION Character(1) VARCHAR2(1) NOT NULL UI Jurisdiction
Y/N Table Edit
Default Value: N

15 RETIREMENT_PLAN Character(50) VARCHAR2(50) NOT NULL Retirement Plan
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TAX_TBL
3	RESIDENT	Character(1)	VARCHAR2(1) NOT NULL	Resident Y/N Table Edit Default Value: Y
4	NON_RES_DECLARED	Character(1)	VARCHAR2(1) NOT NULL	Non-Residency Statement Filed Y/N Table Edit Default Value: N
5	SPECIAL_SWT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Special Tax Status A=Non-Resident Alien; Fed Rules E=Exempt G=Maintain gross N=None
6	SWT_MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	SWT Marital/Tax Status 2=Married S=Single
7	SWT_ALLOWANCES	Number(3,0)	SMALLINT NOT NULL	Withholding Allowances
8	SWT_EST_ALLOW	Number(3,0)	SMALLINT NOT NULL	Estimated Allowances
9	SWT_ADDL_ALLOWNCES	Number(3,0)	SMALLINT NOT NULL	Additional Allowances
10	SWT_ADDL_AMT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	SWT Additional Amount
11	SWT_EST_AMT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	SWT Estimated Amount
12	SWT_SP_EST_AMT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	SWT Special Exemption Amount
13	SWT_ADDL_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	SWT Additional Percentage
14	UI_JURISDICTION	Character(1)	VARCHAR2(1) NOT NULL	UI Jurisdiction Y/N Table Edit Default Value: N
15	RETIREMENT_PLAN	Character(50)	VARCHAR2(50) NOT NULL	Retirement Plan Y/N Table Edit Default Value: N