TIMEKEEPAUDIT

Supplements the existing time keeping tables. Whenever a user logs into TIMEREVIEW a new record is entered into TIMEKEEPAUDIT.

Column	Type	Description
STRUSERCODE	VARCHAR(20)	Code of the user that logs into TIMEREVIEW.
STRTRADECODE	VARCHAR(10)	Module execution trade code.
DTMUSERLOGIN	DATETIME	The date and time the user logged into TIMEREVIEW.
INTCTRCODE	BIGINT	CTRCODE of the changed TIMEKEEPSUMMARY record.
DTMOLDCLICKINDATETIME	DATETIME	Record the old clock in date and time (NULL if not changed).
DTMOLDCLODEOUTDATETIME	DATETIME	Record the old clock out date and time (NULL if not changed).
DTMNEWCLOCKINDATETIME	DATETIME	Record the new clock in date and time (NULL if not changed).
DTMOLDCLOCKOUTDATETIME	DATETIME	Record the new clock out date and time (NULL if not changed).