AnsweredAssumed Answered

Personnel files

Question asked by EP on Mar 17, 2013
Latest reply on Mar 18, 2013 by philmodjunk


Personnel files


     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.