OSHACase

OSHACaseID	Unique ID for an OSHA Case	BigID	12
EmpUID	Employee Unique ID	BigID	12
CompanyID	Company Identifier	SmallID	12
Privacy	Should this record be private (Y/N)	Varchar	1
OSHACaseNum		Varchar	20
IncidentTS	Timestamp of OSHA Incident	Timestamp	32
TimeBeganWork	The time of day employee began work day.	Varchar	10
ClaimNum	OSHA Claim Number	Varchar	10
Costs		Number	22
OSHAClassify	OSHA Classification	Enum	1		ENUM D Death W Days Away J Job Restriction O Other
DaysAway	Number of missed days of work.	Number	22
DaysRestriction		Number	22
DateClosed	Date case was closed	SmallDate	32
Advisor	Advisor for an OSHA case.	Varchar	80
CmpltOn		SmallDate	32
CmpltBy	Who completed OSHA case	Varchar	80
CmpltByTitle	Title of person completing case	Varchar	80
CmpltByPhone	Phone number of person completing case.	Varchar	40
Injury	Y/N	Varchar	1
ActionBefore	The action causing the OSHA case.	Text	16000
InjuryWhere	Where the incident occurred	Text	16000
InjuryWhat	What caused the incident	Text	16000
InjuryEffect	The effect that the incident had	Text	16000
InjuryObject	Any object involved with the incident	Text	16000
IllnessType	Type of injury	Enum	1		ENUM 1 Skin disorder 2 Respiratory condition 3 Poisoning 4 Hearing loss 5 All other illnesses
EmergRoom	Was the emergency room visited? (Y/N)	Varchar	1
BodyPart	Body Part effected	Varchar	40
InPatient	Was this an inpatient procedure? (Y/N)	Varchar	1
DeathDate	Date of Death	Date	32
Notes	Comments	Text	16000
LockSeqNbr	*SYSTEM* Row Sequence Nbr	Long	12