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

LOCTX_RECIP_TBL

(SQL Table)

Local Tax Reciprocity Rules

This record defines the rules used during payroll calculation to determine withholding liability when an employee lives in one locality 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 LOCALITY_RESIDENCE Character(10) VARCHAR2(10) NOT NULL Locality of Residence
Default Value: $DFLT
Prompt Table: LOCAL_TAX_RESVW

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

4 LOCALITY_WORK Character(10) VARCHAR2(10) NOT NULL Locality of Employment
Default Value: $DFLT
Prompt Table: LOCAL_TAX_WRKVW

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

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

7 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
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
Default Value: B

8 REDUCE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Reduce by x Percent

9 CREDIT_LIM_RT Signed Number(8,6) DECIMAL(6,6) NOT NULL Credit Limit Rate

#	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	LOCALITY_RESIDENCE	Character(10)	VARCHAR2(10) NOT NULL	Locality of Residence Default Value: $DFLT Prompt Table: LOCAL_TAX_RESVW
3	STATE_WORK	Character(6)	VARCHAR2(6) NOT NULL	State of Employment Prompt Table: STATE_TAX_TBL
4	LOCALITY_WORK	Character(10)	VARCHAR2(10) NOT NULL	Locality of Employment Default Value: $DFLT Prompt Table: LOCAL_TAX_WRKVW
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
7	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 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 Default Value: B
8	REDUCE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Reduce by x Percent
9	CREDIT_LIM_RT	Signed Number(8,6)	DECIMAL(6,6) NOT NULL	Credit Limit Rate