Hazard Studio · import

Three short steps, and a report.

Import a hazard log · Hazard log v7.xlsx

Match your columns

1Columns
2Values
3Review

Sheet “Hazard Log”, header on row 5 · Change

RefHL-014, HL-015, HL-016Hazard ID
Parent refPM-01, PM-01, PM-02Parent hazard ID
HazardHyphenated surname…Hazard name
CauseMatching ignores punctuationPossible causes
Existing controls (design)DOB checkExisting controls: Design
LikelihoodRemote, OccasionalLikelihood
Not used · 2
ReviewerDr A. PatelNot used
RAGAmberNot used
Import a hazard log

Two terms we don’t recognise

1Columns
2Values
3Review

Frequent, Occasional, Remote and Negligible were matched automatically. Choose a level for these; we’ll remember them.

Your termQyro level
SeldomLow
GraveMajor
Import a hazard log

Ready to import

1Columns
2Values
3Review
83 hazards found
12 parent hazards, from your parent column
9 themes proposedYou review them after the import
4 rows skippedNo hazard name in rows 88 to 91
4 hazards need a ratingFlagged “Rating needed”, never dropped
See the first five hazards
Import report
87
Rows read
83
Imported
4
Skipped
4
Rating needed

Mapping used: 14 columns, 2 not used · value terms: 6 matched, 2 chosen by you · kept with the import.

Imports
Import 2 · Hazard log v7.xlsx83 hazards · 12 Oct · by Zak
Import 1 · Riverside local log.csv12 hazards · 3 Oct · 3 edited since

Editing a mapping updates the import in place. If hazards were edited or approved since, you choose to re-import as a new batch and retire the untouched originals.

After the import · themes
HazardProposed theme
Hyphenated surname creates a duplicate recordWrong patientMatched by keyword
Shared mobile number links two patientsWrong patientSuggested by Qyro
Out-of-hours messages not readMissed urgencySuggested by Qyro