Need some advice. I am creating a personnel database for a human resources dept. How are "Re-Hires" usually handled within a datatbase? For example, if John Smith is Hired on 1/5/1996 and is terminated on 6/22/2006; but is then re-hired on 3/15/2011 - Current Date........would it be typical to create a brand new personnel record for John Smith and have him in the database twice (2 records)? Or would it be better to keep 1 record for him? I am trying to take into account Time Off accruals, etc. that is based on the Date Hired/time worked.
It would make sense to me to add a related record where you document each hire and termination event. That way, you have one record for the employee, but a "history table" linked to it where you can see each date when an employee was hired and when they were terminated.