Tables

Represent groups of users in the system

Patient secure chat messages to and from clinical staff for real time communication

This table is used to track eye-related orders, such as eyeglass or contact lens orders.

Clinical note form that allows clinicians to provide point in time and longitudinal tracking of any data element they configure

Answers to questions that are requested to be answered for a given procedure by a procedure provider (lab, or other provider)

Insurance company

The facility table holds all of the facilities that provide healthcare in the EMR. It contains the primary billing location and other service locations/organizations that are not insurance companies tracked inside the EMR

Links ServiceRequests to supporting clinical information

Categories that documents can be assigned to

Main calculation records - one per logical calculation (e.g., average BP)

Holds individual procedure / labs ordered from the procedure_type table for a given procedure order. It contains also the individual diagnosis code that is related to the ordered procedure

Contains the care team records for a patient

Contains Patient Reported Outcome assessment results as delivered via the PROMIS assessment delivery system

Holds the layout settings for a specific dynamic field in the system

Individual observations for a specific immunization

CAMOS patient chart templates for a single item inside a CAMOS subcategory

Represents the information related to a group of patient’s visit to a healthcare provider. This is different than an appointment as this table tracks the actual service of care for a therapy group

Contains information about a specific contact’s address

Records transfer summary of care and is an alternative to recording referrals in the transactions table

Links clinical notes to patient documents

Accounts Receivable overall payment made towards a patient invoice/claim and is the main table that holds the patient payments ledger

Product/Drug sales to Patients

Contains the tracking of person records who are also patients in the system

Patient billing records for billing codes - Used for Claims Processing

Records symptoms, diagnosis, and recommended treatments for bronchitis in a patient

Holds information about decission support intervention system source attributes

Patient portal digital signatures used for patient documents and anywhere else a signature is required in the portal

Holds the disclosures of EHI made to third parties for a given patient

This table is used for recording vital signs and measurements related to the eye.

Insurance Eligibility Verification Tracking

Eye form base container record that all other eye forms are connected to

Holds data on encounters that exist outside of this EMR that were in a patient CCDA import

Contains the individual team member of a care team for a patient

Contains records of employers associated with patients in the system

Contains patient eating,sleeping,drinking,drug habits as well as other patient health history information

Track patient attendance to a therapy group session as contained in the Used by the form_group_attendance table

Holds requests to amend health care information typically initiated by the patient or an insurance company

Contains previous historical entries of the patient’s care team (providers and facilities) as well as patient previous name information

This table includes numerous fields for recording the results of neurological tests and assessments, such as near and distant vision, motility measurements, comments, and various neurological parameters.

Used for recording observations related to patients during medical encounters

Holds questionnaires results for a patient entered in by a provider as a patient charted form

A procedure order is an encounter form within a patient visit representing an order for one or more procedures and its associated report/results for the procedure. Orders can be for either internal or external procedure providers

Used for tracking individual state changes in the appointment/encounter of a patient

This table holds both internal and external laboratories as well as other organizations that provide lab testing, results, and other procedures that can be ordered by a provider

This table stores biometric data related to the eye, including axial length, pupil diameter, and other measurements.

Patient Messages about the healthcare treatment of the patient

Used for tracking the editing status of a form and whether it is currently being edited by a user

Represents a provider’s evaluation of an ankle injury including x-ray information, diagnosis, and recommended treatments

Tracks Patient Recalls. Recalls are when a patient should be reached out to or contacted for a healthcare followup.

Contains the list of issue types that medical health issue can be.

Contains the relationships between the counselors in a therapy group and the group

Contains lists of unique value sets that a record’s property can be. Individual values/options in the list may be linked to a specific codesystem

Review of Systems observations of the patient. Providers can use this form or the form_ros.

Procedure order overall report container for an ordered procedure result in procedure_order_codes which represents findings, conclusions, and recommendations for the procedure order

Export task for a subset of patients in the export job

Stores all of the digital documents that are connected to a patient.

Physical Examination clinical note

Clinical notes and comments for individual patient documents

This table holds a compendium of possible procedures and labs that can be ordered by the procedure ordering system within OpenEMR

Contains information about the relationship between a contact and another table such as person for relatedpersons

Encounter form that holds patient results for the GAD7 assessment

Contains all of the therapy groups that exist in the system

Contains the types / categories a patient scheduled appointment can be

Computer Aided Medical Ordering System notes that are part of a patient’s chart

Table for chart notes on patient aftercare plans, including Acute Intoxication/Withdrawal, Emotional/Behavioral Conditions and Complications, and Relapse Potential for patients’ care plans.

Patient pain map form. Pain map image for mapping this form is stored in the EHI zip export at images/painmap.png

Holds patient history, provider examination conducted, patient treatment plan, and follow up status

Stores implementation plans for eye-related activities.

Patient appointment events that occur in the system. Used in the patient flowboard and for patient data reporting

Holds information about assessments, evaluations, or observations of a patient’s functional and cognitive abilities.

general purpose relations

Holds questionnaire results for a patient

This table is used for recording external eye examination findings.

Insurance Billing Claims - Used for tracking and submission of billing claims to payers

Treatment Intervention Preferences for a patient

Component values for calculations (e.g., systolic=120, diastolic=80)

Holds JWT authorization grant ids to prevent replay attacks

Dynamic patient, encounter, and transaction table properties created via LBF/LBT mechanism

