NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm

Duplicate Employee In Dataform List

Application Scope: PEO

Problem

Open a Client Workspace and go to Employees and one or more of the employees in the list appear to have duplicate records

Cause

Inner Join in List Select statement causing multiple rows to come back due to multiple active Employment records.

Solution

Inactivate the appropriate Employment record.

Step by step

In order to inactivate the appropriate Employment record you must first understand how the historical employment records are generated.  When a change for an employee job history (employment) record arrives in the system the original record is cloned, then inactivated, the original record is then updated to reflect the new changes before being saved.  This process should leave only one record in the system with the IsActive flag checked.  Sometimes however this process may fail, leaving multiple employment records marked as IsActive.

The Employee dataform list will erroneously join the employee once to each of these records, resulting in a list containing seemingly duplicate employees when there is in fact only one employee records and multiple employment records.  To correct the issue

  1. Open one of the employee records
  2. Using the header link open each employment record and look at the Administrative fields at the bottom of the records to find the RecordID
  3. The Employment record with the lowest ID number (oldest record) should remain Active. (IsActive checkbox should be checked)
  4. All other Employment records for this employee should have the IsActive checkbox unchecked to inactivate them.  Remember to Save your changes.
  5. As you inactivate these Employment records, you will see the "duplicate" employee records eliminated from the list.

 

Article Images:

 

NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm