the DateCreated field in the PR_Employee table should not change when EMP# or Department changes.

Comments

  • Perhaps add a field as to when the original file was created that is unchangeable. That way all the DateCreated when Emp Number changes will continue to update with each number change.