HWELL

Employee Wellness (WE) Database

Seq Field Name Type Length Dec Description

1

W_ALLERGY1

C

8

0

Allergy 1

2

W_ALLERGY2

C

8

0

Allergy 2

3

W_ALLERGY3

C

8

0

Allergy 3

4

W_BLOODTYP

C

2

0

Blood Type Code

5

W_CHADATE

T

8

0

Last Change Date

6

W_CHRONIC1

C

8

0

Chronic 1

7

W_CHRONIC2

C

8

0

Chronic 2

8

W_CHRONIC3

C

8

0

Chronic 3

9

W_COMMENT

C

30

0

Comments

10

W_COMPANY

C

3

0

Company Code

11

W_DONATEDT

T

8

0

Last Blood Donation Date

12

W_DRUGRES

C

8

0

Last Drug Test Results

13

W_EMPNO

C

9

0

Employee ID

14

W_HANDTYPE

C

6

0

Disability Type

15

W_HEIGHT

N

4

2

Height

16

W_LASTDRUG

T

8

0

Last Drug Test Date

17

W_LASTPHY

T

8

0

Last Physical Date

18

W_LREADRUG

C

6

0

Last Drug Test Reason

19

W_LREAPHY

C

6

0

Last Physical Reason

20

W_LTYPEDRU

C

6

0

Last Drug Test Type

21

W_LTYPEPHY

C

6

0

Last Physical Type

22

W_NEXTDRUG

T

8

0

Next Drug Test Date

23

W_NEXTPHY

T

8

0

Next Physical Date

24

W_NOTES

C

70

0

Notes

25

W_PHYRES

C

8

0

Physical Reason Code

26

W_PREEMP

T

8

0

Post Offer Physical Date

27

W_READRUG

C

6

0

Next Drug Test Reason

28

W_REAPHY

C

6

0

Next Physical Reason

29

W_RESTRICT

C

52

0

Restrictions

30

W_RHFACTOR

C

1

0

RH Factor

31

W_TYPEDRUG

C

6

0

Last Drug Test Type

32

W_TYPEPHY

C

6

0

Next Physical Type

33

W_WEIGHT

N

3

0

Weight

34

W_WELL1

C

8

0

Wellness Program 1

35

W_WELL2

C

8

0

Wellness Program 2

36

W_WELL3

C

8

0

Wellness Program 3

37

_BLOODTYP

C

25

0

Blood Type Description

38

_PHYRES

C

25

0

Physical Reason Description

39

_REAPHY

C

25

0

Physical Reason Description

40

_ZFILTER

C

25

0

Filter Function