Welcome to CURISTICA Hazard Log Visualiser

A cloud-based platform for managing medical device hazard logs in compliance with DCB0129, DCB0160, and ISO 14971.

📖 Complete User Manual Available!

For detailed step-by-step instructions, workflows, and troubleshooting, see: USER_GUIDE.md

The guide covers everything from importing data to exporting regulatory reports.

🚀 Quick Start

First Time Users:

  1. Select a product from the dropdown in the header above
  2. Explore the tabs below to view your hazard log in different formats
  3. Import new data via the Import tab (Excel → Database)

📤 Need to import your hazard log?

Go to the Import tab → Select Excel file → Normalize → Convert → Upload to Database

📑 Platform Tabs

2ī¸âƒŖ Hazard Log

Your main workspace â€ĸ View, Edit, Export â€ĸ Database persistence

What is this tab for?

View: Hierarchical display with search, statistics, and pagination

Edit: Click âœī¸ EDIT MODE in the floating sidebar to add/modify/delete items

Save: Click 💾 Save Changes to write to database (all users see changes)

Export: Download JSON or Excel (Data format for analysis, Report format for presentations)

Protection: Auto-save every 30 seconds â€ĸ Undo/Redo (Ctrl+Z/Y) â€ĸ Warning on page close

3ī¸âƒŖ Bow-Tie Diagram

Simple visual: Causes → Controls → Hazard → Harm â€ĸ Best for presentations

4ī¸âƒŖ Network Graph (D3.js)

Interactive bow-tie with zoom/pan â€ĸ Risk color-coding (1-5 scale)

5ī¸âƒŖ Network Graph (Cytoscape.js) ⭐

Advanced graph â€ĸ Shared control detection (orange border) â€ĸ Click controls to highlight

What makes this special?

Shared Control Detection: Automatically identifies controls that mitigate multiple causes (shown with orange border and count)

Interactive Highlighting: Click any control to see its relationships with golden highlights

Split Layout: Graph view (left) + Detail panel (right) for exploring complex relationships

Best For: Finding shared controls and understanding control-to-cause mappings

6ī¸âƒŖ Import

Convert Excel to database â€ĸ Normalize → Convert → Upload

7ī¸âƒŖ Settings

Database management â€ĸ View products â€ĸ Delete (requires typing "DELETE")

✅ Common Workflows

Adding New Hazards/Controls
  1. Go to Hazard Log tab
  2. Click âœī¸ EDIT MODE in the floating sidebar (right side)
  3. Click ➕ Add buttons to add new items
  4. Click 💾 Save Changes to write to database
  5. Switch tabs to see changes visualized
Editing Existing Items
  1. Enter edit mode (âœī¸ EDIT MODE button)
  2. Click any field with blue dashed border to edit
  3. Type changes and click away to save to memory
  4. Use Ctrl+Z to undo, Ctrl+Y to redo
  5. Click 💾 Save Changes when ready
Importing New Product
  1. Go to Import tab
  2. Select Excel file (.xlsx)
  3. Click Normalize → Convert to JSON
  4. Fill in product metadata (name, version, DCB)
  5. Click Upload to Database
  6. Product appears in header dropdown immediately
Exporting Reports
  1. Go to Hazard Log tab
  2. Click 📊 Export Excel (Report) for NHS Standard format
  3. Or click 📊 Export Excel (Data) for flat analysis format
  4. File downloads with 4 tabs: Summary, Hazard Log, Risk Matrix, Controls
  5. Use Report format for regulatory submissions (DCB0129/DCB0160)
âš ī¸ Deleting a Product (PERMANENT)
  1. Go to Settings tab → Click 🔄 Refresh
  2. Find product in table, click đŸ—‘ī¸ Delete
  3. Read warning carefully
  4. Type exactly DELETE (all caps) in the input field
  5. Press Enter or click Delete Project button

âš ī¸ WARNING: Permanently deletes ALL hazards, causes, controls, evidence, and relationships. Cannot be undone! Export JSON backup first.

