1. ITSM for Healthcare and Hospitals
  2. Data model and migration order
Reference

The tables behind ITSM for Healthcare and Hospitals

ITSM for Healthcare and Hospitals ships with 53 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.

Tables
53
Features
7, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Service work:

Services, Incidents, incident updates, incident response events, service requests and Problems connect operating work to a named service.

Clinical consequence:

Clinical service impacts and clinical downtime register link care impact and outage timing to Incidents.

Change control:

Changes, clinical change advisory reviews, clinical system deployments and clinical rollback checks hold a planned change, advisory decision, service deployment and change rollback check for review.

Equipment:

Assets, biomedical assets, biomedical asset assignments, biomedical asset service links and biomedical asset disposals track device identity, custody and dependencies.

Guidance and inbound evidence:

Clinical knowledge articles, clinical article feedback and integration receipts preserve reviewed guidance and event processing outcomes.

Every table, by feature

Clinical incidents

6 tablesAbout this feature
  • Incidents

    Clinical system incidents with priority, assignment and resolution state.

    Linked to Services, Assets, People
  • Incident response events

    Response Events records for IT service and asset operations.

    Linked to Incidents, People
  • Incident updates

    Chronological updates recorded against a clinical incident.

    Linked to Incidents, People
  • Clinical service impacts

    Clinical Service Impacts records for IT service and asset operations.

    Linked to Incidents, People
  • Services

    Clinical and IT services delivered across the hospital and health system.

    Linked to People
  • Assets

    Tracked clinical, network and endpoint devices in service.

    Linked to Services

Service requests

3 tablesAbout this feature
  • Service requests

    Clinical service requests raised by hospital staff.

    Linked to People, Services
  • Services

    Clinical and IT services delivered across the hospital and health system.

    Linked to People
  • People

    People records for IT service and asset operations.

    Linked to Users

Changes and deployments

5 tablesAbout this feature
  • Changes

    Clinical system changes with risk, schedule and rollback plan.

    Linked to Services
  • Clinical change advisory reviews

    CAB Reviews records for IT service and asset operations.

    Linked to Changes, People
  • Clinical system deployments

    Deployments records for IT service and asset operations.

    Linked to Services
  • Clinical rollback checks

    Rollback Checks records for IT service and asset operations.

    Linked to Changes
  • Services

    Clinical and IT services delivered across the hospital and health system.

    Linked to People

Biomedical assets

7 tablesAbout this feature
  • Assets

    Tracked clinical, network and endpoint devices in service.

    Linked to Services
  • Biomedical assets

    Biomedical Assets records for IT service and asset operations.

    Linked to Assets
  • Biomedical asset assignments

    Asset Assignments records for IT service and asset operations.

    Linked to Assets, People
  • Biomedical asset disposals

    Asset Disposals records for IT service and asset operations.

    Linked to Assets, People
  • Services

    Clinical and IT services delivered across the hospital and health system.

    Linked to People
  • People

    People records for IT service and asset operations.

    Linked to Users

Downtime and impact

4 tablesAbout this feature
  • Clinical service impacts

    Clinical Service Impacts records for IT service and asset operations.

    Linked to Incidents, People
  • Clinical downtime register

    Register Outages records for IT service and asset operations.

    Linked to Incidents
  • Incidents

    Clinical system incidents with priority, assignment and resolution state.

    Linked to Services, Assets, People
  • People

    People records for IT service and asset operations.

    Linked to Users

Integration receipts

1 tableAbout this feature
  • Integration receipts

    Inbound clinical integration events and their processing outcome.

Problems and knowledge

5 tablesAbout this feature
  • Problems

    Recurring or underlying problems behind clinical incidents.

    Linked to Services, People
  • Clinical knowledge articles

    Knowledge Articles records for IT service and asset operations.

    Linked to People, Services
  • Clinical article feedback

    Article Feedback records for IT service and asset operations.

    Linked to Clinical knowledge articles
  • Incidents

    Clinical system incidents with priority, assignment and resolution state.

    Linked to Services, Assets, People
  • Services

    Clinical and IT services delivered across the hospital and health system.

    Linked to People

