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 |