| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL_US_VW
|
| 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 dist code (PA only)
|
| 8 |
OTH_LOCALITY_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Other Locality Name
|
| 9 |
OTH_LOCALITY_ABBRV |
Character(16) |
VARCHAR2(16) NOT NULL |
Other Locality Short Name
|
| 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 (PA only)
Y/N Table Edit
Default Value: N
|
| 15 |
GRADUATED_TBL_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Graduated Tax Table Code
Prompt Table:
STATE_TBL_US_VW
|
| 16 |
RESIDENT_TAX_RT |
Number(12,6) |
DECIMAL(11,6) NOT NULL |
Resident Tax Rate
|
| 17 |
NONRESIDENT_TAX_RT |
Number(12,6) |
DECIMAL(11,6) NOT NULL |
Nonresident Tax Rate
|
| 18 |
LOW_GROSS |
Number(10,2) |
DECIMAL(9,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(5,0) |
INTEGER NOT NULL |
Exemption Amount
|
| 22 |
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
|
| 23 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 24 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|