The file format for the ADP Summary export is
as follows.
| Field Name |
Description |
Length |
Valid Values |
Requirements |
| Co Code |
Company
Code |
3 |
Alpha
Numeric |
(none) |
| Batch ID |
Batch
Identification |
25 |
Alpha
Numeric |
(none) |
| File # |
File
Number |
6 |
Numeric |
(none) |
| First Name |
First
name of employee |
30 |
Alpha
Numeric |
(none) |
| Last Name |
Last
name of employee |
40 |
Alpha
Numeric |
(none) |
| Home Dept |
Department
to which the employee is assigned |
6 |
Alpha
Numeric |
(none) |
| Home Job Cost# |
Job
cost number to which employee is assigned |
15 |
Alpha
Numeric |
(none) |
| Rate 1 |
Employee's
primary rate |
9,
4 |
99,999.9999
- max value |
(none) |
| Rate 2 |
Employee's
secondary rate |
7,
4 |
99,999.9999
- max value |
(none) |
| Rate 3 |
Employee's
tertiary rate |
7,
4 |
99,999.9999
- max value |
(none) |
| SSN |
Employee's
Social Security Number |
9 |
Alpha
Numeric |
(none) |
| Reg Hours |
Regular
Hours |
(N/A) |
Min:
40500.00 - Max: 99999.99 |
(none) |
| Reg Earnings |
Regular
Earnings |
(N/A) |
Min:
9999999.99 - Max: 9999999.99 |
(none) |
| O/T Hours |
Overtime
Hours |
(N/A) |
Min:
40500.00 - Max: 99999.99 |
(none) |
| Pay # |
Pay
Number |
1 |
1
- 9, N, X |
If
a Pay Number is not entered, a Pay Number
of 1 is assumed. |
| Job Cost # |
Job
Cost Number |
1
- 15 |
A
- Z, 0 - 9, &, - |
(none) |
| Tax Frequency |
Tax
Frequency |
1 |
0
- 9, S, M, D, T, B, F, H |
(none) |
| Temp Dept |
Temporary
Department Number |
3
or 6 |
A
- Z, 0 - 9, $, /, -, . (period) |
(none) |
| Temp Rate |
Temporary
Rate Amount |
(N/A) |
Min:
40500.00 -
Max: 99999.99 |
(none) |
| O/T Earnings |
Overtime
Earnings |
(N/A) |
Min:
9999999.99 - Max: 9999999.99 |
(none) |
| Other Hours Code |
Hours
code used to distinguish specific type
of other hours |
1
- 2 |
A
- Z, 0 - 79 (except 40, 50, 60, and 61) |
An
Other Hours Code must be followed immediately
by an Other Earnings Amount |
| Other Earnings Code |
Earnings
Code used |
1
- 2 |
A
- Z, 0 - 79 (except 40, 50, 60, and 61) |
An
Other Earnings Code must be followed immediately
by an Other Earnings Amount |
| Adjust Ded Code |
Deduction
code to use when making a one-time adjustment
to a deduction amount |
1
- 2 |
A
- Z, 0 - 79 (except 40, 50, 60, and 61) |
An
Adjust Ded Code must be followed immediately
by an Adjust Ded Amount |
| Rate Code |
Temporary
Rate Code |
1 |
A-Z,
1-9 |
(none) |
| Other Hours Amount |
Number
of other hours specific to other earning
code |
(N/A) |
Min:
-9999999.99
Max: 9999999.99 |
An
Other Hours Amount must be preceded by
an Other Hours Code |
| Other Earnings Amount |
Amount
of other earnings specific to other earning
code |
(N/A) |
Min:
-9999999.99
Max: 9999999.99 |
An
Other Earnings Amount must be preceded
by an Other Earnings Code |
| Adjust Ded Amount |
Adjust
the scheduled or one-time deduction by
adding or subtracting this amount |
(N/A) |
Min:
-9999999.99
Max: 9999999.99 |
An
Adjust Ded Amount must be preceded by
an Adjust Ded Code |
| Shift Code |
Shift
Code |
1 |
2
- 9 |
(none) |
| Work State |
Used
only in Multi-Jurisdiction payroll processing |
2 |
Alpha
Numeric- Valid State code |
(none) |
| Work City |
Used
only in Multi-Jurisdiction payroll processing |
4 |
Alpha
Numeric- Valid City code |
(none) |
| Memo Code |
This
is a paired field that exists when the
Memo Amount exists and vice versa |
1 |
A-Z,
0-9 |
A
Memo Code must be followed immediately
by a Memo Amount |
| Memo Amount |
See
Memo Code |
9,
2 |
Min:
-9999999.99
Max: 9999999.99 |
A
Memo Amount must be preceded by a Memo
Code |
