Active Employees / Terminated Employees
Hey guys, I am really stumped on this issue. I am having a hard time with removing employees from an employee database and keeping that data organized.
Essentially, Human Resources will click a button that says Terminate Employee. This will take them to a form and they fill out Termination details, submit form. Employee added to the termination database no longer exist in the active employee database or table.
When the employee is added to the Terminated database, however, it's still not separated from the Active Employee database. They just appear in both databases.
------------------------
Is there a way for me to make it so that employee will only exist inside the Terminated Database once they're terminated or would I just be better off going with an Employee Status type situation where you just sort / filter employees based off Status changes.
I really want to have these tables organized, though. Where Active Employees are not mixed in with Terminated Employees at all, but really needing some help thinking this through.
Essentially, Human Resources will click a button that says Terminate Employee. This will take them to a form and they fill out Termination details, submit form. Employee added to the termination database no longer exist in the active employee database or table.
When the employee is added to the Terminated database, however, it's still not separated from the Active Employee database. They just appear in both databases.
------------------------
Is there a way for me to make it so that employee will only exist inside the Terminated Database once they're terminated or would I just be better off going with an Employee Status type situation where you just sort / filter employees based off Status changes.
I really want to have these tables organized, though. Where Active Employees are not mixed in with Terminated Employees at all, but really needing some help thinking this through.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Helped me to decide the best option is using Status instead of actually deleting the records.
ASKER