Payroll Integration with ADP

37 Pages·2017·0.66 MB·English

by  Mark Argent

—
Payroll Integration with ADP (CSV Based)
Functional Overview
Ellipse EAM® 8.9
© Copyright 2017 ABB
All Rights Reserved
Confidential and Proprietary

Legal Disclaimer
The product described in this documentation may be connected to, and/or communicate information and
data via, a network interface, which should be connected to a secure network. It is your sole responsibility to
ensure a secure connection to the network and to establish and maintain appropriate measures (such as but
not limited to the installation of firewalls, application of authentication measures, encryption of data,
installation of antivirus programs, etc.) to protect the product, the network, your systems, and the interface
against any kind of security breach, unauthorised access, interference, intrusion, leakage, damage, or
corruption or theft of data. We are not liable for damages or losses related to any such security breach,

unauthorised access, interference, intrusion, leakage, damage, or corruption or theft of data.
Contents

Contents
Definitions, Acronyms and Abbreviations .............................................................................................. 4
Introduction .................................................................................................................................................. 6
Purpose .......................................................................................................................................................... 6
Business Benefits ......................................................................................................................................... 7
Functional Enhancements .......................................................................................................................... 8
New Components ........................................................................................................................................ 8
Payroll Master Data File Adapter (ADP) .......................................................................................... 8
Payroll Transaction Data File Adapter (ADP) ................................................................................ 11
Payroll Pay Advice Adapter (ADP) .................................................................................................... 17
Modifications to Existing Components ............................................................................................... 20
Payroll Master Data Adapter ........................................................................................................... 20
Payroll Transaction Data Adapter .................................................................................................. 22
Payroll History Service ...................................................................................................................... 23
Employee Core Taxation Service .................................................................................................... 25
Payroll Advice Adapter ...................................................................................................................... 25
Payroll Calculate ................................................................................................................................. 25
Obsolete Components ............................................................................................................................. 26
How to Configure ...................................................................................................................................... 27
Modules ....................................................................................................................................................... 27
Configuration ............................................................................................................................................. 27
Functional Overview ................................................................................................................................. 36
FAQs ............................................................................................................................................................. 37

3
Payroll Integration with ADP (CSV Based)

Definitions, Acronyms and Abbreviations
Definition Description
Global Payroll Adaptor A generic payroll integration solution using the Ellipse Integration
Platform (EIP).
MSE81S Ellipse program for the Personnel Workbench. An employee self-
service application and also used by HR users.
MSO808 Ellipse program used for creating and maintaining pay group
information
MSO820 Ellipse program used for assigning people to a pay group.
Payroll Type The Payroll Type of ‘Rostered’ enables a person to be added to a
roster and use leave functionality to reduce availability hours
= Rostered
without the need for timesheets or payroll.
Payroll Type The Payroll Type of ‘Timekeeping’ equates to the Unvalued
Timekeeping Transaction model used by the Global Payroll Adaptor
= Timekeeping
solution.
Payroll Type The Payroll Type of ‘Gross’ equates to the Valued Transaction
model used in the Global Payroll Adaptor solution.
= Gross
Payroll Type Time and attendance and payroll functionality being performed
within Ellipse.
= Full Payroll
Available for Australian payroll.
Payroll Type A person not using Ellipse for rostering, timekeeping, award
interpretation or payroll and therefore not requiring availability
= No Payroll
information for work scheduling purposes.
Person For the purposes of this document, a generic term for an individual.
The person may be an employee, contractor, volunteer and so on.
EIP Ellipse Integration Platform.
OAGIS Open Applications Group Integration Specification. OAGIS is the
common content model used to represent messages between
applications.
4
Payroll Integration with ADP (CSV Based)

Definition Description
HR-XML HR Interoperability standards provided by HR Open Standards,
provides an open data exchange standard for HR applications.
CSV Comma Separated Values. CSV is a common data
exchange format supported by many commercial applications.
ADP Provider of outsourced Human Capital Management (HCM)
solutions encompassing HR, payroll, talent, time, tax and benefits
administration.

5
Payroll Integration with ADP (CSV Based)

Introduction
Purpose
The purpose of this functional overview is to describe the ability to integrate with ADP Payroll in
the USA using the Ellipse Payroll Adapters in Ellipse 8.9.3 and above.
Business processing will occur in Ellipse in relation to:
 Maintenance of employee reference data (including, but not limited to: biographical
information, positions, rates of pay, fixed allowances, deductions, banking details and
taxation information).
 Preparation of payroll transactional data.
 Updating of current period information onto the pay advice history tables based upon
results from the ADP payroll update.
 Processing of payroll costing and deductions to accounts payable using information on
the pay advice history tables.
Both the employee reference and transactional data will be exported in CSV format so that the
files can be imported by the ADP Payroll system for payroll calculation processing to occur.
Upon completion of Payroll processing in the ADP Payroll system the payroll results file will be
utilised by Ellipse in order to update the pay advice history tables.
The integration, both outbound from Ellipse to ADP and inbound from ADP to Ellipse utilises
CSV import/export files in the ADP prescribed format.
This overview document describes the points of integration, the mapping of Ellipse elements to
the ADP CSV files and the processing flow for payroll when using this method for integration.
Employe
Payroll
e
Master
Personn
Payroll Payroll
Ellipse Transacti
EIP ADP
8.9.3
Pay Payroll
Advice Results

6
Payroll Integration with ADP (CSV Based)

