1 Reply Latest reply on Mar 18, 2013 9:37 AM by philmodjunk

    Personnel files

    EP

      Title

      Personnel files

      Post

           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.

            

           Thanks

        • 1. Re: Personnel files
          philmodjunk

               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.