Home > Technical > Table Definitions > TIMEKEEPAUDIT

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).

  
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)