💡 Key Features to Remember

  • â˜ī¸ Database Sync: Edits persist across sessions and are visible to all users instantly
  • đŸ‘ī¸ Live Preview: See edits in all tabs before clicking Save Changes
  • â†ļ Undo/Redo: Full change history with Ctrl+Z (undo) and Ctrl+Y (redo)
  • 💾 Auto-Save: Browser backup every 30 seconds (not database - click 💾 Save for that)
  • 🎨 Risk Color Coding: 1 Green 2 Yellow 3 Orange 4 Light Red 5 Dark Red
  • 🔗 Shared Controls: Orange border in Cytoscape graph = control protects multiple causes

📖 Need More Help?

For detailed instructions, see USER_GUIDE.md

  • Step-by-step workflows
  • Troubleshooting guide
  • NHS Risk Matrix explanation
  • Compliance requirements (DCB0129, DCB0160, ISO 14971)
  • Best practices and tips

✨ Ready to Start?

Select a product from the dropdown above or click the Import tab to upload your hazard log.

đŸ“Ĩ Import JSON to Database

Upload a processed JSON file (v2.0 normalized format) to import it directly into the database.

📄

Drag & drop your JSON file here

or click to browse

Supported: .json (v2.0 normalized format)

📤 Import Excel Hazard Log

Upload your Excel hazard log file to convert it to JSON format. Files are processed entirely in your browser - your data never leaves your computer.

Generic: Works with any hazard log format. Automatically detects column structure.

📁

Drag & drop your Excel file here

or click to browse

Supported: .xlsx, .xls

➕ Add Controls to Existing Product

Upload an Excel file with additional controls to add to an existing product in the database.

📁

Drag & drop your controls Excel file here

or click to browse

Supported: .xlsx, .xls

📋 Expected Excel Format

Your Excel file should contain the following columns:

  • cause_id - ID of the cause this control mitigates (must exist in product)
  • control_id - Unique identifier for the control
  • control_description - Description of what the control does
  • control_type - Type (e.g., DESIGN, TRAINING, PROCESS)
  • control_category - Category (e.g., initial, additional)
  • evidence (optional) - Supporting evidence reference

📄 Upload SPID/SCID Documents

Upload Structured Product Information Documents (SPID) or Structured Context Information Documents (SCID) in JSON format.

SPID: All products | SCID: DCB 0160 products only

📋 Upload SPID

Structured Product Information Document (JSON format)

📄

Drag & drop SPID JSON here

or click to browse

Supported: .json (validated against SPID schema)

đŸĨ Upload SCID

Structured Context Information Document (JSON format)

📄

Drag & drop SCID JSON here

or click to browse

Supported: .json (validated against SCID schema)

â„šī¸ Document Requirements

  • SPID: Required for all products (DCB 0129 and DCB 0160)
  • SCID: Required only for DCB 0160 products (deployment context)
  • Documents must be valid JSON matching the SPID/SCID schema
  • Each product can have one SPID and multiple SCIDs
  • Validation is performed automatically before upload
Please select a JSON file to view
No cards available
Jump to Card: 0%

📋 No Hazard Log Data

Load a hazard log to start reviewing controls in Workshop mode.

âš ī¸
Selected:
No selection
Please select a JSON file to view
Detail View

Click on a node or edge to view details

Please select a JSON file to view
Please select a JSON file to view

Data Analyser

Load a hazard log file to see detailed statistics.

Export Options

Export your hazard log data in various formats. Customize filenames or use defaults with timestamp.

📄 JSON Export

Export complete hazard log data in JSON format. Ideal for data interchange, backups, and programmatic processing.

📊 Excel Export (Data)

Flat tabular format with 29 columns. Suitable for re-importing, data analysis, and Excel manipulation.

📋 Excel Export (Report)

Formatted presentation with merged cells, color-coding, and styling. Not suitable for re-importing.

đŸĨ NHS Standard Export

Export in NHS DCB0129 format with 4 tabs: Cover Sheet (document control), Risk Summary (with dynamic formulas), Hazard Log (26 columns with hierarchical structure), and Risk Matrix. Compliant with NHS Digital Clinical Safety standards.

đŸ“Ļ Standalone Package

Self-contained HTML file for offline viewing. Perfect for sharing with customers - no server required, works in any modern browser.

✅ Customer-ready: Single HTML file (~150-200KB) â€ĸ Opens offline â€ĸ No installation needed

