Related topics

About Sage HRMS Link

Using Templates

Exporting Data to ADP PC Exchange

Changing a Translation Table

You can add, edit, or delete a code from the translation tables.

  • For translation tables that correspond to a system provided code table (for example, Marital Status, I-9 Verification Status), you are modifying the translation tables for all employers.
  • For translation tables that correspond to a non-system provided code table (for example, Union Affiliation, Pay Frequency), you can modify the translation tables for either the enterprise or a specific employer.

  • System-provided tables are automatically filled in with pre-defined values. All other translation tables contain ADP codes that are equivalent to Sage HRMS codes. However, in some cases the content and length of the codes may not correspond to what is required in ADP. For example...

    You have a ten-character benefit insurance code in Sage HRMS, LTD PLAN 1. The equivalent ADP deduction code is 04. You must change the ADP code for this insurance plan in the translation table.

    If you do not change the code in the translation table:

    • When you export data to ADP PC Exchange, the ADP code automatically truncates to two characters and becomes LT.
    • Sage HRMS Link reports this as an error.

The following translation tables require special consideration as you set them up: Employee File Numbers, Employee ID Numbers, Benefit Codes, and Company Codes.

Adding, Modifying and Deleting Codes in Translation Tables

  1. From the menu, select Service Bureau > ADP Translation Tables.
  2. Select the table you want to work with and click OK. If you are working with multiple employers, the Employer Selection dialog box opens.
  3. Double-click Enterprise if you want to add codes for all employers. Otherwise, double-click the employer you are working with. The translation table opens.

    4. Tip: If you want to copy existing codes from another employer, click Copy and select the employer from which you want to copy codes.

  4. Click Add.
  5. Enter the Sage HRMS Code, ADP Code, or Description as appropriate.
  6. When you are finished, click OK to save your changes.
  1. From the menu, select Service Bureau > ADP Translation Tables.  
  2. Select the table you want to modify and click OK. If you are working with multiple employers, the Employer Selection dialog box opens.
  3. Double-click Enterprise if you want to modify codes for all employers. Otherwise, double-click the employer you are working with. The translation table opens.
  4. Click the More button in front of the code you want to modify.
  5. Modify the Sage HRMS Code, ADP Code, or Description as appropriate.
  6. When you’re finished, click the Next or Previous button if you want to modify another code. Otherwise, click OK to save your changes and return to the translation table page.
  1. From the menu, select Service Bureau > ADP Translation Tables.
  2. Double-click the appropriate table. If the Employer Selection dialog box opens, you will need to select either the enterprise or a single employer for which to delete codes.
  3. Highlight the code you want to delete and click Delete. Confirm the deletion.