I have an opinion question relating to deleting important records in a
human resources database. Any "best practices" papers or "white
papers" anyone know of would help tremendously.
Here is the scenario: A new employee is hired and goes through unpaid
training on premises waiting on security clearance. The employee fails
security clearance and is dismissed. Our personnel department wants to
delete this record.
My philosophy is that the record should not be deleted but rather a
field should be created "tagging" such hires as "Hired-Failed-
Security" so that queries and reports will not list them as an active
employee but the record will remain in the database. Cascading delete
problems could arise too.
Our personnel department wants such records totally out of the
database. I disagree.
Any opinions on this? Any sources I could go to to get any "best
practices" papers or "white papers" on this?
thanks!!!
Brockus Wade
human resources database. Any "best practices" papers or "white
papers" anyone know of would help tremendously.
Here is the scenario: A new employee is hired and goes through unpaid
training on premises waiting on security clearance. The employee fails
security clearance and is dismissed. Our personnel department wants to
delete this record.
My philosophy is that the record should not be deleted but rather a
field should be created "tagging" such hires as "Hired-Failed-
Security" so that queries and reports will not list them as an active
employee but the record will remain in the database. Cascading delete
problems could arise too.
Our personnel department wants such records totally out of the
database. I disagree.
Any opinions on this? Any sources I could go to to get any "best
practices" papers or "white papers" on this?
thanks!!!
Brockus Wade