ADP Integration

Owned by DATABASICS, Inc.
Last updated: Nov 25, 2020 by Torbjorn Nilsen
2 min read

DATABASICS Time & Expense Reporting system integrates to ADP Payroll to reimburse employee expense reports and payroll labor hours processing.

Pull Data from ADP

DATABASICS organization structure consists of the following:

  • Operating Unit, a Department, an Employee

  • Employee also has the following properties:

    • Employee ID

    • First Name

    • Mid Initial

    • Last Name

    • Employee Type (Such as Contractor, Full Time, Part Time , etc)

    • Hire Date

    • Termination Date

The following information is needed from ADP

  • Company Code (Located in "Edit Company" in ADP)

  • Batch ID (Located in "Edit Company" in ADP)

  • File # - Employee ID number in ADP and it is configured in the employee setup as other id in the employee setup.

  • Hours 3 Code - is the ADP code that corresponds to an exception pay type.

  • Earning 3 Code - is the ADP code that corresponds to a payroll account. You may be able to locate them under Company > Earnings and Deductions.

  • Deduction Code - this is a required field in the ADP reimbursement, DATABASICS can be configured to support customer logic.

We use ADP API get employee data to map it to DATABASICS employee.   All the above fields include the Operating Unit, Department, and Employee data integrated to ADP employee record.    The employee load gets scheduled in DATABASICS to refresh Employee data on weekly, daily, hourly and as needed bases.  The load will call ADP API to get latest employee data and refresh the data in DATABASICS for new records and existing records.

The loads will validate to make sure all the required fields are provided in order for the employee to be active in DATABASICS.

We might have customers with back end account systems where it will become the master record of the employee, and in that case, we will load ADP File Number and map it to the existing employee data that we are getting from backend account systems, such as Microsoft Dynamics, Intacct, NetSuite, etc.

Here are some references to help you in regards the earnings codes https://support.adp.com/adp_payroll/content/hybrid/%40runcomplete/doc/pdf/edqr.pdf

NOTE:  DATABAICS has the ability to rollback a posted batch as long as it is not processed in ADP yet.   You may need to contact support@data-basics.com or submit a ticket online to request a rollback to posted expense batch.

2021 DATABASICS, Inc