Contains records of individuals in the system

Patient Clinical Care Plans

Patient issues list including allergies, medical problems, medications, medical devices, surgeries, and dental issues. Type of issue is in the type column.

Digital document templates that are assigned to patients

Encounter form that holds patient results for the PHQ9 assessment

Contains clinicinan comments regarding an amendment request

This table stores the history of present illness (HPI) information related to eye conditions.

Mapping table connecting documents to categories

Patient Immunizations

Internal and External prescription information

Patient Reminders that the Clinical Decision Support system is configured to run for this specific patient.

Work/School note written by a provider for a patient to provide documentation of their medical condition to their work or school

Contains actors in the system that are not patients. This includes providers, employees, and external organizations/contacts records as well as system processes. This does not include API actors

Encounter form that holds results for the Social Determinants of Health Screening Tool

Holds the digital author signature records for encounters and individual charted forms in the system.

Holds patient portal onsite credentials, username information and login meta information

Holds information about api refresh tokens.

Note categories used in the CAMOS note generator

Dynamic Field values that an installation can use to extend the data stored in the transactions table

Answer lists for preference codes

Review of Systems observations of the patient. Providers can use this form or the form_reviewofs

Store records last update per patient data process

The Clinical Quality Measures that are being applied to a specific patient to track. This is used in the clinical reminders system

Stores information related to eye prescriptions and dispensing for both the left (OS) and right (OD) eyes

Contains information about drugs that are dispensed/prescribed to patients. Also holds product inventory information if providers are internally managing their own drugs/medical supplies

Patients to be exported in the ehi_export_job_tasks

Patient Prior Authorization records

Information/questions that should be answered for a given procedure as requested by the procedure service provider. Created as part of the procedure compendium import/creation process.

Patients to be exported in the ehi_export_job

Contains a list of different insurance types or categories that an insurance company is related to. This type includes both public and private payer types

Main patient record that contains patient demographic information

Contains encounter claims billing options that modifies the claims submitted for this encounter

Holds records for Patient Appointment/Calendar information

Patient Insurance information

Contains records of contacts in the system

Represents the category grouping / track of the data element being tracked via the track_anything form

Record of the grouped fields used in dynamic layout based forms (LBF)

Links SDOH assessments to health concern conditions

Links clinical notes to procedure results/lab values

This table is used for recording eye refraction details, including sphere, cylinder, axis, prism, and base measurements.

Physical Exam Diagnosis for a physical exam that was conducted

Holds additional data about patient medications.

Patient chart note that holds notes created from a provider’s speech dictation software

Digital documents that have been assigned to a patient from a document_template that the patient has saved or submitted for review by clinical staff

Patient clinical instructions chart note

This table is used to store data related to anterior segment eye examinations, which typically include details about the front portion of the eye, such as the cornea, lens, iris, and pupil.

Holds Subjective, Objective, Assessment, and Plan (SOAP) notes

The table stores the actual results and findings from medical procedures and tests, such as laboratory tests, radiology reports, diagnostic imaging, and other clinical tests.

Record of a specific vital sign measurement, including its interpretation, and reason of the measurement

Patient Reminders configuration for Clinical Decision Support individual rule settings

Contains records of pharmacies that a patient uses, or that providers interact with

This table is related to recording visual acuity measurements for different eye conditions.

Represents the information related to a patient’s visit to a healthcare provider. This is different than an appointment as this table tracks the actual service of care

Telemetry Event Data

Group encounter form for tracking the attendance of therapy participants to a group session encounter

Patient asynchronous messages to and from clinical staff

Accounts Receivable item entries in invoice/claim activity

Patient Reminders generated from the clinical decision support engine that are sent via a communication medium to the patient

Patient treatment plan form

Contains address records in the system

This table stores review of systems (ROS) information related to various aspects of the eye and its associated systems.

Contains information about a specific contact’s telecom method

Join table between form_vitals_calculation and form_vitals table representing the derivative observation relationship between the calculation and the source records

Links patient medical issues in the lists table with patient service encounters

This table is used for storing data related to posterior segment eye examinations, which typically involve the back of the eye, including the retina, optic disc, macula, and blood vessels.

Represents patient referrals, and transactional records for billing, legal, and requests from the patient or their physician

Patient clinical notes with support for USCDI V1 standardized note types

Holds questionnaires that providers or patients fill out for healthcare information collection and/or assessment.

Patient portal activity (document submission, and other activities) that requires review before they are accepted into the patient chart

This table is used to record information related to wearing eyeglasses or contact lenses.

Connects the patient participants to a therapy group

List of Master Docs to be signed

CAMOS patient chart sub categories inside a single category

Tracks a voided receipt or checkout for a patient

joins users or patient_data to facility table

This table holds eye related tasks for providing care to the patient.

fhir export jobs

Holds data on external procedures that exist outside of this EMR that were in a patient CCDA import

Patient chart forms that are connected to a patient’s encounter visit. Serves as the base record containing all of the common form encounter properties where each sub-type form has data records contained in a table that is named CONCAT(‘form_’,formdir)

Holds the eligible patient benefits for a specific insurance as received from an eligibility verification

User initiated export of patient electronic health info.

Records of patient vital sign assessment

Dynamic Field values that are part of the following forms: Demographics, Facility Specific User Information, History Form, and custom dynamically generated encounter forms