ADP Time Integration

DATABASICS Time to ADP Payroll to labor payroll processing.

Pay Code Mapping to EDP Earnings / Deduction Code

ADP Earnings or Deduction Codes can be mapped to either Pay Code Group or Pay Code in DATABASICS.  Here are some examples of ADP Pay Code Mapping to AD Number and ADP Hours 3 code.

The ADP file contains the following:

DATABASICS team create a custom CSV file to export into ADP. The following fields are necessary in order to upload the custom CSV file into 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.

• Earning 3 Code (Located in "Edit Profile Center Group" page)

• Earning 3 Amount (Located in "Edit Profit Center Group" page)

Post Approved Timesheets to ADP

DATABASICS will configure a profile to post all approved timesheets in the following format:

·         CSV  -  For Manually Quick Entry

·        

The Post to ADP profile configured in DATABASICS with query to retrieve only approved timesheets.  These queries are fully configurable by the customer depending on the requirements.

Posting to ADP

Manual Process

1. Make sure DATABASICS Post Profile is configured as CSV output.

2. You could schedule the extract or run it as needed.  To run the extract go to Admin --> Data Piping → All Profile Task --> click on Run Now for Timesheet Post to ADP profile.

3. Once it runs it will take you to Job Instances to view the status and once it completed you will be able to download the file CSV file.

4. Once you download the CSV file process in ADP by uploading the fiel

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.