Work Flow Setup Crews
Field Name |
Caption |
Mask |
Description |
Field Type |
CR_ACT_FLG |
Active Crew |
|
Active Crew |
Boolean |
CR_CREW_CD |
Crew |
10x |
Crew |
Text |
CR_CREW_TY |
Crew Text |
25x |
Crew Text |
Text |
CR_CRT_BY |
Created By |
25x |
Created By |
Text |
CR_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CR_DEPT_CD |
Department |
10x |
Department |
String |
CR_DEPT_TY |
Department Text |
50x |
Department Text |
String |
CR_DIV_CD |
Division Code |
10x |
Division Code |
String |
CR_DIV_TY |
Division Description |
40x |
Division Description |
String |
CR_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
CR_HWPD |
Hours Worked per Day |
nnn |
Hours Worked per Day |
Integer |
CR_ID |
Crew Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
CR_IMG_FLG |
|
|
Image Available (Not Used) |
Boolean |
CR_LEAD_CD |
Lead Worker |
20x |
Lead Worker |
Text |
CR_LEAD_ID |
Lead Worker Rec # |
nnnnnnnn |
Link to WKUEMP.EM_ID - for Lead Worker ID |
Long Integer |
CR_LEAD_TY |
Lead Worker Text |
40x |
Lead Worker Text |
Text |
CR_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CR_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
CR_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CR_MOV_FLG |
|
|
Movie Available (Not Used) |
Boolean |
CR_OID |
|
|
Visual CE Linking Field |
Long Integer |
CR_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CR_SHIFTCD |
Shift |
nnn |
Shift |
Integer |
CR_SHIFTTY |
Shift Type |
25x |
Shift Type |
String |
CR_STAT_CD |
Crew Status |
nnn |
Crew Status |
Integer |
CR_STAT_TY |
Crew Status Text |
25x |
Crew Status Txt |
Text |
CR_SUPR_CD |
Supervisor |
20x |
Supervisor |
Text |
CR_SUPR_ID |
Supervisor Rec # |
nnnnnnnn |
Link to WKUEMP.EM_ID - for Supervisor ID |
Long Integer |
CR_SUPR_TY |
Supervisor Text |
40x |
Supervisor Text |
Text |