| # |
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 |
LOCALITY |
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_NAME |
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
Prompt Table:
PY_TAX_CLASS
|