...
Pay Code Mapping to EDP Earnings / Deduction Code
Most often Expense Reimbursement is one Earnings Code in ADP . However, ADP Earnings or Deduction Codes can be mapped to either Expense Type Pay Code Group or Expense Type Pay Code in DATABASICS.
For example if the Earning Code is “Travel” in ADP then we will configure DATABASICS Expense Type Group as Travel and then we will add all the expense types such as Airfare, Car Rental, Train, Lodging, etc. to the Travel and then when we post payment to ADP payroll we will the total sum of all expenses for Travel Earning code. Restrictions and validations needed can take place to endure the data is 100% validated before it gets posted to ADP. DATABASICS Services Team will work to configure DATABASICS based on the customer requirements.
...
Here are some examples of ADP Pay Code Mapping to AD Number and ADP Hours 3 code.
Pay Code | Pay Code Group | Name | ADP Number | ADP Hour 3 code |
AT | AT | Administrative Leave | D | D |
FMLA | FMLA | Family Medical Leave Act | L | L |
PT | PERSONALTIME | Personal Time Off | V | V |
ST | ST | Standard |
Post Approved Timesheets to ADP
DATABASICS will configure a profile to post all approved expenses timesheets in the following format:
· CSV - For Manually Quick Entry
...
The Post to ADP profile configured in DATABASICS with query to retrieve only approved expense report and reimbursable amount is greater than zerotimesheets. These queries are fully configurable by the customer depending on the requirements.
...
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 Expense 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.
...