Work Flow Setup Employees
Field Name |
Caption |
Mask |
Description |
Field Type |
EM_AC_ID |
Account Rec # |
-nnnnnnnn |
Long Integer |
|
EM_ACCOUNT |
Account # |
45x |
Account # |
Text |
EM_ACT_FLG |
Active |
|
Active Employee |
Boolean |
EM_ADDRESS |
Address |
50x |
Address: |
Text |
EM_ADR_APT |
Apartment |
8x |
Apartment: |
Text |
EM_ASGN |
Assigner |
|
Employee is Assigner |
Boolean |
EM_ASNWORK |
Assigned Work |
nnn.nn |
Assigned Work (Hrs); |
Double |
EM_BIRTH |
Birthdate |
mm/dd/yyyy |
Birthdate: |
Date/Time |
EM_CITY |
City |
30x |
City: |
Text |
EM_CLASS |
Classification |
10x |
Class |
Text |
EM_CRT_BY |
Created By |
25x |
Created By |
Text |
EM_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
EM_DEPT_CD |
Department |
10x |
Department |
Text |
EM_DEPT_TY |
Department Description |
50x |
Department Text |
Text |
EM_DIV_CD |
Division Code |
10x |
Division Code |
String |
EM_DIV_TY |
Division Description |
40x |
Division Description |
String |
EM_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
EM_EA_ID |
Eden Acct Rec # |
nnnnnnnnn |
Long Integer |
|
EM_EDEN_ID |
Eden Link |
nnnnn |
Eden Link |
Integer |
EM_EMAIL |
150x |
Email Address |
Text |
|
EM_EMPL_CD |
Employee |
20x |
Employee # |
Text |
EM_EMPL_TY |
Employee Name |
40x |
Employee Name |
Text |
EM_EMPLID |
Login ID |
25x |
Employee Login ID |
Text |
EM_EMR1_NM |
Emerg Contact 1 |
30x |
Emergency Contact 1 |
Text |
EM_EMR1_PH |
Contact 1 Phone |
30x |
Emergency Contact 1 Phone |
Text |
EM_EMR2_NM |
Emerg Contact 2 |
30x |
Emergency Contact 2 |
Text |
EM_EMR2_PH |
Contact 2 Phone |
30x |
Emergency Contact 2 Phone |
Text |
EM_END_DT |
End Date |
mm/dd/yyyy |
End Date |
Date/Time |
EM_ENV |
Environmental |
|
Environmental |
Boolean |
EM_EP_ID |
Eden Proj Rec # |
nnnnnnnnn |
Long Integer |
|
EM_FAX_PHN |
FAX Number |
25x |
FAX # |
Text |
EM_HM_PHN |
Home Phone |
25x |
Home Phone |
Text |
EM_HWPD |
Hours Worked per Day |
nnn |
Hours Worked per Day |
Integer |
EM_ID |
Employee Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
EM_IMG_FLG |
|
|
Image Available |
Boolean |
EM_ISRES |
Is Resource Flag |
|
Is Resource Flag |
Boolean |
EM_JE_FLG |
Journal Entry Import |
|
Journal Entry |
Boolean |
EM_LDW_NF |
Lead Work Notif |
nnnnnnnn |
Link to CMNOTIF.NF_ID - for Lead Worker Notif |
Long Integer |
EM_LEAD |
Leadworker |
|
Employee is Leadworker |
Boolean |
EM_MOB_PHN |
Mobile Phone |
30x |
Mobile Phone: |
Text |
EM_MOD_BY |
Modified By |
25x |
Modified By |
Text |
EM_MOD_DT |
Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
EM_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
EM_MOV_FLG |
|
|
Movie Available |
Boolean |
EM_OID |
|
|
Visual CE Linking Field |
Long Integer |
EM_OVERE_C |
OT External Rate |
nnnn.nn |
Overtime External Hourly Rate |
Double |
EM_OVERI_C |
Overtime Rate |
nnnn.nn |
Overtime Internal Hourly Rate |
Double |
EM_PAG_PHN |
Pager Number |
25x |
Pager # |
Text |
EM_PNUMACT |
Proj No - Acct |
40x |
Proj No - Acct |
Text |
EM_POS_CD |
Position |
5x |
Position |
Text |
EM_POS_TY |
Position Text |
25x |
Position Type |
Text |
EM_POSTAL |
Zip Code |
30x |
Zip Code: |
Text |
EM_PROJ |
Project PM |
|
Project PM |
Boolean |
EM_REGE_C |
Reg External Rate |
nnnn.nn |
Regular External Hourly Rate |
Double |
EM_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
EM_SE_TM |
Shift End Time |
hh:mm am |
Shift End Time |
Date/Time |
EM_SENIOR |
Seniority |
nnnnn.nn |
Seniority: |
Double |
EM_SHIFTCD |
Shift |
nnn |
Shift |
Integer |
EM_SHIFTTY |
Shift Type |
25x |
Shift Type |
Text |
EM_SPR_NF |
Supv Req Notif |
nnnnnnnn |
Link to CMNOTIF.NF_ID - for Request Supervisor Notif |
Long Integer |
EM_SPW_NF |
Supv Work Notif |
nnnnnnnn |
Link to CMNOTIF.NF_ID - for Work Supervisor Nofit |
Long Integer |
EM_SRDAY |
Seniority - Days |
nn |
Seniority: Days |
Integer |
EM_SRMONTH |
Seniority - Months |
nn |
Seniority: Months |
Integer |
EM_SRYEAR |
Seniority - Years |
nn |
Seniority: Years |
Integer |
EM_SS_TM |
Shift Start Time |
hh:mm am |
Shift Start Time |
Date/Time |
EM_SSN |
SS Number |
30x |
SS Number: |
Text |
EM_START |
Start Date |
mm/dd/yyyy |
Start Date: |
Date/Time |
EM_STAT_CD |
Employee Status |
nnn |
Employee Status |
Integer |
EM_STAT_TY |
Employee Status Text |
25x |
Employee Status Txt |
Text |
EM_STATE |
State |
30x |
State: |
Text |
EM_SUPR |
Supervisor |
|
Employee is Supervisor |
Boolean |
EM_SUPR_CD |
Supervisor |
20x |
Supervisor |
Text |
EM_SUPR_TY |
Supervisor Text |
40x |
Supervisor Text |
Text |
EM_TIME_CD |
Time Cost |
nnn |
Time Cost |
Integer |
EM_TIME_TY |
Time Cost Type |
25x |
Time Cost Text |
Text |
EM_TITLECD |
Job Title |
nnn |
Title |
Integer |
EM_TITLETY |
Job Title Text |
25x |
Title Type |
Text |
EM_UNIT_C |
Unit Cost |
nnnnn.nnn |
Unit Cost |
Double |
EM_UNIT_M |
Units of Measure |
10x |
Unit of Measure |
Text |
EM_UOM_CD |
Unit of Measure |
5x |
Unit of Measure |
Text |
EM_UOM_TY |
Unit of Measure Text |
25x |
Unit of Measure Text |
Text |
EM_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
EM_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
EM_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
EM_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
EM_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
EM_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
EM_USER4 |
User 4 |
-nnnnnnnnn.nn |
User 4 |
Double |
EM_USER5 |
User 5 |
30x |
User 5 |
Text |
EM_USER6 |
User 6 |
|
User 6 |
Boolean |
EM_USER7 |
User 7 |
|
User 7 |
Boolean |
EM_USER8 |
User 8 |
|
User 8 |
Boolean |
EM_USER9 |
User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
EM_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
EM_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
EM_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
EM_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
EM_USER14 |
User 14 |
30x |
User 14 |
Text |
EM_USER15 |
User 15 |
30x |
User 15 |
Text |
EM_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
EM_USER16TY |
User 16 Text |
25x |
User 16 Text |
Text |
EM_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
EM_USER17TY |
User 17 Text |
25x |
User 17 Text |
Text |
EM_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
EM_USER18TY |
User 18 Text |
25x |
User 18 Text |
Text |
EM_USER19 |
User 19 |
|
User 19 |
Boolean |
EM_USER20 |
User 20 |
|
User 20 |
Boolean |
EM_USER21 |
User 21 |
|
User 21 |
Boolean |
EM_USER22CD |
User 22 |
nnn |
User 22 |
Integer |
EM_USER22TY |
User 22 Text |
50x |
User 22 Text |
String |
EM_USER23CD |
User 23 |
nnn |
User 23 |
Integer |
EM_USER23TY |
User 23 Text |
50x |
User 23 Text |
String |
EM_USER24CD |
User 24 |
nnn |
User 24 |
Integer |
EM_USER24TY |
User 24 Text |
50x |
User 24 Text |
String |
EM_USER25CD |
User 25 |
nnn |
User 25 |
Integer |
EM_USER25TY |
User 25 Text |
50x |
User 25 Text |
String |
EM_USER26CD |
User 26 |
nnn |
User 26 |
Integer |
EM_USER26TY |
User 26 Text |
50x |
User 26 Text |
String |
EM_USER27 |
User 27 |
50x |
User 27 |
String |
EM_USER28 |
User 28 |
50x |
User 28 |
String |
EM_USER29 |
User 29 |
50x |
User 29 |
String |
EM_USER30 |
User 30 |
50x |
User 30 |
String |
EM_USER31 |
User 31 |
50x |
User 31 |
String |
EM_USER32 |
User 32 |
nnnnnnnn.nn |
User 32 |
Double |
EM_USER33 |
User 33 |
nnnnnnnn.nn |
User 33 |
Double |
EM_USER34 |
User 34 |
nnnnnnnn.nn |
User 34 |
Double |
EM_USER35 |
User 35 |
nnnnnnnn.nn |
User 35 |
Double |
EM_USER36 |
User 36 |
nnnnnnnn.nn |
User 36 |
Double |
EM_USER37 |
User 37 |
mm/dd/yyyy hh:mm am |
User 37 |
DateTime |
EM_USER38 |
User 38 |
mm/dd/yyyy hh:mm am |
User 38 |
DateTime |
EM_USER39 |
User 39 |
mm/dd/yyyy hh:mm am |
User 39 |
DateTime |
EM_USER40 |
User 40 |
mm/dd/yyyy hh:mm am |
User 40 |
DateTime |
EM_USER41 |
User 41 |
mm/dd/yyyy hh:mm am |
User 41 |
DateTime |
EM_USER42 |
User 42 |
|
User 42 |
Boolean |
EM_USER43 |
User 43 |
|
User 43 |
Boolean |
EM_USER44 |
User 44 |
|
User 44 |
Boolean |
EM_USER45 |
User 45 |
|
User 45 |
Boolean |
EM_USER46 |
User 46 |
|
User 46 |
Boolean |
EM_WK_PHN |
Work Phone |
25x |
Work Phone # |
Text |