Create Case

establishment_id is the ID of the establishment this case belongs to (required).

year_of_filing is the year this case is filed for (required).

case_number is the case number.

job_title is the job title of the affected employee.

date_of_incident is the date the incident occurred.

incident_location is where the incident occurred.

incident_description is description of the incident.

incident_outcome is the outcome of the incident (1=Death, 2=Days away, 3=Job transfer, 4=Other).

dafw_num_away is days away from work.

djtr_num_tr is days job transfer or restriction.

type_of_incident is the type of incident (1=Injury, 2=Skin disorder, 3=Respiratory, 4=Poisoning, 5=Hearing loss, 6=Other).

date_of_birth is the employee's date of birth.

date_of_hire is the employee's date of hire.

sex is the employee's sex (M or F).

treatment_facility_type is whether emergency room was used (1=yes, 0=no).

treatment_in_patient is whether hospitalization was required (1=yes, 0=no).

time_started_work is time employee began work (hh:mm format).

time_of_incident is time of incident (hh:mm format).

time_unknown is whether time of incident is unknown.

nar_before_incident is what employee was doing before incident.

nar_what_happened is how injury/illness occurred.

nar_injury_illness is what the injury/illness was.

nar_object_substance is object/substance that harmed employee.

date_of_death is the date of death if applicable.

employee_name is the name of the employee.

employee_street_address is the street address of the employee.

employee_city is the city where the employee resides.

employee_state is the two-letter state code for the employee.

employee_zip is the ZIP code for the employee.

physician_name is the name of the physician who treated the employee.

facility_name is the name of the treatment facility.

facility_street_address is the street address of the treatment facility.

facility_city is the city where the treatment facility is located.

facility_state is the two-letter state code for the treatment facility.

facility_zip is the ZIP code for the treatment facility.