To run a basic data export to find out which elements are mapped in your system, follow these steps.
In the Admin Tool, click on Import/Export Data.
Click Create an export definition.
Click Select the data to export.
Connect to the SelectHR database.
Click on the SQL tab.
Remove Select* and copy the SQL data below into the blank space, then click Data to generate the results.
Select ET.[Pay Element Type] As 'HR Pay element', PC.[Payroll Code] As 'Payroll Pay element', EP.[Payroll Name], EP.[Full Path Name] As 'Payroll Database' From Pay.[Element Types] As ET Left Join ZZConfig.[Payroll Codes] As PC On PC.[Select Code] = ET.[Pay Element Type Number] Left Join employee.Payrolls EP On EP.[Payrolls Number] = PC.[Payroll Name] Where PC.[Payroll Code] Is Not Null And PC.[Variable Name] Not In ('Pay Frequency', 'Analysis Levels')If you are happy with the results pulled in the Data tab click OK in the bottom right corner.
Name the export definition.
Browse to a file location to save this instance of the export, then click Next.
Click Next again, then click Finish.