WKUEMP

Work Flow Setup Employees

Field Name

Caption

Mask

Description

Field Type

EM_AC_ID

Account Rec #

-nnnnnnnn

Link to WKACCTNO.AC_ID

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

Link to WKEACCTNO.EA_ID

Long Integer

EM_EDEN_ID

Eden Link

nnnnn

Eden Link

Integer

EM_EMAIL

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

Link to WKEPROJNO.EP_ID

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