Employee Safety

Fact table Description Source table
Fact Employee Incident Identifies the type of incident that occurred. For example, employee safety, near misses incidents, accidents, illnesses or injuries. EmployeeIncident
Fact Incident Identifies the type of incident that occurred. For example, employee safety, near misses incidents, accidents, or causal factors. Incident
Fact Incident Cost Calculates the cost of safety and near misses incidents. IncidentCost
Fact Incident Observation Identifies the type of incident observation that occurred. For example, safety and near misses observations or observations converted to incidents. IncidentObservation
Fact Resource Health Component Provides information of individual tests or vaccines that employees must complete. For example, COVID-19 vaccine or tests, flu shots, immunizations, or other health-related items. The Analyze by Date is the Assigned Date. ResourceHealthComponent
Fact Resource Health Correspondence Created for health components to be completed in a specific location for a date/time. The Analyze by Date is the Appointment Date. ResourceHealthCorrespondence
Fact Resource Health Component Snapshot Tracks all the health components of employees and its component statuses by snapshot month. ResourceHealthComponent
Fact Incident Snapshot Have Incident count measure, analyze the measure by Snapshot date for respective dimension attributes Incident
Fact Incident Observation Snapshot Have Incident observations count measure, analyze the measure by Snapshot date for respective dimension attributes IncidentObservation