|
|
Import
|
Records
|
Record length
|
Table for code verification
|
Field verification
|
Populate
|
|
1
|
Empl #
|
1-6
|
6
|
EE
|
employee code (or number)
|
|
|
2
|
Name
|
7-31
|
25
|
EE
|
employee first name, employee last name.
-
This field is case-sensitive.
If the employee is keyed as Jane Doe, it must be in the import file as Jane Doe. Evolution won't match an employee in the
time clock import file with a name of JANE DOE with the Evolution employee name of Jane Doe.
|
|
|
3
|
Override Dept
|
32-37
|
6
|
EE Rates
|
Dept
|
Check line
|
|
4
|
job
|
38-49
|
12
|
Co Jobs
|
job description
|
Check line
|
|
5
|
Shift
|
50
|
1
|
|
|
|
|
6
|
D/E
|
51
|
1
|
Client E/Ds
|
E/D code
|
Check line
|
|
7
|
Earn Code
|
52-53
|
2
|
Client E/Ds
|
E/D code (combined with field 6).
|
Check line
|
|
8
|
Rate
|
54-62
|
9
|
|
|
Rate
|
|
9
|
Hours
|
63-70
|
8
|
|
|
Hours
|
|
10
|
Year
|
71-72
|
2
|
|
|
line_item_date
|
|
11
|
Month
|
73-74
|
2
|
|
|
line_item_date
|
|
12
|
Day
|
75-76
|
2
|
|
|
line_item_date
|
|
13
|
Hour
|
77-78
|
2
|
Not in use.
|
|
|
|
14
|
Minute
|
79-80
|
2
|
Not in use.
|
|
|
|
15
|
Amount
|
81-89
|
9
|
|
|
Amount
|
|
16
|
Seq Number
|
90
|
1
|
|
|
|
|
17
|
Override Division
|
91-96
|
6
|
EE rates
|
pay rate hourly amount
|
Check line
|
|
18
|
Override Branch
|
97-102
|
6
|
EE rates
|
pay rate hourly amount
|
Check line
|
|
19
|
Override State
|
103-104
|
2
|
EE states
|
state
|
Check line-
Check state
|
|
20
|
Override Local
|
105-114
|
10
|
EE locals
|
local
tax name
|
Check line-
Check state
|
|
21
|
Blank Fill
|
115-175
|
61
|
|
|
|
|
22
|
Deduction 3 hours
|
176-185
|
6
|
Not in use.
|
|
|
|
23
|
Deduction 3 amount
|
186-195
|
|
Not in use.
|
|
|
|
24
|
Override Team
|
196-201
|
6
|
|
team
|
|
|
25
|
SSN
|
202-210
|
9
|
|
Social Security number (SSN)
|
|
|
26
|
Workers' Compensation
|
211-216
|
6
|
|
workers' compensation code
You can attach the state and W/C when using the time clock import. When
matching WC codes, Evolution will look
to the full 6 characters used for workers compensation. In the time clock
import, rather than having just 8810, you can now select 8810VT and Vermont's
8810 code will be attached. If there is no state attached to a workers
compensation code, Evolution will
apply the first matching code.
|
|
|
27
|
Rate Number
|
217-220
|
4
|
EE_Rates
|
pay rate number
|
rate_number
|
|
28
|
Punch In
|
221-234
|
14
|
|
Yyyymmddhhnnss
yyyy = 4 digit year
mm =
2 digit month
dd =
2 digit day
hh =
2 digit hour (24 hours)
nn =
2 digit minutes
ss =
2 digit seconds
|
|
|
29
|
Punch Out
|
235-248
|
14
|
|
Yyyymmddhhnnss
yyyy = 4 digit year
mm =
2 digit month
dd =
2 digit day
hh =
2 digit hour (24 hours)
nn =
2 digit minutes
ss =
2 digit seconds
|
|
