LOCAL_TAX_VW (SQL View)	Index Back
Local Tax Table View This view is used to return localities for the state selected only if the country selected is USA.

LOCAL_TAX_VW

(SQL View)

Local Tax Table View

This view is used to return localities for the state selected only if the country selected is USA.

SELECT 'USA' ,STATE ,LOCALITY ,EFFDT ,EFF_STATUS ,LOCALITY_NAME ,COUNTY ,OTH_LOCALITY ,OTH_LOCALITY_NAME ,OTH_LOCALITY_ABBRV ,MAINT_RESPONSBLTY ,LOC_TAX_TYPE ,WITHHOLD_WRK_ONLY ,LOC_JURISDCTN ,PARTIAL_IND ,GRADUATED_TBL_CD ,RESIDENT_TAX_RT ,NONRESIDENT_TAX_RT ,LOW_GROSS ,MINIMUM_TAX ,MAXIMUM_TAX ,EXEMPTION_AMT ,TAX_CLASS FROM PS_LOCAL_TAX_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

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

3 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

4 EFFDT Date(10) DATE NOT NULL Effective Date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

6 LOCALITY_NAME Character(40) VARCHAR2(40) NOT NULL Locality Name

7 COUNTY Character(30) VARCHAR2(30) NOT NULL County

8 OTH_LOCALITY Character(10) VARCHAR2(10) NOT NULL School dist code (PA only)

9 OTH_LOCALITY_NAME Character(40) VARCHAR2(40) NOT NULL Other Locality Name

10 OTH_LOCALITY_ABBRV Character(16) VARCHAR2(16) NOT NULL Other Locality Short Name

11 MAINT_RESPONSBLTY Character(1) VARCHAR2(1) NOT NULL Maintenance Responsibility
C=Customer
P=PeopleSoft

12 LOC_TAX_TYPE Character(1) VARCHAR2(1) NOT NULL Local Tax Calculation Type
F=Rate x FLSA Hours Worked
G=Rate x Taxable Gross
M=Amount Per Month
P=Amount Per Pay Period
Q=Amount Per Quarter
S=Rate x State Withholding
T=Graduated Tax Tables
Y=Amount Per Year

13 WITHHOLD_WRK_ONLY Character(1) VARCHAR2(1) NOT NULL Withhold On Work Locality Only
Y/N Table Edit

14 LOC_JURISDCTN Character(1) VARCHAR2(1) NOT NULL Local Jurisdiction
C=Combined
D=School District
M=Municipality
O=Other
S=State
T=County

15 PARTIAL_IND Character(1) VARCHAR2(1) NOT NULL Partial Indicator (PA only)
Y/N Table Edit

16 GRADUATED_TBL_CD Character(2) VARCHAR2(2) NOT NULL Graduated Tax Table Code
Prompt Table: STATE_TBL_US_VW

17 RESIDENT_TAX_RT Number(12,6) DECIMAL(11,6) NOT NULL Resident Tax Rate

18 NONRESIDENT_TAX_RT Number(12,6) DECIMAL(11,6) NOT NULL Nonresident Tax Rate

19 LOW_GROSS Number(10,2) DECIMAL(9,2) NOT NULL Low Gross

20 MINIMUM_TAX Number(7,2) DECIMAL(6,2) NOT NULL Minimum Tax

21 MAXIMUM_TAX Number(8,2) DECIMAL(7,2) NOT NULL Maximum Tax

22 EXEMPTION_AMT Number(5,0) INTEGER NOT NULL Exemption Amount

23 TAX_CLASS Character(1) VARCHAR2(1) NOT NULL Tax Balance Class
A=Non-resident alien (1042)
B=Local - Employer and Employee
C=Earned Income Credit
D=OASDI/Disability - EE
E=OASDI/Disability - ER
F=FICA Med Hospital Ins / EE
G=OASDI/EE - tips
H=Withholding
J=OASDI/ER - tips
K=Excise
L=NJ Supl Workforce Admin Fund
M=New Jersey WDPF
N=New Jersey HCSF
P=Occupational Privilege Tax
Q=FICA Med Hospital Ins / ER
R=Local ER
S=Unemployment - Special
T=FICA Med Hospital Ins /EE-tips
U=Unemployment ER
V=Unemployment EE
W=Voluntary Disability Plan EE
X=Voluntary Disability Plan ER
Z=FICA Med Hospital Ins /ER-tips

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
2	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL_US_VW
3	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
6	LOCALITY_NAME	Character(40)	VARCHAR2(40) NOT NULL	Locality Name
7	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
8	OTH_LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	School dist code (PA only)
9	OTH_LOCALITY_NAME	Character(40)	VARCHAR2(40) NOT NULL	Other Locality Name
10	OTH_LOCALITY_ABBRV	Character(16)	VARCHAR2(16) NOT NULL	Other Locality Short Name
11	MAINT_RESPONSBLTY	Character(1)	VARCHAR2(1) NOT NULL	Maintenance Responsibility C=Customer P=PeopleSoft
12	LOC_TAX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Local Tax Calculation Type F=Rate x FLSA Hours Worked G=Rate x Taxable Gross M=Amount Per Month P=Amount Per Pay Period Q=Amount Per Quarter S=Rate x State Withholding T=Graduated Tax Tables Y=Amount Per Year
13	WITHHOLD_WRK_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Withhold On Work Locality Only Y/N Table Edit
14	LOC_JURISDCTN	Character(1)	VARCHAR2(1) NOT NULL	Local Jurisdiction C=Combined D=School District M=Municipality O=Other S=State T=County
15	PARTIAL_IND	Character(1)	VARCHAR2(1) NOT NULL	Partial Indicator (PA only) Y/N Table Edit
16	GRADUATED_TBL_CD	Character(2)	VARCHAR2(2) NOT NULL	Graduated Tax Table Code Prompt Table: STATE_TBL_US_VW
17	RESIDENT_TAX_RT	Number(12,6)	DECIMAL(11,6) NOT NULL	Resident Tax Rate
18	NONRESIDENT_TAX_RT	Number(12,6)	DECIMAL(11,6) NOT NULL	Nonresident Tax Rate
19	LOW_GROSS	Number(10,2)	DECIMAL(9,2) NOT NULL	Low Gross
20	MINIMUM_TAX	Number(7,2)	DECIMAL(6,2) NOT NULL	Minimum Tax
21	MAXIMUM_TAX	Number(8,2)	DECIMAL(7,2) NOT NULL	Maximum Tax
22	EXEMPTION_AMT	Number(5,0)	INTEGER NOT NULL	Exemption Amount
23	TAX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Tax Balance Class A=Non-resident alien (1042) B=Local - Employer and Employee C=Earned Income Credit D=OASDI/Disability - EE E=OASDI/Disability - ER F=FICA Med Hospital Ins / EE G=OASDI/EE - tips H=Withholding J=OASDI/ER - tips K=Excise L=NJ Supl Workforce Admin Fund M=New Jersey WDPF N=New Jersey HCSF P=Occupational Privilege Tax Q=FICA Med Hospital Ins / ER R=Local ER S=Unemployment - Special T=FICA Med Hospital Ins /EE-tips U=Unemployment ER V=Unemployment EE W=Voluntary Disability Plan EE X=Voluntary Disability Plan ER Z=FICA Med Hospital Ins /ER-tips