💡 Tips

  • Leave filename blank to use default format: hazard_log_YYYY-MM-DD
  • Custom filenames will automatically add the appropriate extension (.json or .xlsx)
  • Timestamps ensure unique filenames and prevent overwriting existing files
  • All exports use the currently loaded hazard log data

đŸ—„ī¸ DATABASE

Manage products, SPID documents, and SCID documents

đŸ“Ļ Products

Click "Refresh" to load products

📄 SPID Documents

Click "Refresh" to load SPID documents

📋 SCID Documents

Click "Refresh" to load SCID documents

đŸ‘¨â€âš•ī¸ Clinical Safety Officers (CSO)

Manage Clinical Safety Officers responsible for hazard log oversight and product safety. CSOs are assigned to products and sign off on safety assessments.

Click "Refresh" to load Clinical Safety Officers

🔄 Convert DCB 0129 to DCB 0160

Create a new DCB 0160 product by duplicating a DCB 0129 product and filtering for TRANSFERRED status hazards only. This workflow is commonly used when transitioning hazards from DCB0129 to DCB0160 standards.

Refresh to load available DCB 0129 products

New Product Metadata (DCB 0160)

â„šī¸ How Conversion Works

  • Only hazards with STATUS = "TRANSFERRED" will be included
  • All causes linked to transferred hazards will be copied
  • All controls linked to those causes will be copied
  • All evidence linked to those controls will be copied
  • The new product will have DCB = "0160"
  • Original IDs will be preserved for traceability
  • The source product remains unchanged

đŸĨ Health Information Technology Log

Manage health IT products used across deployment sites (from SCID documents Section E)

📋 Select Organisation

📋 Health IT Products

Select an organisation and click "Load HIT Log"

â„šī¸ About HIT Log

The Health Information Technology Log tracks all IT products and systems used by healthcare organisations. This data is part of the SCID (Safety Case Information Document) Section E.

  • View all HIT products for a selected organisation
  • Edit product details including DCB compliance status
  • Add new products to track
  • Export data to Excel for reporting
  • Track integration status with GP systems
  • Monitor contract end dates and procurement details

Settings

Choose between light and dark color schemes

Choose a color palette optimized for color vision deficiency (red-green color blindness)

Color-blind mode uses blue-orange scale instead of green-red, with added icons for clarity

Choose which tab opens by default when loading a product

Default: Workshop tab (recommended for hazard review)

Choose your preferred font family for the entire application

Note: Font changes apply instantly across the entire application and are saved automatically.

Choose between collapsible sidebar or classic horizontal tabs

💡 Sidebar navigation offers keyboard shortcuts (Ctrl+B), drag-to-resize, and pinnable tabs

âš ī¸ Page will reload to apply navigation style changes

Customize ID prefixes for hazards, causes, controls, and evidence. ID format will be [PREFIX]-XXX where XXX is a 3-digit number (e.g., HAZ-001).

Note: These preferences will be used when generating new IDs for hazards, causes, controls, and evidence. Changes will take effect immediately after saving.

🔐 Admin Settings

Administrative functions for user management and audit logging

Manage user accounts and product access permissions

View system activity and compliance audit trail

Track all changes to entities and rollback to previous versions

📜
Select a product to view version history
đŸ’Ŧ
âš ī¸ Add Hazard
🔸 Add Cause
đŸ›Ąī¸ Add Control
📋 Add Evidence

Validate Entity

AI-Generated Suggestion

Current / Editable Value

Validation Decision

Workshop Mode Help

Navigate through your hazard log one control at a time using a card-based interface. Perfect for detailed review and focused analysis of each mitigation measure.

Keyboard Shortcuts

Navigate cards
Home First card
End Last card
Space Next card
F11 / ESC Toggle fullscreen

Mode Buttons

  • Edit Mode - Enable inline editing of hazard log entries
  • Causal Mode - Show Cause before Hazard (cause-first layout)
  • Fullscreen - Expand workshop to full screen for focus

âœī¸ Edit Evidence

âœī¸ Edit Control

âœī¸ Edit Cause

âœī¸ Edit Hazard

Initial Risk Assessment

Residual Risk Assessment

📊 NHS Risk Matrix

This risk matrix shows how severity and likelihood combine to determine risk scores (1-5).

NHS Risk Matrix