The most common reason for an employee showing up twice in employee listings is that the employee has multiple current appointment records.
In such cases, the system will display a separate row for each appointment. This is expected behaviour, as listings are designed to show each active appointment individually.
📌 Note: If you require a listing or export that returns only one row for each employee, you should use the table Person.Details, avoiding the use of Snapshot.
Duplicates show without multiple appointments present
Another reason for a duplicate appearing in a people listing may be that there is a field in the field list that doesn't relate to the person record in a one to one relationship, but instead in a one to many.
🤓 Tip: To check if the duplication is caused by a customised field listing, see if the employee is duplicated on a standard menu-set e.g (HR V2.0).
You may be able to quickly identify a field or view from a listing by exporting the data in the listing.
Filter the listing to show the duplicate records.
Right-click the data in the listing.
Hover over Export Data.
Hover over Export to Excel.
Hover over All Pages.
Click Export Hidden Columns.
Opening this may highlight where you have unique data. For example, if your listing has been customised to show pay records for each employee, duplicate records could occur due to the employee having two pay history records.
However, if this doesn't make it clear, you will need to confirm the View or Table which is causing the query to return more than one row.
Identify if there is a field that relates to a view or table that returns unique information
In the Admin Tool, click Menus,
Select the relevant Menu Set and navigate to the area on the front end that shows the duplicate.
Double-click the Menu Item to explore the Processes, and click on the padlock to unlock if necessary.
Select appropriate list, then click User Interface.
Within the View area, click Change, scroll to the right, and take a note of the description of this field list.
As a test, change to a simple and standard list with as few items as possible, i.e. [name] if this correctly only displays a single entry, then the problem is definitely with the listing.
Click OK, then Apply.
Refresh the front end and check to see if the listing reflects the changes and if only one line of data applies, this confirms that this is not duplicate data but rather there is a field that contains unique data. Otherwise please raise a case with support.
If you have confirmed that there is a unique field in the data, you follow the steps from 1 to 5, and now click Edit Selected to manually adjust the listing.
Remove any entries from the problematic field list, one by one, or rebuild the field list, checking to see which field causes the duplicate.