These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Hospital Management System
- Data model
The tables behind Hospital Management System
Hospital Management System ships with 19 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
- 19
- Features
- 7
- Change it
- Add fields and tables in Proto
How the model is organised
Patient access:
Patients, Appointments and Departments identify the person, clinician, service and planned visit.
Active care:
Encounters anchor clinical notes, Observations, bed assignments and Charges.
Clinical follow-up:
Care tasks and care team assignments attach to Patients; diagnostic orders and medication orders attach to Encounters.
Specialty operations:
Diagnostic results attach to diagnostic orders, while operating bookings attach to Encounters.
Authority:
Consents attach to Patients; clinical privileges attach to People; People link staff to Users.
Collection:
Payments attach to Patients, so settlement against encounter Charges needs an agreed reconciliation process.
Every table, by feature
- Patient access5
- Encounters and beds6
- Clinical care7
- Diagnostics and medication6
- Theatre scheduling6
- Revenue cycle4
- Governance and access7
- Patients
Registered patients
Linked to People - Appointments
Scheduled patient appointments
Linked to People, Patients, Departments - Departments
Clinical departments
Linked to People - Consents
Patient consent records
Linked to Patients - Encounters
Patient visits and admissions
Linked to People, Patients
- Encounters
Patient visits and admissions
Linked to People, Patients - Bed assignments
Ward and bed occupancy
Linked to Encounters - Patients
Registered patients
Linked to People - Appointments
Scheduled patient appointments
Linked to People, Patients, Departments - Observations
Recorded measurements and vitals
Linked to People, Encounters - Clinical notes
Clinical documentation per encounter
Linked to People, Encounters
- Clinical notes
Clinical documentation per encounter
Linked to People, Encounters - Observations
Recorded measurements and vitals
Linked to People, Encounters - Care tasks
Assigned follow-up care work
Linked to People, Patients - Encounters
Patient visits and admissions
Linked to People, Patients - Patients
Registered patients
Linked to People - Care team assignments
Clinician access assignments per patient
Linked to People, Patients - Clinical privileges
Verified professional privileges
Linked to People
- Diagnostic orders
Lab and imaging orders
Linked to People, Encounters - Diagnostic results
Results attached to diagnostic orders
Linked to People, Diagnostic orders - Medication orders
Prescriptions issued during encounters
Linked to People, Encounters - Encounters
Patient visits and admissions
Linked to People, Patients - Clinical privileges
Verified professional privileges
Linked to People - People
Clinical and administrative staff directory
Linked to Users
- Operating bookings
Operating theatre bookings
Linked to People, Encounters - Encounters
Patient visits and admissions
Linked to People, Patients - People
Clinical and administrative staff directory
Linked to Users - Clinical privileges
Verified professional privileges
Linked to People - Consents
Patient consent records
Linked to Patients - Bed assignments
Ward and bed occupancy
Linked to Encounters
- Charges
Service charges raised against encounters
Linked to Encounters - Payments
Confirmed payments against patient accounts
Linked to Patients - Encounters
Patient visits and admissions
Linked to People, Patients - Patients
Registered patients
Linked to People
- Care team assignments
Clinician access assignments per patient
Linked to People, Patients - Clinical privileges
Verified professional privileges
Linked to People - Consents
Patient consent records
Linked to Patients - Patients
Registered patients
Linked to People - People
Clinical and administrative staff directory
Linked to Users - Users
Users
Linked to Users - Encounters
Patient visits and admissions
Linked to People, Patients
Keys and references
Patient number is the operational patient identifier. Each encounter references its patient and clinician. An appointment also references a department. A diagnostic result references its order, which in turn references an encounter. Medication orders reference the encounter for prescribing context. The staff directory references user accounts, while patient care assignments reference staff records.
Migration order
- Bring in Users and People, then verify staff identities.
- Add Departments, Patients, Consents and clinical privileges.
- Add Appointments, Encounters and care team assignments.
- Add bed assignments, clinical notes, Observations and care tasks.
- Add diagnostic orders, diagnostic results, medication orders and operating bookings.
- Add Charges and Payments, then reconcile patient references and service context.
Set up Hospital Management System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.