Tables

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

Represent groups of users in the system

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

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.

Holds questionnaire results for a patient

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

This table is used for recording external eye examination findings.

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

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

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

Insurance company

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

Patient Clinical Care Plans

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

Digital document templates that are assigned to patients

Encounter form that holds patient results for the PHQ9 assessment

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

Contains clinicinan comments regarding an amendment request

Patient Immunizations

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

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 patient portal onsite credentials, username information and login meta information

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

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

Note categories used in the CAMOS note generator

Individual observations for a specific immunization

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

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

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

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

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

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

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

Product/Drug sales to Patients

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

Patient billing records for billing codes - Used for Claims Processing

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

Patient Prior Authorization records

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

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.

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

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

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

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

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

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

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

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

Patient Insurance information

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.

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

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

Used for recording observations related to patients during medical encounters

Physical Exam Diagnosis for a physical exam that was conducted

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

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

Holds additional data about patient medications.

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

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 chart note that holds notes created from a provider’s speech dictation software

Patient clinical instructions chart note

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

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 Messages about the healthcare treatment of the patient

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.

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

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

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

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

Patient treatment plan form

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

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

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

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

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

Physical Examination clinical note

Clinical notes and comments for individual patient documents

Patient clinical notes with support for USCDI V1 standardized note types

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

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.

Encounter form that holds patient results for the GAD7 assessment

Connects the patient participants to a therapy group

CAMOS patient chart sub categories inside a single category

Contains all of the therapy groups that exist in the system

Tracks a voided receipt or checkout for a patient

Contains the types / categories a patient scheduled appointment can be

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

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

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

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 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)

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

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

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

Stores implementation plans for eye-related activities.

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