HEMERG - Employee Emergency Contact (EM) Database

HEMERG field information

 
Seq Field Name Type Length Dec Description

1

E_2ADDR1

C

28

0

Second Contact Address Line 1

2

E_2ADDR2

C

28

0

Second Contact Address Line 2

3

E_2ADDR3

C

28

0

Second Contact Address Line 3

4

E_2BUSEXT

C

4

0

Second Contact Business Phone Exten

5

E_2CONTACT

C

25

0

Second Contact Name

6

E_2CPHONE

C

13

0

Second Contact Cellular Phone

7

E_2HPHONE

C

13

0

Second Contact Home Phone

8

E_2PAGER

C

13

0

Second Contact Pager Number

9

E_2RELAT

C

8

0

Second Contact Relation Code

10

E_2WPHONE

C

13

0

Second Contact Work Phone

11

E_ADDR1

C

28

0

First Contact Address Line 1

12

E_ADDR2

C

28

0

First Contact Address Line 2

13

E_ADDR3

C

28

0

First Contact Address Line 3

14

E_BUSEXT

C

4

0

First Contact Business Phone Extens

15

E_CHADATE

T

8

0

Last Change Date

16

E_COMPANY

C

3

0

Company Code

17

E_CONTACT

C

25

0

First Contact Name

18

E_CPHONE

C

13

0

First Contact Cellular Phone

19

E_EMPNO

C

9

0

Employee ID

20

E_HPHONE

C

13

0

First Contact Home Phone

21

E_PAGER

C

13

0

First Contact Pager Number

22

E_RELAT

C

25

0

First Contact Relation Code

23

E_WPHONE

C

13

0

First Contact Work Phone

24

_2RELAT

C

25

0

Second Contact Relation Description

25

_RELAT

C

25

0

First Contact Relation Description

26

_ZFILTER

C

25

0

Filter Function