The following specifications were designed in cooperation
with and specifically for ADP.
This information will guide your ADP Representative when setting up your ADP
account for integration with SuccessWare21.
** NOTE:
The codes on your ADP account must be setup to match the coding
specifications below.
Please print and share this ADP Payroll Export File Spec
document with your ADP Representative.
1.
Columns
The SuccessWare21/ADP Payroll Export File is a ‘csv’ file. The file includes and is limited to the
following columns:
1.1.
Co Code len
3, alphanumeric
1.2.
Batch ID len
2, 1-99
1.3.
File # len
6, 51-999999
1.4.
Temp Dept len
3 or 6, Alphanumeric
1.5.
Temp Rate Min:
-405.0000, Max: 999.9999, Precision is 4
1.6.
Reg Earnings -40500.00-99999.99
1.7.
Reg Hours -40500.00-99999.99
1.8.
O/T Hours, -40500.00-99999.99
1.9.
Hours 3 Code len
1-2, Alphanumeric; A-Z, 0-79 (except 40, 50, 60, and 61), and blank
1.10.
Hours 3 Amount -40500.00-99999.99
1.11.
Hours 4 Code len
1-2, Alphanumeric; A-Z, 0-79 (except 40, 50, 60, and 61), and blank
1.12.
Hours 4 Amount -40500.00-99999.99
1.13.
Earnings 4 Code len
1-2, Alphanumeric; A-Z, 0-79 (except 40, 50, 60, and 61), and blank
1.14.
Earnings 4 Amount -40500.00-99999.99
2.
General
Comments
2.1.
Employees can be listed more than once (in multiple rows).
2.2.
Salary entries are exported and included
in the file.
2.3.
Commissions/Spiffs/Bonus will be included in the
export for all employees in the same manner.
2.3.1. Commissions will export as
Earning3Code “C”
2.3.2. Piecerate will export as
Earnings3Code “P”
3.
Export
Filename
3.1.
Format export filename as EPIcccAA.csv where
3.1.1. ‘ccc’ is the alphanumeric
company code supplied by ADP.
3.1.2. ‘AA’
4.
The last two
digits of the SuccessWare21 Period ID will be used for the AA portion of the
filename.
5.
This ensures a
unique number for each period during the same cycle and throughout most of the year
or more.
6.
This also allows
for quick relation of a file back to it a recent corresponding period in
SuccessWare21.
7.
The Period ID
starts at 1 in SuccessWare21 and increments by one each time a period is
created. Periods can be deleted. This means that gaps may exist between the
existing Period IDs.
8.
Wage
Types
Exporting different wage types
8.1.
Regular hourly wages will use RegHours and TempRate
8.2.
Salary wages will use RegEarnings.
8.3.
Overtime wages will use OTHours and TempRate
8.4.
Premium wages will use Hour3Code and Hours3Amount.
8.5.
Vacation, sick and personal wages will use the Hours4Code
and Hours4Amount.
8.6.
Commissions and piece rate will use the
Earnings4Code and Earnings4Amount
|
Column Title |
Spec |
Description |
||||||||||
|
Co Code |
len
3, alphanumeric |
This code is supplied to the
customer by ADP. It is configured in
SW21 Setup as a part of the ADP configuration. |
||||||||||
|
Batch ID |
len
2, 1-99 |
The Batch ID is used to identify secondary
files submissions for the same payroll period. If the Batch ID is the same, the additional
file will replace the original. With a
different Batch ID, the new file will be appended to the existing payroll
period. To compensate for the possibility
of SW21 users possibly having multiple payroll periods to submit during the
same week/cycle, this field can be set to a constant based on the period
type. SW21 users can only have two of
four periods. The Batch ID values will be as
follows:
|
||||||||||
|
File # |
len
6, 51-999999 |
This field will be completed using
the SW21.EmployeeNo field. ADP requires a numeric value be
entered as 51-999999. |
||||||||||
|
Temp
Dept |
len
6, alphanumeric |
SW21.GLAccount+SW21.Department
(example: “4002S1”) This requires that
SW21.Department codes be setup as two characters codes. |
||||||||||
|
Temp
Rate |
Min:
-405.0000, Max: 999.9999, Precision is 4 |
This is the actual rate paid
to the employee for regular or overtime hours. For O/T hours this will include the O/T
rate inflation. For commissions and piece
rate, leave blank. |
||||||||||
|
Reg
Earnings |
-40500.00-99999.99 |
This is the actual amount earned
for salary employees. For non-salary wages, leave blank. |
||||||||||
|
Reg
Hours |
-40500.00-99999.99 |
Regular hours for non-premium
hourly entries. |
|
OT Hours |
-40500.00-99999.99 |
O/T hours for premium ‘OT’ hourly
entries. Note: Premiums other than overtime
(holiday, doubletime) will use the Hours 3 Code and amount. |
||||||||||
|
Hours3Code |
len 1-2, alphanumeric A-Z, 0-79 (except 40, 50, 60, and 61), and blank |
Used for premium wages other that
O/T. The codes here will corresponds to
the appropriate premium multiplier.
Note: The Temp
Rate used with this field will contain the actual rate paid include the
premium inflation. |
||||||||||
|
Hours3Amount |
-40500.00-99999.99 |
Hours for premium non-OT hourly
entries. |
||||||||||
|
Hours4Code |
len 1-2, alphanumeric A-Z, 0-79 (except 40, 50, 60, and 61), and blank |
This code corresponds to Vacation,
Sick, or Personal time. When the SW21.PayType start with “Vacation”, “Sick”,
or “Personal”, the Hours3Code and Hours3Amount will be used. This field will have the
appropriate ADP standard code for vacation, sick or personal time as follows:
|
||||||||||
|
Hours4Amount |
-40500.00-99999.99 |
Hours for vacation, sick, or
personal time. |
||||||||||
|
Earning4Code |
len 1-2, alphanumeric A-Z, 0-79 (except 40, 50, 60, and 61), and blank |
For SW21.Misc wages; spiffs,
commissions, bonus, and piece rate;
|
||||||||||
|
Earming4Amount |
-40500.00-99999.99 |
Amount paid for commission
or piece rate wages. |