1. Mental Health Practice Mgmt
  2. Data model
Reference

The tables behind Mental Health Practice Mgmt

Mental Health Practice Mgmt 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

Every table, by feature

Patient records

4 tablesAbout this feature
  • Patients

    Patient identity and consent status

    Linked to People
  • People

    Clinic staff and clinicians

    Linked to Users
  • Consents

    Purpose-specific patient consent

    Linked to Patients
  • Care team assignments

    Care team access assignments

    Linked to Patients, People

Encounter scheduling

3 tablesAbout this feature
  • Encounters

    Patient visits and care episodes

    Linked to Patients, People
  • Patients

    Patient identity and consent status

    Linked to People
  • People

    Clinic staff and clinicians

    Linked to Users

Clinical documentation

4 tablesAbout this feature
  • Clinical notes

    Attributed clinical documentation

    Linked to Encounters, People
  • Observations

    Measured clinical observations

    Linked to Encounters, People
  • Encounters

    Patient visits and care episodes

    Linked to Patients, People
  • People

    Clinic staff and clinicians

    Linked to Users

Follow-up care

4 tablesAbout this feature
  • Care tasks

    Follow-up care tasks

    Linked to Patients, People
  • Patients

    Patient identity and consent status

    Linked to People
  • People

    Clinic staff and clinicians

    Linked to Users
  • Encounters

    Patient visits and care episodes

    Linked to Patients, People

Charges and payments

4 tablesAbout this feature
  • Charges

    Service charges for encounters

    Linked to Encounters
  • Payments

    Patient payments received

    Linked to Patients
  • Encounters

    Patient visits and care episodes

    Linked to Patients, People
  • Patients

    Patient identity and consent status

    Linked to People

Specialty records

4 tablesAbout this feature
  • Specimens

    Lab specimens and their processing state

    Linked to Encounters
  • Pharmacy dispensations

    Medication dispensations with lot and quantity

    Linked to Encounters, People
  • Encounters

    Patient visits and care episodes

    Linked to Patients, People
  • People

    Clinic staff and clinicians

    Linked to Users

Shared and settings

2 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Users

    Users

    Linked to Users

Keys and references

Patients.Id links to Encounters.Patient, Consents.Patient, care tasks.Patient and Payments.Patient. Encounters.Id links to clinical notes.Encounter, Observations.Encounter, Charges.Encounter, Specimens.Encounter and pharmacy dispensations.Encounter. People.Id is used for clinician, author, assignee, recorder and authorizer references. Keep those references intact when importing older records.

Migration order

  1. Staff and access. Prepare Users and People, then verify clinician identity.
  2. Patient identity. Load Patients with stable patient numbers and clinician references.
  3. Permission records. Add clinical privileges, care team assignments and Consents with evidence and dates.
  4. Care episodes. Load Encounters before their clinical notes, Observations, Specimens, pharmacy dispensations and Charges.
  5. Follow-up and receipts. Load care tasks and Payments after patient references are checked.

Set up Mental Health Practice Mgmt your way.

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

How to get started