1. Radiology Information System
  2. Data model
Reference

The tables behind Radiology Information System

Radiology Information System ships with 15 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
15
Features
6, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Facility context:

Organizations, imaging modalities, People, Patients and source mappings establish the participants and definitions.

Order and report:

Imaging orders carries the lifecycle; imaging reports holds linked report detail and study identity.

Review:

Evidence documents and review decisions preserve supporting material and revision decisions; follow up actions owns exceptions.

Execution:

Execution attempts, operation runs, operation steps and state history explain attempts, receipts and state changes.

Every table, by feature

Order intake and scheduling

6 tablesAbout this feature
  • Imaging orders

    Imaging order lifecycle from ordered through released, with accession and PACS identity

    Linked to Organizations, People, Imaging modalities, Patients
  • Imaging modalities

    Configured imaging modality definitions and effective policy windows

    Linked to Organizations
  • Patients

    Protected subject identities with consent scope

  • Organizations

    Imaging organizations and facilities operating the radiology service

  • People

    Staff identities: schedulers, technologists, radiologists and reviewers

    Linked to Organizations
  • State history

    Immutable status transition history for imaging orders

    Linked to Imaging orders, People

Exam performance

5 tablesAbout this feature
  • Imaging orders

    Imaging order lifecycle from ordered through released, with accession and PACS identity

    Linked to Organizations, People, Imaging modalities, Patients
  • Execution attempts

    Individual execution attempts for an imaging order operation key

    Linked to Imaging orders
  • Operation runs

    Durable operation runs with frozen revision, input hash and result identity

    Linked to Imaging orders
  • Operation steps

    Numbered steps within an operation run with input/output and receipt evidence

    Linked to Operation runs
  • State history

    Immutable status transition history for imaging orders

    Linked to Imaging orders, People

Report review and release

5 tablesAbout this feature
  • Imaging reports

    Report detail lines and versions linked to the exact accession and study

    Linked to Imaging orders, Patients, People
  • Imaging orders

    Imaging order lifecycle from ordered through released, with accession and PACS identity

    Linked to Organizations, People, Imaging modalities, Patients
  • Review decisions

    Independent reviewer decisions against an exact source revision

    Linked to Imaging orders, People
  • Evidence documents

    Supporting documents and external evidence for an imaging order

    Linked to Imaging orders, People
  • Operation steps

    Numbered steps within an operation run with input/output and receipt evidence

    Linked to Operation runs

Evidence and follow-up

4 tablesAbout this feature
  • Evidence documents

    Supporting documents and external evidence for an imaging order

    Linked to Imaging orders, People
  • Follow up actions

    Open and completed follow-up work arising from imaging orders

    Linked to Imaging orders, People
  • Imaging orders

    Imaging order lifecycle from ordered through released, with accession and PACS identity

    Linked to Organizations, People, Imaging modalities, Patients
  • People

    Staff identities: schedulers, technologists, radiologists and reviewers

    Linked to Organizations

Modality and facility setup

6 tablesAbout this feature
  • Organizations

    Imaging organizations and facilities operating the radiology service

  • Imaging modalities

    Configured imaging modality definitions and effective policy windows

    Linked to Organizations
  • People

    Staff identities: schedulers, technologists, radiologists and reviewers

    Linked to Organizations
  • Patients

    Protected subject identities with consent scope

  • Source mappings

    Reviewed field mappings from source systems into modality definitions

    Linked to Imaging modalities
  • Imaging orders

    Imaging order lifecycle from ordered through released, with accession and PACS identity

    Linked to Organizations, People, Imaging modalities, Patients

Execution history

5 tablesAbout this feature
  • Execution attempts

    Individual execution attempts for an imaging order operation key

    Linked to Imaging orders
  • Operation runs

    Durable operation runs with frozen revision, input hash and result identity

    Linked to Imaging orders
  • Operation steps

    Numbered steps within an operation run with input/output and receipt evidence

    Linked to Operation runs
  • State history

    Immutable status transition history for imaging orders

    Linked to Imaging orders, People
  • Imaging orders

    Imaging order lifecycle from ordered through released, with accession and PACS identity

    Linked to Organizations, People, Imaging modalities, Patients

Shared and settings

1 table
  • Users

    Users

    Linked to Users

Keys and references

Imaging reports.Parent points to imaging orders. Both records carry accession number, DICOM study UID and PACS reference for comparison. Review decisions.Source and source revision identify the decision’s order revision. Operation runs.Source and source revision identify the executed revision; operation steps.Run attaches receipt evidence. Follow up actions.Source and evidence documents.Source return to the order.

Migration order

  1. Load Organizations, People, Patients and imaging modalities with stable identifiers.
  2. Review source mappings against the modality definitions and effective dates.
  3. Import imaging orders, then linked imaging reports and evidence documents.
  4. Reconcile review decisions, state history, operation runs, operation steps, execution attempts and follow up actions against their source references.

Set up Radiology Information System your way.

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

How to get started