EX_CUR_LOCALITY

(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. The most current effective dated data is selected.

SELECT 'USA' ,A.STATE ,A.LOCALITY ,A.EFFDT ,A.EFF_STATUS ,A.LOCALITY_NAME ,A.COUNTY ,A.OTH_LOCALITY ,A.OTH_LOCALITY_NAME ,A.OTH_LOCALITY_ABBRV ,A.MAINT_RESPONSBLTY ,A.LOC_TAX_TYPE ,A.WITHHOLD_WRK_ONLY ,A.LOC_JURISDCTN ,A.PARTIAL_IND ,A.GRADUATED_TBL_CD ,A.RESIDENT_TAX_RT ,A.NONRESIDENT_TAX_RT ,A.LOW_GROSS ,A.MINIMUM_TAX ,A.MAXIMUM_TAX ,A.EXEMPTION_AMT ,A.TAX_CLASS FROM PS_LOCAL_TAX_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_LOCAL_TAX_TBL B WHERE B.STATE = A.STATE AND B.LOCALITY = A.LOCALITY AND B.EFFDT <= %CurrentDateIn)

# 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