HOSHA

Employee OSHA (OS) Database

Seq Field Name Type Length Dec Description

1

O_AWAYOVR

L

1

0

Override Days Away (T/F)

2

O_CASENO

N

6

0

Case Number

3

O_CAUSE

C

200

0

Cause of Incident

4

O_CHADATE

T

8

0

Last Change Date

5

O_CHNAME

C

25

0

Current Health Care Name

6

O_CHPHONE

C

13

0

Current Health Care Telephone

7

O_COMMENT1

C

200

0

Physician Notes

8

O_COMMENT2

C

200

0

Treatment Facility Notes

9

O_COMPANY

C

3

0

Company Code

10

O_DAYSAWAY

N

6

1

Days Away From Work

11

O_DAYSREST

N

6

1

Days Restricted From Work

12

O_DEATH

D

8

0

Date of Death

13

O_DIE

C

1

0

Did Employee Die? (Y/N)

14

O_DTCLOSED

T

8

0

Date Workers Comp Claim Closed

15

O_DTFILED

T

8

0

Date Workers Comp Claim Filed

16

O_EMPLOYEE

C

50

0

Person Filing This Report

17

O_EMPNO

C

9

0

Employee ID

18

O_EMROOM

L

1

0

Emergency Room Treatment (T/F)

19

O_FROMAWAY

T

8

0

Start Date Days Away from Work

20

O_FROMREST

T

8

0

Start Date Days Restricted Work

21

O_HNAME

C

25

0

Health Care Name

22

O_HOSPITAL

C

200

0

Hospital

23

O_INCAMPM

N

1

0

Incident Meridiem Code (1=AM/2=PM)

24

O_CCLASS

C

1

0

Reporting Classification Code

25

O_INCCOMP

C

3

0

Incident Location Employer

26

O_INCDATE

T

8

0

Incident Date

27

O_INCSEV

C

1

0

Incident Severity Classification

28

O_INCTIME

C

7

0

Incident Time

29

O_INJCODE

C

6

0

OSHA Injury Code

30

O_INJDESC

C

200

0

Injury Description

31

O_INJILL

C

1

0

Injury Type Code (1,2,3)

32

O_JOBCODE

C

8

0

Job Code

33

O_LAST

T

8

0

Date Last Worked

34

O_LASTAMPM

N

1

0

Last Meridian Code (1=AM/2=PM)

35

O_LASTTM

C

8

0

Time Last Worked

36

O_LEVEL1

C

12

0

Division Code

37

O_LEVEL2

C

12

0

Department Code

38

O_LEVEL3

C

12

0

Location Code

39

O_LEVEL4

C

12

0

Not Defined

40

O_LEVEL5

C

12

0

Not Defined

41

O_LOCCODE

C

6

0

Injury Location Code

42

O_LOCDESC

C

200

0

Additional Location Information

43

O_LPHONE

C

13

0

Telephone Number

44

O_MEDICAL

N

9

2

Medical Cost

45

O_NOTAMPM

N

1

0

Notify Meridian Code (1=AM/2=PM)

46

O_NOTIFY

T

8

0

Date Employee Notified Employer

47

O_NOTIFYTM

C

8

0

Time Reported

48

O_OBJECT

C

40

0

Object Causing Harm

49

O_OFFSITE

N

1

0

Treatment Offsite Code

50

O_OSHAOHS

C

4

0

Type of Incident (OSHA/OHS)

51

O_PARTCODE

C

6

0

OSHA Body Part Code

52

O_PARTDESC

C

200

0

Effect on Body Part Description

53

O_PATIENT

L

1

0

Overnight Hospital Stay (T/F)

54

O_PHONE

C

13

0

Reporting Person Phone

55

O_PHYS

C

200

0

Physician Name and Information

56

O_POSITION

C

35

0

Position of Person Filing Report

57

O_PREMISES

C

1

0

Accident on Premises (Y/N)

58

O_PRIVACY

L

1

0

Privacy Case

59

O_REPDATE

T

8

0

Date of This Report

60

O_REPORT

L

1

0

OSHA Reportable (T/F)

61

O_RESTOVR

L

1

0

Override Restricted Days (T/F)

62

O_RETAMPM

N

1

0

Return Meridian Code (1=AM/2=PM)

63

O_RETURN

T

8

0

Date Returned to Work

64

O_RETURNTM

C

8

0

Time Returned to Work

65

O_TASK

C

200

0

Task at Which Employee Was Engaged

66

O_TIMELOST

N

9

2

Cost of Time Lost From Work

67

O_TOAWAY

T

8

0

Ending Date Days Away

68

O_TOREST

T

8

0

Ending Date Days Restricted

69

O_WCCLAIM

C

13

0

Workers Comp Claim Number

70

O_WORKAMPM

N

1

0

Work Time Meridiem Code  (1=AM/2=PM)

71

O_WORKTIME

C

7

0

Work Start Time

72

_DIE

C

3

0

Did Employee Die Description

73

_INJILL

C

25

0

Injury Type Description

74

_LEVEL1

C

25

0

Division

75

_LEVEL2

C

25

0

Department

76

_LEVEL3

C

25

0

Location

77

_LEVEL4

C

25

0

Not Defined

78

_LEVEL5

C

25

0

Not Defined

79

_ZFILTER

C

25

0

Filter Function