Business Benefits
The Ellipse ADP payroll adapters provide a standard supported method for integrating Ellipse
with ADP payroll in the USA utilising the Global Payroll Adapter. These enhancement provide the
ability to integrate with ADP Payroll by sending either basic employee information or employee
information including deductions, banking and taxation details along with valued or unvalued
payroll transactions to ADP, and subsequently receiving payroll results from ADP which will
update the current period information on the Ellipse pay advice history tables.
The key benefits of this enhancement are:
1. Customers can leverage the benefits of Ellipse’s asset intensive industry focused
solution for rostering, timekeeping, award interpretation and integrate with the ADP
payroll solution as required.
2. Payroll history transactions for the payroll types of Full Payroll, Gross and Timekeeping
are stored in a consistent manner and can be accessed via the same services and
adaptors. This achieves a simplified integration and reporting model.
3. History of payroll details with point in time review of any historical pay run. The online
application details basic information for each pay process for an employee as it was
when originally generated.
4. Single point of entry regardless of where the actual payroll calculations and
disbursements occur. The following type of process flow is supported:
a. Personnel details are changed within Ellipse. The changes trigger the extraction
of the personnel data for use by the ADP payroll solution.
b. Time, Leave and Labour transactions are entered within Ellipse.
c. Payroll process values transactions (if required) and triggers extraction of
payroll data for use by the ADP payroll solution.
d. Employee personnel and transactional data is loaded into the ADP payroll
solution using ADP supplied utilities.
e. Remaining steps of payroll calculation and disbursement performed in the ADP
payroll solution.
f. Payroll results generated in ADP for use by Ellipse.
g. Payroll results loaded into Ellipse using supplied adapter, the results are used by
Ellipse to populate pay advice history tables.

7
Payroll Integration with ADP (CSV Based)

Functional Enhancements
New Components
The following new components have been implemented as a result of this development item:
Payroll Master Data File Adapter (ADP)
Overview
The Payroll Master Data File Adapter is used to process employee reference data contained
within the Payroll Master Data message that is generated by the Payroll Master Data Adapter
when any employee type changes are applied within Ellipse. The employee information
contained within the message is used to create entries on an output file in the ADP prescribed
CSV format. This ADP formatted CSV file can then be used to update employee information
within the ADP payroll application.
This interface assumes the creation and management of employee personnel and payroll
reference data will be managed within Ellipse with any changes sent to ADP.
The mapping of Ellipse attributes to the individual ADP data elements in the CSV file when not
sending banking, deductions and taxation entities is as follows:
ADP CSV File Attribute Ellipse Attribute and Mapping
"Co Code" Pay Group
"File #" Employee Id
(ADP supports 6 character employee id fields, if Ellipse
Employee Id is alpha it will be the first six chars, if numeric it
will be the last 6 chars)
“Change Effective On” Period End Date for Pay Group that the employee is assigned
to
“Employee Status” Employee Status
If Employee Status within Ellipse is 'A', the employee status in
the interface file will be set to 'A'
If Employee Status within Ellipse is 'I', the employee status in
the interface file will be set to 'L'
If Employee Status within Ellipse is 'X'
and the Employee Death Date is not zero, the employee
status in the interface file will be set to 'D'
If Employee Status within Ellipse is 'X'
and the Employee Term Date is not zero and the Employee
Death Date is zero, the employee status in the interface file
will be set to 'T'
“Gender” Gender Code
If Gender Code within Ellipse is ‘U’, the gender in the interface
will be set to ‘N’
8
Payroll Integration with ADP (CSV Based)

ADP CSV File Attribute Ellipse Attribute and Mapping
“Actual Number of Actual Number of Dependants
Dependents”
“'Data Control Position 1” Union Code
“Data Control Position 2” Employee Type
“'Data Control Position 3” Employee Type
“Data Control Position 4” Personnel User Defined Field 3 (code)
“Rehire Status” Rehire Code
“Hire Date” Hire Date
“Normal Retirement Date” Retirement Date
“Birth Date” Birth Date
“Leave of Absence Start Suspend Date
Date”
“Clock” Personnel User Defined Field 4 (code)
“Home Department” Position Classification 8 (code)
“Pay Frequency Code” Pay Group Pay Frequency
“Employee Last Name” Surname
“Social Security Number” Social Security Number
“Employee First Name” First Name
“Preferred Name” Preferred Name
“Address Line 1” Residential Address 1
“Address Line 2” Residential Address 2
“City” Residential Address 3 (Suburb/City)
“State Postal Code” Residential State Code
“Zip Code” Residential Zip Code
“Termination Date” Termination Date
“Termination Reason” Termination Reason
“Rate Type” Employee Rate Type
9
Payroll Integration with ADP (CSV Based)

ADP CSV File Attribute Ellipse Attribute and Mapping
“Rate 1 Amount” Employee Rate
“Increase Type” Employee Rate Change Reason
“Rehire Date” Rehire Date

Processing
The Payroll Master Data File Adapter (ADP) has been developed to operate within an end-to-end
integration solution with the ADP payroll system. The expected process is as follows:
 Employee Payroll Master Data information is maintained in an ad hoc manner in Ellipse.
Where changes to the data are made in Ellipse, this information will be published from
Ellipse and stored/aggregated in an EIP queue until required to be sent to ADP.
 When the data is required to be sent to ADP (as defined by a schedule), the data will be
extracted from the EIP queue and a CSV file in the ADP prescribed format will be generated,
ready to be sent to ADP in order to synchronise employee information.

Please refer to the Ellipse technical documentation for additional information.

10