STTAX_RECIP_TBL (SQL Table)	Index Back
State Reciprocity Rules This record defines the rules used during payroll calculation to determine withholding liability when an employee lives in one state and works in another. This is a PeopleSoft-maintained table.

STTAX_RECIP_TBL

(SQL Table)

State Reciprocity Rules

This record defines the rules used during payroll calculation to determine withholding liability when an employee lives in one state and works in another. This is a PeopleSoft-maintained table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STATE_RESIDENCE Character(6) VARCHAR2(6) NOT NULL State of Residence
Prompt Table: STATE_TAX_TBL

2 STATE_WORK Character(6) VARCHAR2(6) NOT NULL State of Employment
Prompt Table: STATE_TAX_TBL

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 RECIPROCITY_RULE Character(1) VARCHAR2(1) NOT NULL Reciprocity Rule
B=Withhold-Both
C=Withhold higher of work or res
G=Calc Res W/H; Factor Res W/H %
K=Calc Wk W/H; Reduce by Res W/H
N=Reduce Ttl Wages;Calc Res W/H
O=Withhold for wk locality only
P=Red Ttl Wgs;Calc Res W
R=Calc Res W/H;Reduce by Wk W/H
S=Special- MD works in DE
W=Taxed Res; No W/H Wk
X=Red Res W/H by Wk subj to Res
Y=No W/H Wk - Addl Reporting
Default Value: B

6 SUT_CREDIT Character(1) VARCHAR2(1) NOT NULL SUT Credit
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STATE_RESIDENCE	Character(6)	VARCHAR2(6) NOT NULL	State of Residence Prompt Table: STATE_TAX_TBL
2	STATE_WORK	Character(6)	VARCHAR2(6) NOT NULL	State of Employment Prompt Table: STATE_TAX_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	RECIPROCITY_RULE	Character(1)	VARCHAR2(1) NOT NULL	Reciprocity Rule B=Withhold-Both C=Withhold higher of work or res G=Calc Res W/H; Factor Res W/H % K=Calc Wk W/H; Reduce by Res W/H N=Reduce Ttl Wages;Calc Res W/H O=Withhold for wk locality only P=Red Ttl Wgs;Calc Res W R=Calc Res W/H;Reduce by Wk W/H S=Special- MD works in DE W=Taxed Res; No W/H Wk X=Red Res W/H by Wk subj to Res Y=No W/H Wk - Addl Reporting Default Value: B
6	SUT_CREDIT	Character(1)	VARCHAR2(1) NOT NULL	SUT Credit Y/N Table Edit Default Value: Y