The Export Configurations Tab

Dayforce Implementation Guide

Version
R2025.1.1
The Export Configurations Tab

In the Export Configurations tab, you can specify the XML and XSLT pay export definitions for pay groups, with the option to create four different definitions for each type of pay export that users with access can perform from the Pay Admin Checklist.

Defining the pay export definition requires knowledge of XML and the Dayforce Payroll Export Interface Specification, which defines what tokens can be included in the definition and what data Dayforce can export.

You can create more than one export definition for a pay group. When pay is transmitted for a pay group with multiple pay export definitions, Dayforce creates multiple pay exports, one for each definition.

The following is a screenshot of the Export Configurations tab in Pay Setup > Pay Group:

Export Configuration tab settings.

The following is a description of each of the controls in this tab and various options for each:

  • Export Definition: This drop-down list contains the export definitions that you’ve previously defined. Select one from the list, or click the edit icon () to create or manage new export definitions. When pay is transmitted for a pay group with multiple pay export definitions, Dayforce creates multiple pay exports, one for each definition.
  • Current Payroll Engine: You can specify a payroll engine manually using this drop-down list by either selecting the Custom Definition option, or, if Dayforce is integrated with another Dayforce payroll product, select one of the following payroll engines:
    • Custom Definition
    • Ceridian HPL Canada
    • Ceridian HPW / HPL
    • Ceridian Insync COSTING
    • Ceridian Powerpay
    • Ceridian Redwood/Freedom
  • This drop-down list is grayed out and unavailable until you confirm that you want to change the existing export XML configuration. You can do this by clicking the locked icon ().
  • Type: This drop-down list contains several export types. Select one of the following:
    • Pay Export Definition: Defines the details of the regular pay export. This export is initiated when users click the Transmit button in Pay Admin Checklist.
    • GL Export Definition: Defines the details of the general ledger export. This export initiated when users click the Transmit to GL button in Pay Admin Checklist.
    • Pay Out Export: Defines the details of the offcycle pay export. This export is initiated when users click the Offcycle button in Pay Admin Checklist and select the Pay Out to Date option.
    • Prior Pay Adjustment Export: Defines the details of the offcycle pay export. This export is initiated when users click the Offcycle button in Pay Admin Checklist and select the Pay Adjustments from Prior Periods option.
    • Payroll GL Export Definition: Defines the details of the GL (General Ledger ) Export.
    • Pay Run Data Export: Defines the details to export pay run data from Dayforce. The export is designed to export employee specific pay run information.
  • Advanced Export Options: Advanced export options are used to configure Dayforce to send data export files over FTP or SFTP. See Configure Export Options.
  • Run Accrual Export: Configures the pay group so that application automatically runs the Accrual Export whenever the Payroll Export is run. Select from any existing (that is, previously saved) export definitions.
  • Export XML: Field in which you enter the XML (eXtensible Markup Language) for the export definition. See the Dayforce Payroll Export Interface Specification for details and a list of eligible tokens. The Export XML section has the following additional options:
    • Validate: Validates the XML in the fields. Dayforce provides a message stating whether the validation succeeded or failed with details about the line and position of elements that caused validation failure.
    • Synchronize: Overwrites existing XML and XSLT definitions of the selected definition with what is displayed in Export XML and Export XSLT fields.
    • Important: If you selected the Sync Export Definitions checkbox in the Export Options section of the Pay Group Properties tab for the same pay group, the synchronize functionality (triggered when you click Synchronize) syncs the displayed XML/XSLT to all export types for the selected export definition, which overwrites any existing export XML/XSLT with what is displayed here. Don't use this if you don't want to overwrite existing XML/XSLT export definitions.
  • Export XSLT: Field in which you enter the XSLT (eXtensible Stylesheet Language Transformations) for the export definition. See the Dayforce Payroll Export Interface Specification for details and a list of eligible tokens.

As part of this XML definition, you need to define what columns are included in the Pay Export Report if you plan on using the report. The definition needs to be edited such that the column definitions include a ReportColumn setting specifying that the column is included in the report. The value that you set is the order that you need the columns to display in the report. For example, the following specifies that these three columns are included in the report:

<Columns>
…
<Column Name="flxid" DataType="string" Value="emp_xref" Function="group" ReportColumn="1" />
<Column Name="paytype" DataType="string" Source="data" Value="pcat_xref" ReportColumn="2" />
<Column Name="hours" DataType="number" Source="mapping" Function="sum" ReportColumn="3" />
…
</Columns>