UPG_CONV_LCLTX(SQL Table) |
Index Back |
---|---|
Local Tax TableThis 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 |