1. Patient Referral Management
  2. Data model
Reference

The tables behind Patient Referral Management

Patient Referral Management 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
7, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Referral work

Referrals holds the incoming specialty request. Referral follow ups holds dated outcomes for that particular request.

Patient and people

Patients anchors care work; People connects staff to Users. Care team assignments and all clinical privileges hold assignment and professional context.

Visits and documentation

Encounters links a patient and clinician to a visit. Clinical notes and Observations refer to the encounter. All consents refers to the patient.

Coordination and finance

Care tasks assigns patient actions. Charges refers to encounters, Payments to patients, and exchange rates holds effective exchange rates.

Every table, by feature

Referral intake and review

3 tablesAbout this feature
  • Referrals

    Inbound specialty referrals and their lifecycle.

    Linked to Patients
  • Patients

    Patient identity and consent status records.

    Linked to People
  • Referral follow ups

    Follow-up evidence recorded against referrals.

    Linked to Referrals

Referral follow-ups

3 tablesAbout this feature
  • Referral follow ups

    Follow-up evidence recorded against referrals.

    Linked to Referrals
  • Referrals

    Inbound specialty referrals and their lifecycle.

    Linked to Patients
  • Patients

    Patient identity and consent status records.

    Linked to People

Patient and care team

5 tablesAbout this feature
  • Patients

    Patient identity and consent status records.

    Linked to People
  • People

    Care team members and staff referenced across the app.

    Linked to Users
  • Care team assignments

    Patient access assignments for clinicians.

    Linked to Patients, People
  • All consents

    Purpose-specific patient consent records.

    Linked to Patients
  • Referrals

    Inbound specialty referrals and their lifecycle.

    Linked to Patients

Encounter coordination

5 tablesAbout this feature
  • Encounters

    Scheduled and completed patient visits.

    Linked to Patients, People
  • Patients

    Patient identity and consent status records.

    Linked to People
  • People

    Care team members and staff referenced across the app.

    Linked to Users
  • Clinical notes

    Attributed clinical documentation for encounters.

    Linked to Encounters, People
  • Observations

    Measured values captured during encounters.

    Linked to Encounters, People

Clinical documentation

5 tablesAbout this feature
  • Clinical notes

    Attributed clinical documentation for encounters.

    Linked to Encounters, People
  • Observations

    Measured values captured during encounters.

    Linked to Encounters, People
  • Encounters

    Scheduled and completed patient visits.

    Linked to Patients, People
  • All consents

    Purpose-specific patient consent records.

    Linked to Patients
  • Patients

    Patient identity and consent status records.

    Linked to People

Care tasks

3 tablesAbout this feature
  • Care tasks

    Assigned follow-up and coordination work.

    Linked to Patients, People
  • Patients

    Patient identity and consent status records.

    Linked to People
  • People

    Care team members and staff referenced across the app.

    Linked to Users

Privileges and access

5 tablesAbout this feature
  • All clinical privileges

    Verified professional privileges per clinician.

    Linked to People
  • Care team assignments

    Patient access assignments for clinicians.

    Linked to Patients, People
  • People

    Care team members and staff referenced across the app.

    Linked to Users
  • Users

    Users

    Linked to Users
  • Patients

    Patient identity and consent status records.

    Linked to People

Shared and settings

3 tables
  • Charges

    Service charges raised from encounters.

    Linked to Encounters
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Payments

    Confirmed patient payments and refunds.

    Linked to Patients

Keys and references

Confirm the patient record before importing referrals or encounters. A referral follow-up points to Referrals, while a care task points to Patients and People. Notes and observations point to Encounters; they should not be attached by matching names. Preserve the staff user link and the clinician reference on assignment and privilege records.

Migration order

  1. Load Users and People, then Patients.
  2. Add all clinical privileges, all consents and care team assignments for current care context.
  3. Load Referrals, then referral follow ups.
  4. Load Encounters before clinical notes, Observations and Charges.
  5. Load care tasks and Payments after their patient and staff references exist.
  6. Review exchange rates separately from patient care records.

Set up Patient Referral Management your way.

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

How to get started