Export Interface

The Export Interface Maintenance is where you define the information that establishes the connection to your external payroll system that the data will be pushed out to.
Note: Your Export Interface should be setup by your LightWork team during implementation.

  1. New
    To create a new 'Export Interface', click on the 'New' icon.

  2. General Tab

    1. ID
      Fill in the short name.

    2. Description
      Fill in the long name.

    3. Type
      Select the type of 'Export Interface' from the list provided in the drop-down menu.

    4. External System
      Select the external system you want your data to be exported to from the list provided in the drop-down menu.

    5. SQL Linked Server Prefix
      Input the 'SQL Linked Server Prefix'. The SQL Linked Server Prefix path must follow the pattern/syntax of the name of the database, the schema, up to and including the opening bracket that references the tables.
      Note: In our example [SageHRMS_Live] is the database name, .[dbo] is the schema, and the path ends with the opening bracket .[ which references the tables.

    6. Force Default Shift
      Enable this feature if you would like to force a default shift during the export process.

    7. Is Remote
      Enable this feature if the external system you are exporting to resides on a remote server. If your LightWork system’s integration scenario utilizes a LightWork Connector, it's best to avoid running a manual import (through navigation to Imports > HRMS > Step 1 and Step 2). If the 'Is Remote' flag is turned on in the Export Interface, this signals the presence of a LightWork Connector. In this case, do not run the manual import process.




  3. Mapping Tab
    Here you will map each Pay Code that is setup in LightWork.
    Note: Make sure to map all Pay Codes, even if they will not be transferred.

  4. Pay Code Mapping Tab

    1. Add
      To create a new Pay Code Mapping, click on the 'Add' button and then go through each tab appropriately.

      1. General

        1. Pay Code

        2. Hourly or Amount to Transfer

        3. Transfer Code

        4. Apply Shift Differential

        5. Separate Shift Differential from Reg Hours

        6. Combine Reg and Overtime into One Code

        7. Force Grouping By Work Date

      2. Map: Default

        1. Regular

        2. OT 1

        3. OT 2

        4. Payroll Code

        5. Enable

        6. Reason Code

        7. Rate Factor

        8. Shift Diff

      3. Map: Organization Level

        1. Organization Level
          Select the 'Organization Level'.'

        2. Add
          Click on the 'Add' button, then fill out the details.

  5. Apply
    Once you are satified with your selections, click on 'Apply'.

  6. Record Grouping Tab
    Select how the records will be grouped during the export process.

    1. Pay Code

    2. Job Code

    3. Organization Levels

    4. Date Grouping

  7. SQL Prefixes Tab

    1. Add
      To create a new SQL Prefix, click on the 'Add' button.

  8. Save
    Once you are satisfied with your selections, click on 'Save'.