The steps below detail the steps to create a basic report to identify a list of leavers, including the following information:
First Name, Surname, Start Date, End Date, Job Title, Key Unit, Address and Date of Birth:
In the Admin Tool, click Import/Export Data.
Select Create an export definition.
Click Select the Data to export.
From the Database dropdown select the HR database, usually called SelectHR.
Click OK to login.
Copy the following code:
Select Person.Snapshot.[Effective Status], Person.Snapshot.[First Name], Person.Snapshot.Surname, Person.Details.[Birth Date], Person.Snapshot.[Starting Date], Person.Snapshot.[Leaving Date], Person.Address.[Address Line 1], Person.Address.[Address Line 2], Person.Address.[Address Line 3], Person.Address.[Post Code], Person.Snapshot.[Post Name], Person.Snapshot.[Key Unit Number 1], Person.Snapshot.[Unit Number], Person.Snapshot.[Person Number] From Person.Snapshot Inner Join Person.Details On Person.Snapshot.[Person Number] = Person.Details.[Person Number] Inner Join Person.Address On Person.Details.[Person Number] = Person.Address.[Person Number] Where Person.Snapshot.[Effective Status] = 'Leaver'
From the upper left hand corner, select the green Options arrow and select Paste SQL from clipboard.
Click the Data tab to view the results.