WKCLSEMP

Work Employee Classes to Employee Setup Linking Table

Field Name

Caption

Mask

Description

Field Type

CE_CC_ID

Link to WKCRTCLS

nnnnnnnn

Link to WKCRTCLS.CC_ID

Long Integer

CE_CCOST

Class Cost

nnnnnnnn.nn

Class Cost

Double

CE_CCOSTNOTE

Class Cost Notes

100x

Class Cost Notes

String

CE_CEU

CEUs

nnnnnnnn.nn

CEUs

Double

CE_CRT_BY

Created By

25x

Created By

Text

CE_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

CE_DL

Degree/License

 

Degree/License

Boolean

CE_DOC_FLG

Doc Available: Doc Flag

 

Doc Available: Doc Flag

Boolean

CE_EMPL_CD

Employee #

20x

Employee #

String

CE_EMPL_TY

Employee Name

40x

Employee Name

String

CE_EM_ID

Link to WKUEMP

nnnnnnnn

Link to WKUEMP.EM_ID

Long Integer

CE_EXPENSE

Expenses

nnnnnnnn.nn

Expenses

Double

CE_EXPENSENOTE

Expenses Notes

100x

Expenses Notes

String

CE_HOURS

Hours

nnnnnnnn.nn

Hours

Double

CE_ID

Auto Number

nnnnnnnn

AutoNumber

Long Integer

CE_LODGE

Lodging

nnnnnnnn.nn

Lodging

Double

CE_LODGENOTE

Lodging Notes

100x

Lodging Notes

String

CE_MOD_BY

Last Modified By

25x

Last Modified By

Text

CE_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

CE_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

CE_OREGION

Outside of Region

 

Outside of Region

Boolean

CE_PDH

PDHs

nnnnnnnn.nn

PDHs

Double

CE_PERDIEM

Per Diem

nnnnnnnn.nn

Per Diem

Double

CE_PERDIEMNOTE

Per Diem Notes

100x

Per Diem Notes

String

CE_REQUIRED

Required

 

Required

Boolean

CE_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

CE_SUPR_CD

Supervisor

20x

Supervisor

String

CE_SUPR_TY

Supervisor Name

40x

Supervisor Name

String

CE_TITLECD

Supervisor Job Title

nnn

Supervisor Job Title

Integer

CE_TITLETY

Supervisor Job Title Text

25x

Supervisor Job Title Text

String

CE_TOTCOST

Total Cost

nnnnnnnn.nn

Total Cost

Double

CE_TRAVEL

Travel

nnnnnnnn.nn

Travel

Double

CE_TRAVELNOTE

Travel Notes

100x

Travel Notes

String