Skip to main content

Employee missing from the Rostering Link

Employees missing from rostering link to People Planner.

H
Written by Harry Ledger
Updated over a month ago

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:

  1. Their rostering has expired.

  2. 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

  1. In the Admin Tool, click Import/Export Data.

  2. Click Create an export definition.

  3. Click Select the data to export.

  4. Change the database to SelectHR.

  5. Log in.

  6. 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%'
  7. In the top left of the data export window, click Options, Paste SQL from clipboard.

  8. Change the Criteria on the Formal Name field between the two % symbols with the Surname of the employee you are looking for.

  9. Click Data.

Did this answer your question?