When looking at the rostering link, you may find that people are missing from the link. This may be due to one of two reasons:
Their rostering has expired.
They have been deleted from the link.
The Rostering has expired
Each individual on the Rostering Link can be given an expiry date.
β
Linked employees should have their Expiry Date set when they are no longer wanted in the integration. This way, the linked system will be informed that the employee is no longer linked. After the date passes then the employee will no longer appear.
Deleted from the link
There is the option to delete employees from the link by using Remove Employees.
Once this workflow is used on an employee, they will no longer appear in the link/listing.
π Note: We strongly recommend that you expire a linked employee instead of removing/deleting the employee from the link.
Locate employee(s) on the Rostering Links via a data export
In the Admin Tool, click Import/Export Data.
Click Create an export definition.
Click Select the data to export.
Change the database to SelectHR.
Log in.
Copy the below SQL:
Select Rostering.Links.[Link Number], Rostering.Links.[Link Name], Rostering.Links.[Link Notes], Rostering.Links.[Link Type Number], Rostering.Links.[Auth Key], Rostering.Person.[Rostering Person Number], Rostering.Person.[Person Number], Rostering.Person.[Link Number], Rostering.Person.[Appointment Number], Rostering.Person.[Employee ID], Rostering.Person.[Expiry Date], Rostering.Person.Workflow, Rostering.Person.[Created Date], Person.Details.[Formal Name] From Rostering.Links Inner Join Rostering.Person On Rostering.Links.[Link Number] = Rostering.Person.[Link Number] Inner Join Person.Details On Person.Details.[Person Number] = Rostering.Person.[Person Number] Where Person.Details.[Formal Name] = '%REPLACEWITHSURNAME%'
In the top left of the data export window, click Options, Paste SQL from clipboard.
Change the Criteria on the Formal Name field between the two % symbols with the Surname of the employee you are looking for.
Click Data.