UPG_CONV_LCLTX

(SQL Table)
Index Back

Local Tax Table

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

Prompt Table: STATE_TAX_TBL

2 LOCALITY1 Character(10) VARCHAR2(10) NOT NULL Locality
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 LOCALITY_NAME1 Character(40) VARCHAR2(40) NOT NULL Locality Name
6 COUNTY Character(30) VARCHAR2(30) NOT NULL County
7 OTH_LOCALITY Character(10) VARCHAR2(10) NOT NULL School District Code (LST)
8 OTH_LOCALITY_NAME Character(40) VARCHAR2(40) NOT NULL Other Locality Name
9 OTH_LOCALITY_ABBRV Character(16) VARCHAR2(16) NOT NULL Tax Collection District Code
10 MAINT_RESPONSBLTY Character(1) VARCHAR2(1) NOT NULL Maintenance Responsibility
C=Customer
P=PeopleSoft

Default Value: C

11 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

Default Value: G

12 WITHHOLD_WRK_ONLY Character(1) VARCHAR2(1) NOT NULL Withhold On Work Locality Only

Y/N Table Edit

Default Value: N

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

Default Value: M

14 PARTIAL_IND Character(1) VARCHAR2(1) NOT NULL Partial Indicator (LST)

Y/N Table Edit

Default Value: N

15 GRADUATED_TBL_CD Character(2) VARCHAR2(2) NOT NULL Graduated Tax Table Code

Prompt Table: STATE_TAX_TBL

16 RESIDENT_TAX_RT Number(16,10) DECIMAL(15,10) NOT NULL Resident Tax Rate
17 NONRESIDENT_TAX_RT Number(16,10) DECIMAL(15,10) NOT NULL Nonresident Tax Rate
18 LOW_GROSS Number(12,2) DECIMAL(11,2) NOT NULL Low Gross
19 MINIMUM_TAX Number(7,2) DECIMAL(6,2) NOT NULL Minimum Tax
20 MAXIMUM_TAX Number(8,2) DECIMAL(7,2) NOT NULL Maximum Tax
21 EXEMPTION_AMT Number(9,0) DECIMAL(9) NOT NULL Exemption Amount
22 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class