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 Employment Records In ClientSpace

Owned by Tony Hayes
Last updated: Jul 02, 2019
1 min read

Application Scope: PEO

Problem

In reviewing Employee Information in ClientSpace, it is reported that some employees have multiple employment records, all but one of which are inactive.

Cause

Employment is a historized form -  storing a historical track of Employee job changes.

Solution

During the historize process the current record is cloned when there are changes and then saved as inactive, then the current record is updated and saved as the IsCurrent record. 

This is done to preserve the foreign key relationships between the Employment record and any child records it may have such as I-9 records etc...

There should only ever be one active employment record at any given time.


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