Home > FAQ > Data Manipulation > Event histories (status histories) > Cleaning or editing an event history > Considerations for editing events

Considerations for editing events

Here are some considerations for cleaning up or editing an event history:

Following these considerations, below is an example of events stored in a database before a cleanup effort and the service events used in a calculation.  You can see how much easier it is to review and process these events.

Events in the Database
Date Code Label
8/11/1999 01 Ineligible
1/10/2000 10 Hire
7/16/2007 81 Married
12/26/2009 82 New child
4/16/2010 31 Termination
5/17/2010 11 Rehire
8/3/2011 31 Termination
9/1/2011 11 Rehire
3/22/2015 41 Paid Leave
4/1/2016 42 Return from Paid Leave
10/27/2019 91 Divorced
Service Events
Date Code Label
1/10/2000 10 Hire
4/16/2010 31 Termination
5/17/2010 11 Rehire
12/11/2021 31 Termination