Purpose
The Infrastructure.OSHrecords DataMart is designed to provide a structured and centralised repository for occupational health and safety (OHS) records sourced from the myOSH system via API exports. This DataMart enables efficient reporting, compliance tracking, and analysis of safety-related incidents, risk assessments, and other regulatory documentation. By transforming the raw API data into a well-structured format, this DataMart facilitates:
- Data Integration: Providing a structured source of truth for integration with broader enterprise reporting systems.
- Visibility & Auditing: Ensuring health and safety records are easily accessible for audits and reviews.
- Compliance & Governance: Supporting regulatory requirements for OHS data storage and reporting.
- Operational Insights: Enabling trend analysis for risk assessments, incidents, injuries, and corrective actions.
Use Case
Owner: Taariq Fry
Typical Use Case:
- OHS Performance Reporting: Tracking trends in risk assessments, injuries, and incidents over time.
- Regulatory Compliance: Supporting audits and documentation requirements.
- Operational Decision-Making: Identifying recurring safety risks and improvement areas.
- Incident Analysis: Understanding the root causes of workplace hazards.
Style: Fact
Source
osh.recordsKey Parameters
- Unified Record Keeping: Consolidates myOSH records into a structured SQL-based DataMart for easier integration.
- Flexible JSON Handling: Stores key form values in JSON format, enabling dynamic extraction and reporting.
- Comprehensive Form Coverage: Supports 17 different form types, including Risk Assessments, Incidents, Nonconformities, and Sign-Off Forms.
- Role-Based Access: Implements structured
readAccessRolesto manage data visibility. - Geospatial Data Storage: Captures location metadata (
longitude/latitude) for incident tracking.
Sample Exec
EXEC get.myView @dataMart = 'Infrastructure', @viewName = 'OSHrecords', @token = '<myToken>', @version = '<202404>'Response
The Infrastructure.OSHrecords DataMart extracts, transforms, and stores data from myOSH, an operational health and safety system. The underlying data structure captures various OHS forms, including risk assessments, incidents, injury reports, non-conformities, worker’s compensation details, and sign-offs. Each record retains key metadata, including:
- Identifiers:
id,sourceID,module,form,formVersion - Dates & Statuses:
creationDate,lastModified,workflowStepHistory,status - Review & Approval:
important,workflowStepHistories,fieldsToValues - Access & Permissions:
readAccessRoles - Form-Specific Data:
fieldsToValues,fieldsToAdditionalValues,fieldsToQuestionWithAnswers
A core feature of this DataMart is the JSON-based field storage (fieldsToValues), allowing for flexible querying of key information such as persons involved, risk titles, locations, responsible reviewers, and linked risks.