STATE_TAX_DATA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: PY_STATETAX_VW
5	RESIDENT	Character(1)	VARCHAR2(1) NOT NULL	Resident Y/N Table Edit Default Value: Y
6	NON_RES_DECLARED	Character(1)	VARCHAR2(1) NOT NULL	Non-Residency Statement Filed Y/N Table Edit Default Value: N
7	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
8	SWT_MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	SWT Marital/Tax Status Prompt Table: SWT_TAX_ST_VW
9	SWT_ALLOWANCES	Number(3,0)	SMALLINT NOT NULL	Withholding Allowances
10	SWT_ADDL_ALLOWNCES	Number(3,0)	SMALLINT NOT NULL	Additional Allowances
11	WAGE_PLAN_CD	Character(1)	VARCHAR2(1) NOT NULL	Wage Plan Code A=DI Exempt/UI State J=DI State/UI Exempt L=DI Voluntary/UI Exempt P=DI Exempt/UI Exempt R=DI Special Exempt/UI State S=DI State/UI State U=DI Voluntary/UI State Default Value: S
12	ANNL_EXEMPTION_AMT	Number(8,0)	INTEGER NOT NULL	MS Annual Exemption Amount
13	PERCENT_OF_FWT	Number(6,3)	DECIMAL(5,3) NOT NULL	AZ Withholding Percent
14	SWT_ADDL_AMT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	SWT Additional Amount
15	SWT_ADDL_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	SWT Additional Percentage
16	SDI_STATUS	Character(1)	VARCHAR2(1) NOT NULL	State Disability Insurance Status E=Exempt N=Not Applicable V=Voluntary Disability Plan Y=Subject
17	SUT_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Exempt From SUT Y/N Table Edit Default Value: COMPANY_TBL.SUT_EXEMPT
18	UI_JURISDICTION	Character(1)	VARCHAR2(1) NOT NULL	UI Jurisdiction Y/N Table Edit Default Value: N
19	ADDL_AMT_ADJ	Character(1)	VARCHAR2(1) NOT NULL	Additional Amount Adjustment D=Decrease Additional Amount I=Increase Additional Amount Default Value: I
20	WT4A_FILED	Character(1)	VARCHAR2(1) NOT NULL	Designates that Form WT-4A has been filed to allow the addiitonal amount to be used as a standing Flat Tax Amount. As such, Reciprocity rules are enforced. Y/N Table Edit
21	LOCK_IN_RECVD	Character(1)	VARCHAR2(1) NOT NULL	Lock-In Letter Received Y/N Table Edit Default Value: N
22	LOCK_IN_LIMIT	Number(3,0)	SMALLINT NOT NULL	Limit On Allowances
23	RETIREMENT_PLAN	Character(1)	VARCHAR2(1) NOT NULL	PR Retirement Plan Y/N Table Edit Default Value: N
24	EIC_STATUS_ST	Character(1)	VARCHAR2(1) NOT NULL	Earned Income Credit Y/N Table Edit Default Value: N
25	HLTH_COV_IND	Character(1)	VARCHAR2(1) NOT NULL	VT Health Coverage Indicator A=Eligible/Accepted B=Eligible/Not Accepted/Covered C=Eligible/Not Accepted/No Cover D=Not Eligible N=Not Applicable S=Seasonal Default Value: N
26	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %DATE
27	PNA_FLI_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FLI Status E=Exempt N=Not Applicable V=Voluntary Plan Y=Subject Default Value: N
28	RES_ADDL_ALLOW	Number(3,0)	SMALLINT NOT NULL	Number of Qualifying Children
29	PY_TRANSIT_TAX	Character(1)	VARCHAR2(1) NOT NULL	Checkbox field to indicate whether Oregon Transit Tax should be withheld or not. Y/N Table Edit Default Value: N
30	PNA_MLI_STATUS	Character(1)	VARCHAR2(1) NOT NULL	MLI Status E=Exempt N=Not Applicable V=Voluntary Plan Y=Subject Default Value: N
31	PY_FML_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FMLI Status E=Exempt N=Not Applicable V=Voluntary Plan Y=Subject Default Value: N
32	PY_LTC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	LTC Status E=Exempt N=Not Applicable Y=Subject Default Value: N
33	PY_SWT_FORM_RECVD	Character(1)	VARCHAR2(1) NOT NULL	State form received. B=Received - Line 2 Blank N=Form Not Received Y=Received - Line 2 Not Blank Default Value: N