You can create a basic export of current employee details using the Admin Tool.
The export includes the following fields:
Person number
Effective status
First name
Surname
E-mail
Gender
Continuous service date
Location name
Post name
Manager name
Supervisor name
Create export
Follow the steps below to generate the export.
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.[Effective Status], Person.Snapshot.[First Name], Person.Snapshot.Surname, Person.Snapshot.[E-Mail], Person.Snapshot.Gender, Person.Snapshot.[Continuous Service Date], Person.Snapshot.[Location Name], Person.Snapshot.[Post Name], Person.Snapshot.[Manager Name], Person.Snapshot.[Supervisor Name] From Person.Snapshot 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 Person Number.
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.