WKTIMESHEETLOCK

Table used to hold timesheet locks added by supervisors

Field Name

Caption

Mask

Description

Field Type

TL_CRT_BY

 

25x

Created By

Text

TL_CRT_DTTM

 

 

Creation Date Time

Date/Time

TL_END_DT

 

 

Ending date of the lock

Date/Time

TL_ID

 

 

AutoID of the lock

Long Integer

TL_LOCK_TYPE

 

 

Denotes type of timesheet lock

Integer

TL_MOD_BY

 

25x

Login of the person who added the lock

Text

TL_MOD_DT

 

 

Date the lock was added

Date/Time

TL_MOD_TM

 

 

Time the lock was added

Date/Time

TL_PAYPRD_ID

 

 

Link to WKPAYPERIOD.PP_ID

Long Integer

TL_RSRC_CD

 

20x

ID of the employee for the lock

Text

TL_STRT_DT

 

 

Starting date of the lock

Date/Time