Work Employee Classes to Employee Setup Linking Table
Field Name |
Caption |
Mask |
Description |
Field Type |
CE_CC_ID |
Link to WKCRTCLS |
nnnnnnnn |
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 |
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 |