Shared and settings

32 tables
  • Clinical API endpoints

    API Endpoints records for IT service and asset operations.

    Linked to Services, People
  • Clinical API usage windows

    API Usage Windows records for IT service and asset operations.

    Linked to Clinical API endpoints
  • Clinical availability checks

    Availability Checks records for IT service and asset operations.

    Linked to Services
  • Clinical backup runs

    Backup Runs records for IT service and asset operations.

    Linked to Clinical database instances
  • Clinical cable connections

    Cable Connections records for IT service and asset operations.

    Linked to Incidents
  • Clinical cloud cost lines

    Cloud Cost Lines records for IT service and asset operations.

    Linked to Incidents
  • Clinical compute clusters

    Clusters records for IT service and asset operations.

    Linked to People
  • Clinical DNS records

    DNS Records records for IT service and asset operations.

    Linked to Clinical network domains
  • Clinical database instances

    Database Instances records for IT service and asset operations.

    Linked to Assets, People
  • Clinical deployment observations

    Deployment Observations records for IT service and asset operations.

    Linked to Clinical compute clusters
  • Clinical downtime windows

    Store Trading Windows records for IT service and asset operations.

    Linked to Incidents
  • Clinical feature flag rollouts

    Flag Rollouts records for IT service and asset operations.

    Linked to Clinical feature flags, People
  • Clinical feature flags

    Feature Flags records for IT service and asset operations.

    Linked to Services, People
  • Clinical license assignments

    License Assignments records for IT service and asset operations.

    Linked to Clinical software license entitlements, People, Assets
  • Clinical log alerts

    Log Alerts records for IT service and asset operations.

    Linked to Clinical log streams
  • Clinical log streams

    Log Streams records for IT service and asset operations.

    Linked to Services
  • Clinical network domains

    Domains records for IT service and asset operations.

    Linked to People
  • Clinical on call shifts

    On Call Shifts records for IT service and asset operations.

    Linked to Services, People
  • Clinical optimization recommendations

    Optimization Recommendations records for IT service and asset operations.

    Linked to Incidents
  • Clinical patch attempts

    Patch Attempts records for IT service and asset operations.

    Linked to Clinical patch catalog, Assets
  • Clinical patch catalog

    Patch Catalog records for IT service and asset operations.

  • Clinical provisioning requests

    Provisioning Requests records for IT service and asset operations.

    Linked to Clinical service templates, People
  • Clinical rack positions

    Rack Positions records for IT service and asset operations.

    Linked to Assets
  • Clinical release pipeline runs

    Pipeline Runs records for IT service and asset operations.

    Linked to Services
  • Clinical saa s subscriptions

    Saa S Subscriptions records for IT service and asset operations.

    Linked to People
  • Clinical saa s usage

    Saa S Usage records for IT service and asset operations.

    Linked to Clinical saa s subscriptions, People
  • Clinical server telemetry samples

    Server Samples records for IT service and asset operations.

    Linked to Assets
  • Clinical service templates

    Service Templates records for IT service and asset operations.

    Linked to People
  • Clinical software license entitlements

    License Entitlements records for IT service and asset operations.

    Linked to Incidents
  • Patient status components

    Public Components records for IT service and asset operations.

    Linked to Services
  • Patient status updates

    Public Updates records for IT service and asset operations.

    Linked to Incidents, People
  • Users

    Users

    Linked to Users

Keys and references

Use stable service, asset and person identifiers before importing transactions. Keep the external event identifier and payload hash on each integration receipt. Link impact and downtime to the original incident. Retain the change review row and its reviewer when recording the implementation result. Check device tags against the original asset before importing assignments.

Migration order

  1. Load Users, People and Services, then confirm the intended owner references.
  2. Load Assets and biomedical assets, followed by assignments and service links.
  3. Load Incidents and linked response events, updates, clinical impacts and downtime records.
  4. Load service requests, Problems and Changes; then load advisory reviews, service deployments and rollback checks.
  5. Load knowledge articles and integration receipts, then reconcile identifiers and permissions before the pilot.

Set up ITSM for Healthcare and Hospitals your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started