LOCAL_TAX_TBL2 (SQL Table)	Index Back
Local Tax Table 2 This record is used to store descriptive information about a locality, the method used to calculate withholding taxes, local tax rates, and other data required for tax computation.

LOCAL_TAX_TBL2

(SQL Table)

Local Tax Table 2

This record is used to store descriptive information about a locality, the method used to calculate withholding taxes, local tax rates, and other data required for tax computation.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STATE Character(6) VARCHAR2(6) NOT NULL State
Default Value: LOCAL_TAX_TBL.STATE
Prompt Table: STATE_TAX_TBL

2 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
Default Value: LOCAL_TAX_TBL.LOCALITY

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: LOCAL_TAX_TBL.EFFDT

4 LOCALITY_ABBRV Character(16) VARCHAR2(16) NOT NULL Locality Short Name

5 TAX_RPT_INTERVAL Character(1) VARCHAR2(1) NOT NULL Tax Reporting
A=Annual
M=Monthly
Q=Quarterly
Default Value: Q

6 EE_DTL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Employee Detail Required
Y/N Table Edit
Default Value: N

7 W2_MAG_CODE Character(5) VARCHAR2(5) NOT NULL W2 Magnetic Media Code

8 W2_PRT_NAME Character(10) VARCHAR2(10) NOT NULL W2 Print Name

9 W2_RPTG_AGENCY Character(5) VARCHAR2(5) NOT NULL W2 Reporting Agency

10 W2_MAG_MEDIA_NAME Character(75) VARCHAR2(75) NOT NULL Field used for selected W2_Rotg_Agencies for W-2 Reporting.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Default Value: LOCAL_TAX_TBL.STATE Prompt Table: STATE_TAX_TBL
2	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Default Value: LOCAL_TAX_TBL.LOCALITY
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: LOCAL_TAX_TBL.EFFDT
4	LOCALITY_ABBRV	Character(16)	VARCHAR2(16) NOT NULL	Locality Short Name
5	TAX_RPT_INTERVAL	Character(1)	VARCHAR2(1) NOT NULL	Tax Reporting A=Annual M=Monthly Q=Quarterly Default Value: Q
6	EE_DTL_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Employee Detail Required Y/N Table Edit Default Value: N
7	W2_MAG_CODE	Character(5)	VARCHAR2(5) NOT NULL	W2 Magnetic Media Code
8	W2_PRT_NAME	Character(10)	VARCHAR2(10) NOT NULL	W2 Print Name
9	W2_RPTG_AGENCY	Character(5)	VARCHAR2(5) NOT NULL	W2 Reporting Agency
10	W2_MAG_MEDIA_NAME	Character(75)	VARCHAR2(75) NOT NULL	Field used for selected W2_Rotg_Agencies for W-2 Reporting.