To create a data export for current employee addresses, follow the steps below.
In the Admin Tool, click Import/export data.
Click Create an export definition.
Click Select the data to export.
From the Database drop-down menu, select Select HR.
Click the SQL tab, then delete Select*.
Copy the following SQL data into the blank space:
Select Person.Snapshot.[Person Number], Person.Snapshot.[First Name], Person.Snapshot.Surname, Person.Snapshot.[Effective Status], Person.Snapshot.[Key Unit Name 1], Person.Snapshot.[Key Unit Name 2], Person.Snapshot.[Key Unit Name 3], Person.[Current Address].Type, Person.[Current Address].[Address Line 1], Person.[Current Address].[Address Line 2], Person.[Current Address].[Address Line 3], Person.[Current Address].[Address Line 4], Person.[Current Address].[Address Line 5], Person.[Current Address].[Post Code] From Person.Snapshot Left Join Person.[Current Address] On Person.Snapshot.[Person Number] = Person.[Current Address].[Person Number] Where Person.Snapshot.[Effective Status] = 'Current'
Select the relevant filter criteria then click the Data tab.
Click Key Field at the top-left then select the relevant option.
Click OK then review the data.
Once you're happy with the data, in the Definition field, enter a name for the export.
Next to Export to file location, click Browse then choose where to save the export.
From the File Format drop-down menu, select the relevant option.
If required, select the Export column headers check box.
Click Next then select the relevant options.
Click Next then click Finish.