the DateCreated field in the PR_Employee table should not change when EMP# or Department changes.
by: Burke S. | 2 months ago | Payroll / Job Cost
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.
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.