app.osha_cases
TableRow level security on
Recordable work-related injuries and illnesses (29 CFR Part 1904): each row is a Form 300 log entry and its Form 301 incident report. Health information: read with data.restricted.read.medical.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.osha_establishments on insert; never accepted from the caller and never changed.References app.organizations.id |
| establishment_id | uuid | No | Establishment whose log the case is on.References app.osha_establishments.id |
| incident_id | uuid | Yes | Incident the case came from, when there is one.References app.incidents.id |
| log_year | smallint | No | Year of the log; the year of the injury or illness date. Set by the database. |
| case_number | text | No | Case no. (Form 300 column A, Form 301 item 10). Numbered per establishment and year by the database when left empty. |
| person_id | uuid | Yes | The employee, when they are a person in XOS.References app.people.id |
| employee_name | text | Yes | Employee's full name when they are not a person in XOS (Form 300 column B, Form 301 item 1). |
| privacy_case | boolean | No | A privacy concern case (29 CFR 1904.29(b)(6) to (9)): the log prints "privacy case" in place of the name. |
| job_title | text | No | Job title (Form 300 column C). |
| injury_date | date | No | Date of injury or onset of illness (Form 300 column D, Form 301 item 11). |
| event_location | text | No | Where the event occurred (Form 300 column E). |
| description | text | No | Injury or illness, parts of body affected, and object or substance that directly injured or made the person ill (Form 300 column F). |
| outcome | text | No | Most serious outcome: Death, Days away from work, Job transfer or restriction, or Other recordable case (Form 300 columns G to J). |
| days_away | smallint | No | Days away from work (Form 300 column K). Counting stops at 180 together with days_restricted. |
| days_restricted | smallint | No | Days on job transfer or restriction (Form 300 column L). |
| case_type | text | No | Injury, Skin disorder, Respiratory condition, Poisoning, Hearing loss or All other illnesses (Form 300 column M). |
| employee_street | text | Yes | Employee's street (Form 301 item 2). |
| employee_locality | text | Yes | Employee's city (Form 301 item 2). |
| employee_region | text | Yes | Employee's state, two letters (Form 301 item 2). |
| employee_postal_code | text | Yes | Employee's ZIP code (Form 301 item 2). |
| date_of_birth | date | Yes | Date of birth (Form 301 item 3). |
| date_hired | date | Yes | Date hired (Form 301 item 4). |
| employee_sex | text | Yes | Male or Female, as Form 301 item 5 asks. |
| health_care_professional | text | Yes | Name of physician or other health care professional (Form 301 item 6). |
| treatment_facility | text | Yes | Facility where treatment was given away from the worksite (Form 301 item 7). |
| facility_street | text | Yes | Facility street (Form 301 item 7). |
| facility_locality | text | Yes | Facility city (Form 301 item 7). |
| facility_region | text | Yes | Facility state, two letters (Form 301 item 7). |
| facility_postal_code | text | Yes | Facility ZIP code (Form 301 item 7). |
| emergency_room | boolean | Yes | Was the employee treated in an emergency room (Form 301 item 8). |
| hospitalized_overnight | boolean | Yes | Was the employee hospitalized overnight as an in-patient (Form 301 item 9). |
| work_began_at | time without time zone | Yes | Time the employee began work (Form 301 item 12). |
| event_time | time without time zone | Yes | Time of event (Form 301 item 13). |
| event_time_unknown | boolean | No | The time of the event cannot be determined (Form 301 item 13). |
| activity_before | text | Yes | What the employee was doing just before the incident occurred, with no personally identifiable information (Form 301 item 14). |
| what_happened | text | Yes | How the injury occurred (Form 301 item 15). |
| injury_detail | text | Yes | The injury or illness: part of the body affected and how (Form 301 item 16). |
| harmful_object | text | Yes | Object or substance that directly harmed the employee (Form 301 item 17). |
| died_on | date | Yes | Date of death, if the employee died (Form 301 item 18). |
| completed_by | uuid | Yes | Person who completed the Form 301.References app.people.id |
| completed_title | text | Yes | Title of the person who completed the Form 301. |
| completed_phone | text | Yes | Phone of the person who completed the Form 301. |
| completed_on | date | Yes | Date the Form 301 was completed. |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |