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.

  • This applies to all tables with the date/time/user stamps. The created info should never change. I have discovered some issues in other modules where this info was apparently updated by a utility or data conversion.