Data dictionary · Accumedic EHI Export Format

Every table that can appear in an Accumedic EHI export, grouped by subject area. Select a table to see its columns, types, keys and how its rows relate to the patient. Each export also contains manifest.json, which describes exactly the files, columns and types in that export and is authoritative for it.

Single in single-patient exportsPopulation in patient population exportsOn request population exports, when requested

Filter

01Patient identity & demographics

Table	Description	Exports
ACTORS reference		Single Population
ACTOR_IDS reference		Population
ACTOR_PHONES reference		Population
FAMILIES shared		Single Population
INSUREDS patient		Single Population
PATIENTS patient	The patient population: one row per patient account.	Single Population
PAT_ACTION_DATES patient	Key patient dates and notes: intake, last seen, recall, release of information, alert, billing and posting notes.	Single Population
PAT_CONTACTS patient	The patient's contacts (emergency contacts, family, employer, agencies).	Single Population
PAT_CONTACT_LINKS patient	Links between a patient and their contacts.	Single Population
PAT_CONTACT_PHONES patient		Single Population
PAT_DEMOGRAPHICS patient	Patient demographics: race, ethnicity, preferred language, gender identity, sexual orientation, religion, smoking status, military service, living situation and state identifiers.	Single Population
PAT_FINGERPRINTS patient	Patient fingerprint images used to verify identity (for example at medication dispensing).	Single Population
PAT_FLAGS patient	Patient status and preferences: active flag, deceased indicator, contact preferences, consents, risk flags, guarantor and legal representative.	Single Population
PAT_INTAKE patient		Single Population
PAT_NOTES patient		Single Population
PAT_OFFICE_LOCATIONS patient		Single Population
PAT_OLD_PEOPLE patient	Previous demographic records retained when patient records were merged.	Single Population
PAT_OLD_PHONES patient		Single Population
PAT_PHONES patient	Patient telephone numbers.	Single Population
PAT_PHOTOS patient	Patient photograph.	Single Population
PAT_PORTAL patient		Single Population
PAT_PORTAL_ADDITIONAL_ACCOUNTS patient		Single Population
PAT_PORTAL_FORMS patient		Single Population
PAT_PORTAL_PROGRAM_FORMS reference		Population
PAT_RESTRICTED_USERS patient		Single Population
PAT_UDFS patient		Single Population
PAT_USER_IDS patient		Single Population
PEOPLE patient	Names, addresses, contact details, date of birth, sex and identifiers for patients and related persons (subscribers, guarantors). In a single-patient export, rows for related persons contain only ACCOUNT and name columns.	Single Population
RELATIONSHIPS patient		Single Population

02Encounter forms & clinical notes

Table	Description	Exports
EMR_ENCOUNTERS patient	Clinical encounters (visits and documentation sessions). IMAGE_BODY holds the signed note as a PDF.	Single Population
EMR_ENCOUNTERS_120_DAY_SERVICES_PLAN_REVIEW patient		Single Population
EMR_ENCOUNTERS_ADMISSIONS_DECISION patient		Single Population
EMR_ENCOUNTERS_ADMISSION_AND_DISCHARGE_PLAN patient		Single Population
EMR_ENCOUNTERS_ADMISSION_DECISION_REASONS patient		Single Population
EMR_ENCOUNTERS_ADMISSION_PAS_64 patient		Single Population
EMR_ENCOUNTERS_ARREST_HISTORY patient		Single Population
EMR_ENCOUNTERS_ASAM_ASSESSMENTS patient		Single Population
EMR_ENCOUNTERS_ASSESSED_NEEDS patient		Single Population
EMR_ENCOUNTERS_ASSESSMENT_PAS_64 patient		Single Population
EMR_ENCOUNTERS_ASSIGNMENT_BENEFITS patient		Single Population
EMR_ENCOUNTERS_ATTACHMENTS patient		Single Population
EMR_ENCOUNTERS_ATTENDANCE_STATUS patient		Single Population
EMR_ENCOUNTERS_AUDIT_LOG audit		On request
EMR_ENCOUNTERS_BHCC_PATIENT_INFO patient		Single Population
EMR_ENCOUNTERS_BLOOD_TESTS_LAB patient		Single Population
EMR_ENCOUNTERS_BRIEF_TREATMENT_NOTE patient		Single Population
EMR_ENCOUNTERS_CASE_CONFERENCE patient		Single Population
EMR_ENCOUNTERS_CA_INFO patient		Single Population
EMR_ENCOUNTERS_CC patient		Single Population
EMR_ENCOUNTERS_CHART_AMENDMENTS patient		Single Population
EMR_ENCOUNTERS_CHILD_IN_FOSTER_CARE patient		Single Population
EMR_ENCOUNTERS_CLIENT_ADMISSION_REPORT patient		Single Population
EMR_ENCOUNTERS_CLIENT_ASSESSMENT_REPORT patient		Single Population
EMR_ENCOUNTERS_CLIENT_DISCHARGE_REPORT patient		Single Population
EMR_ENCOUNTERS_CLINICAL_PRESENTATION patient		Single Population
EMR_ENCOUNTERS_CLINICAL_SUMMARY patient		Single Population
EMR_ENCOUNTERS_COLLATERAL_CONTACT_NOTE patient		Single Population
EMR_ENCOUNTERS_COMMUNICABLE_DISEASE_RA_01 patient		Single Population
EMR_ENCOUNTERS_COMPLEX_CARE_COORDINATION_NOTE patient		Single Population
EMR_ENCOUNTERS_CONFIDENTIALITY_NOTICE_TGI patient		Single Population
EMR_ENCOUNTERS_CONSENT_FORMS patient		Single Population
EMR_ENCOUNTERS_CONSENT_FOR_TREATMENT patient		Single Population
EMR_ENCOUNTERS_CONSENT_TO_PART_IN_OASAS patient		Single Population
EMR_ENCOUNTERS_CONSENT_TO_RELEASE_ALCOHOLISM patient		Single Population
EMR_ENCOUNTERS_CONSENT_TO_RELEASE_DRUG_ABUSE_INFO patient		Single Population
EMR_ENCOUNTERS_CONSENT_TO_RELEASE_PERSONAL_INFO patient		Single Population
EMR_ENCOUNTERS_DEMOGRAPHICS patient		Single Population
EMR_ENCOUNTERS_DEV_HX patient		Single Population
EMR_ENCOUNTERS_DIAG patient		Single Population
EMR_ENCOUNTERS_DISCHARGE patient		Single Population
EMR_ENCOUNTERS_DISCHARGE_CRIMINAL_RECORD patient		Single Population
EMR_ENCOUNTERS_DISCHARGE_CRITERIA patient		Single Population
EMR_ENCOUNTERS_DISCHARGE_EVALUATION_OF_GOALS patient		Single Population
EMR_ENCOUNTERS_DISCHARGE_NOTE patient		Single Population
EMR_ENCOUNTERS_DISCHARGE_PLAN patient		Single Population
EMR_ENCOUNTERS_DISCHARGE_PLANNING patient		Single Population
EMR_ENCOUNTERS_DISCHARGE_RECORD_PAS_64 patient		Single Population
EMR_ENCOUNTERS_DISCHARGE_REFERRAL_RECOMMENDATIONS patient		Single Population
EMR_ENCOUNTERS_DISCHARGE_SUBSTANCE_REPORTED patient		Single Population
EMR_ENCOUNTERS_DISCHARGE_SUMMARY patient		Single Population
EMR_ENCOUNTERS_DRUGS_USED patient		Single Population
EMR_ENCOUNTERS_DSM patient		Single Population
EMR_ENCOUNTERS_DSM5_DIAGS patient		Single Population
EMR_ENCOUNTERS_DSM5_DIAG_SPECIFIERS patient		Single Population
EMR_ENCOUNTERS_DSM_5 patient		Single Population
EMR_ENCOUNTERS_DSM_AXIS_1 patient		Single Population
EMR_ENCOUNTERS_DSM_AXIS_2 patient		Single Population
EMR_ENCOUNTERS_DSM_AXIS_3 patient		Single Population
EMR_ENCOUNTERS_DSM_AXIS_4 patient		Single Population
EMR_ENCOUNTERS_DSM_AXIS_5 patient		Single Population
EMR_ENCOUNTERS_DSM_V patient		Single Population
EMR_ENCOUNTERS_EARLY_INTERVENTION_TX patient		Single Population
EMR_ENCOUNTERS_EDU_DETAILS patient		Single Population
EMR_ENCOUNTERS_EDU_VOC_PROGRAMS patient		Single Population
EMR_ENCOUNTERS_ENC_MED_LOG patient		Single Population
EMR_ENCOUNTERS_EXAM patient		Single Population
EMR_ENCOUNTERS_EXAM_BACK patient		Single Population
EMR_ENCOUNTERS_EXAM_KNEE patient		Single Population
EMR_ENCOUNTERS_EXAM_NECK patient		Single Population
EMR_ENCOUNTERS_EXAM_SHOULDER patient		Single Population
EMR_ENCOUNTERS_FAM_DETAILS patient		Single Population
EMR_ENCOUNTERS_FHX patient		Single Population
EMR_ENCOUNTERS_FORM_SIGNATURES patient		Single Population
EMR_ENCOUNTERS_FUNCTIONAL_STATUS patient		Single Population
EMR_ENCOUNTERS_GAMPRO patient		Single Population
EMR_ENCOUNTERS_GENERAL_INFORMATION patient		Single Population
EMR_ENCOUNTERS_GENERAL_NOTE patient		Single Population
EMR_ENCOUNTERS_GROUP_APPTS patient		Single Population
EMR_ENCOUNTERS_GROUP_NOTE patient		Single Population
EMR_ENCOUNTERS_GROUP_NOTE2 patient		Single Population
EMR_ENCOUNTERS_GROUP_PROGRESS_NOTE patient		Single Population
EMR_ENCOUNTERS_GROUP_PROGRESS_SUMMARY patient		Single Population
EMR_ENCOUNTERS_HA_HEALTH_ASSESSMENT patient		Single Population
EMR_ENCOUNTERS_HA_HEALTH_HISTORY_2021 patient		Single Population
EMR_ENCOUNTERS_HA_OTHER_AND_SUMMARY patient		Single Population
EMR_ENCOUNTERS_HEALTHIX_AUTHORIZATION patient		Single Population
EMR_ENCOUNTERS_HEALTH_HISTORY patient		Single Population
EMR_ENCOUNTERS_HOMEWORK patient		Single Population
EMR_ENCOUNTERS_HPI patient		Single Population
EMR_ENCOUNTERS_IMAGES patient		Single Population
EMR_ENCOUNTERS_IMAGE_ORDER_NOTES patient		Single Population
EMR_ENCOUNTERS_IMPAIRMENTS patient		Single Population
EMR_ENCOUNTERS_INCIDENTAL_NOTES patient		Single Population
EMR_ENCOUNTERS_INDICATORS patient		Single Population
EMR_ENCOUNTERS_INDIVIDUALIZED_TREATMENT_RECOVERY patient		Single Population
EMR_ENCOUNTERS_INDIVIDUAL_CONDITION patient		Single Population
EMR_ENCOUNTERS_INDIVIDUAL_PROGRESS_NOTE patient		Single Population
EMR_ENCOUNTERS_INDIVIDUAL_TX_REVIEW patient		Single Population
EMR_ENCOUNTERS_INITIAL_INTAKE patient		Single Population
EMR_ENCOUNTERS_INITIAL_TREATMENT_PLAN patient		Single Population
EMR_ENCOUNTERS_INITIAL_TREATMENT_PLAN_01 patient		Single Population
EMR_ENCOUNTERS_INITIAL_TREATMENT_PLAN_02 patient		Single Population
EMR_ENCOUNTERS_INPATIENT_TX patient		Single Population
EMR_ENCOUNTERS_INTAKE patient		Single Population
EMR_ENCOUNTERS_INTERVENTIONS patient		Single Population
EMR_ENCOUNTERS_JUSTIFICATION patient		Single Population
EMR_ENCOUNTERS_LAB_ORDER_GRID patient		Single Population
EMR_ENCOUNTERS_LEGAL_HX patient		Single Population
EMR_ENCOUNTERS_LEVEL_OF_CARE patient		Single Population
EMR_ENCOUNTERS_LEVEL_OF_CARE_TA4_01 patient		Single Population
EMR_ENCOUNTERS_LEVEL_OF_CARE_TA4_02 patient		Single Population
EMR_ENCOUNTERS_LIVING_WITH_WHO patient		Single Population
EMR_ENCOUNTERS_MARITAL_REL_HX patient		Single Population
EMR_ENCOUNTERS_MEDICAL_ASSESSMENT patient		Single Population
EMR_ENCOUNTERS_MEDICATION_LIST patient		Single Population
EMR_ENCOUNTERS_MEDICATION_LOG patient		Single Population
EMR_ENCOUNTERS_MEDICATION_ORDER patient		Single Population
EMR_ENCOUNTERS_MEDS_ADMIN patient		Single Population
EMR_ENCOUNTERS_MENTAL_STATUS patient		Single Population
EMR_ENCOUNTERS_MH_SYMPTOMS patient		Single Population
EMR_ENCOUNTERS_MH_TREATMENT_HISTORY patient		Single Population
EMR_ENCOUNTERS_MH_TREATMENT_PLAN patient		Single Population
EMR_ENCOUNTERS_MH_VISIT patient		Single Population
EMR_ENCOUNTERS_MILITARY_HX patient		Single Population
EMR_ENCOUNTERS_MINI_KID_SCREEN patient		Single Population
EMR_ENCOUNTERS_MINI_KID_SCREEN_1 patient		Single Population
EMR_ENCOUNTERS_MINI_KID_SCREEN_2 patient		Single Population
EMR_ENCOUNTERS_MINI_KID_SCREEN_3 patient		Single Population
EMR_ENCOUNTERS_MINI_KID_SCREEN_4 patient		Single Population
EMR_ENCOUNTERS_MMT_NOTES patient		Single Population
EMR_ENCOUNTERS_MODIFIED_MINI_1 patient		Single Population
EMR_ENCOUNTERS_MODIFIED_MINI_2 patient		Single Population
EMR_ENCOUNTERS_NON_BILLABLE_NOTE patient		Single Population
EMR_ENCOUNTERS_NON_BILLABLE_NOTE_1 patient		Single Population
EMR_ENCOUNTERS_NOTES patient		Single Population
EMR_ENCOUNTERS_NUTRITION_ASSESSMENT patient		Single Population
EMR_ENCOUNTERS_NYSCRI_ADMISSION patient		Single Population
EMR_ENCOUNTERS_NYSCRI_ASSESSED_NEEDS patient		Single Population
EMR_ENCOUNTERS_NYSCRI_BRIEF_MEDICAL_SCREENING patient		Single Population
EMR_ENCOUNTERS_NYSCRI_CHILDREN_ADOLESCENTS patient		Single Population
EMR_ENCOUNTERS_NYSCRI_CMA_ASSESSED_NEEDS patient		Single Population
EMR_ENCOUNTERS_NYSCRI_COMMUNICABLE_DISEASE_RISK patient		Single Population
EMR_ENCOUNTERS_NYSCRI_COORDINATION_OF_CARE patient		Single Population
EMR_ENCOUNTERS_NYSCRI_DIAGNOSIS patient		Single Population
EMR_ENCOUNTERS_NYSCRI_DISCHARGE patient		Single Population
EMR_ENCOUNTERS_NYSCRI_GROUP_PROGRESS_NOTE patient		Single Population
EMR_ENCOUNTERS_NYSCRI_IAP patient		Single Population
EMR_ENCOUNTERS_NYSCRI_INTAKE_ASSESSMENT patient		Single Population
EMR_ENCOUNTERS_NYSCRI_IPE patient		Single Population
EMR_ENCOUNTERS_NYSCRI_LEGAL_INVOLVEMENT_ADDEN patient		Single Population
EMR_ENCOUNTERS_NYSCRI_LEGAL_STATUS_ADDEN patient		Single Population
EMR_ENCOUNTERS_NYSCRI_MEDICATION patient		Single Population
EMR_ENCOUNTERS_NYSCRI_MEDICATION_LIST patient		Single Population
EMR_ENCOUNTERS_NYSCRI_MENTAL_HEALTH patient		Single Population
EMR_ENCOUNTERS_NYSCRI_MENTAL_STATUS_EXAM patient		Single Population
EMR_ENCOUNTERS_NYSCRI_MILITARY_AND_LEGAL patient		Single Population
EMR_ENCOUNTERS_NYSCRI_MILITARY_SERVICE patient		Single Population
EMR_ENCOUNTERS_NYSCRI_PERSONAL_INFO patient		Single Population
EMR_ENCOUNTERS_NYSCRI_PERSONAL_INFORMATION patient		Single Population
EMR_ENCOUNTERS_NYSCRI_PEU patient		Single Population
EMR_ENCOUNTERS_NYSCRI_PN patient		Single Population
EMR_ENCOUNTERS_NYSCRI_PREADMISSION_NOTE patient		Single Population
EMR_ENCOUNTERS_NYSCRI_PRESENTING_PROBLEM patient		Single Population
EMR_ENCOUNTERS_NYSCRI_PSYCHIATRIC_REHAB patient		Single Population
EMR_ENCOUNTERS_NYSCRI_PSYCHOPHARMACOLOGY patient		Single Population
EMR_ENCOUNTERS_NYSCRI_RISK_ASSESSMENT patient		Single Population
EMR_ENCOUNTERS_NYSCRI_SELF_ASSESSMENT patient		Single Population
EMR_ENCOUNTERS_NYSCRI_SUBSTANCE_USE patient		Single Population
EMR_ENCOUNTERS_NYSCRI_SUB_DSM patient		Single Population
EMR_ENCOUNTERS_NYSCRI_SUICIDE_AND_VIOLENCE patient		Single Population
EMR_ENCOUNTERS_NYSCRI_UPDATE patient		Single Population
EMR_ENCOUNTERS_NYSCRI_VOC_EDU_EMPLOY patient		Single Population
EMR_ENCOUNTERS_OASAS_GAMBLING_HISTORY patient		Single Population
EMR_ENCOUNTERS_OASAS_PAS_126_CONTINUING_CARE patient		Single Population
EMR_ENCOUNTERS_OASAS_PAS_26N patient		Single Population
EMR_ENCOUNTERS_OASAS_PAS_44N patient		Single Population
EMR_ENCOUNTERS_OASAS_PAS_44N_2024_UPDATED patient		Single Population
EMR_ENCOUNTERS_OASAS_PAS_45N patient		Single Population
EMR_ENCOUNTERS_OASAS_PAS_45N_2017 patient		Single Population
EMR_ENCOUNTERS_OASAS_PAS_61 patient		Single Population
EMR_ENCOUNTERS_OASAS_PAS_61N patient		Single Population
EMR_ENCOUNTERS_OASAS_PII_CONSENT patient		Single Population
EMR_ENCOUNTERS_OASAS_SUBSTANCE_ABUSE_DATA patient		Single Population
EMR_ENCOUNTERS_OASAS_SUBSTANCE_HISTORY patient		Single Population
EMR_ENCOUNTERS_OASAS_TELEPRACTICE_CONSENT patient		Single Population
EMR_ENCOUNTERS_OASAS_TRS_62 patient		Single Population
EMR_ENCOUNTERS_OCC_DETAILS patient		Single Population
EMR_ENCOUNTERS_OON_SERVICES_REQUEST patient		Single Population
EMR_ENCOUNTERS_PAIN_ASSESSMENT patient		Single Population
EMR_ENCOUNTERS_PARTICIPANT_PROGRESS_SUMMARY patient		Single Population
EMR_ENCOUNTERS_PARTICIPANT_SERVICES_PLAN patient		Single Population
EMR_ENCOUNTERS_PARTICIPANT_SERVICE_PLAN patient		Single Population
EMR_ENCOUNTERS_PAS101L_ESP patient		Single Population
EMR_ENCOUNTERS_PAS_101L patient		Single Population
EMR_ENCOUNTERS_PAS_44 patient		Single Population
EMR_ENCOUNTERS_PAS_65_PARTICIPANT_SERVICES_PLAN patient		Single Population
EMR_ENCOUNTERS_PATIENT_COGNITIVE_FUNCTION patient		Single Population
EMR_ENCOUNTERS_PATIENT_CONCERNS patient		Single Population
EMR_ENCOUNTERS_PATIENT_GOAL patient		Single Population
EMR_ENCOUNTERS_PATIENT_HEALTH_HISTORY patient		Single Population
EMR_ENCOUNTERS_PATIENT_HEALTH_HISTORY1 patient		Single Population
EMR_ENCOUNTERS_PATIENT_HIPAA_COMMUNICATION patient		Single Population
EMR_ENCOUNTERS_PATIENT_NOTE patient		Single Population
EMR_ENCOUNTERS_PATIENT_PLEDGE_CONFIDENTIALITY patient		Single Population
EMR_ENCOUNTERS_PATIENT_PROCEDURES patient		Single Population
EMR_ENCOUNTERS_PATIENT_PROGRAM_INFORMATION patient		Single Population
EMR_ENCOUNTERS_PATIENT_RULES_AND_RIGHTS patient		Single Population
EMR_ENCOUNTERS_PATIENT_SAFETY_PLAN patient		Single Population
EMR_ENCOUNTERS_PAT_MEDS patient		Single Population
EMR_ENCOUNTERS_PAT_MEDS_INFO patient		Single Population
EMR_ENCOUNTERS_PA_HISTORIES patient		Single Population
EMR_ENCOUNTERS_PA_SUBSTANCE patient		Single Population
EMR_ENCOUNTERS_PA_SUMMARY patient		Single Population
EMR_ENCOUNTERS_PEER_SUPPORT patient		Single Population
EMR_ENCOUNTERS_PERSONAL_HISTORY_RECORD_PAS_64 patient		Single Population
EMR_ENCOUNTERS_PMHX patient		Single Population
EMR_ENCOUNTERS_PRESCRIPTIONS patient		Single Population
EMR_ENCOUNTERS_PRE_ADMISSIONS patient		Single Population
EMR_ENCOUNTERS_PRIVACY_PRACTICES patient		Single Population
EMR_ENCOUNTERS_PROBLEMS patient		Single Population
EMR_ENCOUNTERS_PROGRAM_TRANSFER_RECORDS patient		Single Population
EMR_ENCOUNTERS_PROGRESS_NOTE patient		Single Population
EMR_ENCOUNTERS_PROGRESS_NOTES patient	Progress note text for an encounter.	Single Population
EMR_ENCOUNTERS_PROVIDERS_OF_NEEDED_SERVICES patient		Single Population
EMR_ENCOUNTERS_PSHX patient		Single Population
EMR_ENCOUNTERS_PSH_DEMOGRAPHIC patient		Single Population
EMR_ENCOUNTERS_PSH_FAMILY patient		Single Population
EMR_ENCOUNTERS_PSH_FINANCIAL_STATUS patient		Single Population
EMR_ENCOUNTERS_PSH_HEALTH patient		Single Population
EMR_ENCOUNTERS_PSH_LEGAL_STATUS patient		Single Population
EMR_ENCOUNTERS_PSH_LEISURE_SPIRITUALITY_STRENGTHS patient		Single Population
EMR_ENCOUNTERS_PSH_MEDICAL patient		Single Population
EMR_ENCOUNTERS_PSH_MENTAL_HEALTH patient		Single Population
EMR_ENCOUNTERS_PSH_MILITARY_EXPERIENCE patient		Single Population
EMR_ENCOUNTERS_PSH_RISK_ASSESSMENT patient		Single Population
EMR_ENCOUNTERS_PSH_SUMMARY patient		Single Population
EMR_ENCOUNTERS_PSP_90_DAY_REVIEW patient		Single Population
EMR_ENCOUNTERS_PSYCHIATRIC_EVALUATION patient		Single Population
EMR_ENCOUNTERS_PSYCHIATRIC_PROGRESS_NOTE patient		Single Population
EMR_ENCOUNTERS_PSYCHOSOCIAL_HISTORY_01 patient		Single Population
EMR_ENCOUNTERS_PSYCHOSOCIAL_HISTORY_02 patient		Single Population
EMR_ENCOUNTERS_PSYCHOSOCIAL_HISTORY_03 patient		Single Population
EMR_ENCOUNTERS_PSYCHOSOCIAL_HISTORY_04 patient		Single Population
EMR_ENCOUNTERS_PSYCHOSOCIAL_HISTORY_05 patient		Single Population
EMR_ENCOUNTERS_PSYCH_TESTING patient		Single Population
EMR_ENCOUNTERS_REFERRAL_RECORD_PAS_64 patient		Single Population
EMR_ENCOUNTERS_RISK_FACTORS patient		Single Population
EMR_ENCOUNTERS_RISK_MANAGEMENT patient		Single Population
EMR_ENCOUNTERS_RISK_SAFETY_PLAN patient		Single Population
EMR_ENCOUNTERS_ROS_ALLERGY patient		Single Population
EMR_ENCOUNTERS_ROS_CARDIO patient		Single Population
EMR_ENCOUNTERS_ROS_ENDOCRINE patient		Single Population
EMR_ENCOUNTERS_ROS_ENT patient		Single Population
EMR_ENCOUNTERS_ROS_EYES patient		Single Population
EMR_ENCOUNTERS_ROS_GASTRO patient		Single Population
EMR_ENCOUNTERS_ROS_GENERAL patient		Single Population
EMR_ENCOUNTERS_ROS_GENITO patient		Single Population
EMR_ENCOUNTERS_ROS_HEMATO patient		Single Population
EMR_ENCOUNTERS_ROS_MUSCULO patient		Single Population
EMR_ENCOUNTERS_ROS_NEURO patient		Single Population
EMR_ENCOUNTERS_ROS_PSYCH patient		Single Population
EMR_ENCOUNTERS_ROS_RESP patient		Single Population
EMR_ENCOUNTERS_ROS_SKIN patient		Single Population
EMR_ENCOUNTERS_ROUTING patient	Signature and review routing of an encounter, including signing dates.	Single Population
EMR_ENCOUNTERS_RULES_AND_REGULATIONS_TG patient		Single Population
EMR_ENCOUNTERS_SERVICE_PLAN_90_DAY_REVIEW patient		Single Population
EMR_ENCOUNTERS_SESSION_CONTENT patient		Single Population
EMR_ENCOUNTERS_SESSION_FORMAT patient		Single Population
EMR_ENCOUNTERS_SESSION_PARTICIPANTS patient		Single Population
EMR_ENCOUNTERS_SESSION_PROCESS patient		Single Population
EMR_ENCOUNTERS_SHX patient		Single Population
EMR_ENCOUNTERS_SIGNATURES patient		Single Population
EMR_ENCOUNTERS_SIGNATURE_BOX patient		Single Population
EMR_ENCOUNTERS_SIGN_OFF patient		Single Population
EMR_ENCOUNTERS_SOAP patient	Subjective, objective, assessment and plan sections of an encounter note.	Single Population
EMR_ENCOUNTERS_STRESSORS patient		Single Population
EMR_ENCOUNTERS_SUBSTANCE_ABUSE patient		Single Population
EMR_ENCOUNTERS_SUBSTANCE_USE patient		Single Population
EMR_ENCOUNTERS_SUBSTANCE_USE_TX_HX patient		Single Population
EMR_ENCOUNTERS_SUD_2_1_TX_EXPECTATIONS patient		Single Population
EMR_ENCOUNTERS_TELEHEALTH_SESSION_ETIQUETTE patient		Single Population
EMR_ENCOUNTERS_TELEHEALTH_SESSION_ETIQUTTE patient		Single Population
EMR_ENCOUNTERS_TELEPRACTICE_CONSENT patient		Single Population
EMR_ENCOUNTERS_TEMPLATES_REVIEW_STATUS patient		Single Population
EMR_ENCOUNTERS_THERAPIST patient		Single Population
EMR_ENCOUNTERS_TREATMENT_PLAN_REVIEW patient		Single Population
EMR_ENCOUNTERS_TRS_1 patient		Single Population
EMR_ENCOUNTERS_TRS_1_ESP patient		Single Population
EMR_ENCOUNTERS_TRS_2 patient		Single Population
EMR_ENCOUNTERS_TRS_2_BLANK patient		Single Population
EMR_ENCOUNTERS_TRS_2_CUSTOM_ESP patient		Single Population
EMR_ENCOUNTERS_TRS_2_ESP patient		Single Population
EMR_ENCOUNTERS_TRS_3 patient		Single Population
EMR_ENCOUNTERS_TRS_3_ESP patient		Single Population
EMR_ENCOUNTERS_TRS_62 patient		Single Population
EMR_ENCOUNTERS_TRS_62_ESP patient		Single Population
EMR_ENCOUNTERS_TRS_63 patient		Single Population
EMR_ENCOUNTERS_TRS_66 patient		Single Population
EMR_ENCOUNTERS_TRS_66_ESP patient		Single Population
EMR_ENCOUNTERS_TRS_AN patient		Single Population
EMR_ENCOUNTERS_TRS_AN_ESP patient		Single Population
EMR_ENCOUNTERS_TRS_SIGNATURES patient		Single Population
EMR_ENCOUNTERS_TRS_SIGNATURES_3 patient		Single Population
EMR_ENCOUNTERS_TX_ACTIONS patient		Single Population
EMR_ENCOUNTERS_TX_D_ACTIONS patient		Single Population
EMR_ENCOUNTERS_TX_GOALS patient		Single Population
EMR_ENCOUNTERS_TX_GOALS_GRID patient		Single Population
EMR_ENCOUNTERS_TX_OBJECTIVES patient		Single Population
EMR_ENCOUNTERS_TX_PLAN patient		Single Population
EMR_ENCOUNTERS_TX_PLANNING_OTHER patient		Single Population
EMR_ENCOUNTERS_TX_PLANNING_PRIMARY patient		Single Population
EMR_ENCOUNTERS_TX_PLAN_GOALS_AND_SERVICES patient		Single Population
EMR_ENCOUNTERS_TX_PLAN_PULL patient		Single Population
EMR_ENCOUNTERS_TX_PLAN_TEAM patient		Single Population
EMR_ENCOUNTERS_TX_REVIEW_INFORMATION patient		Single Population
EMR_ENCOUNTERS_TX_SERVICES patient		Single Population
EMR_ENCOUNTERS_UTILIZATION_REVIEW patient		Single Population
EMR_ENCOUNTERS_VITALS patient	Vital signs recorded during an encounter.	Single Population
EMR_ENCOUNTER_ACTIVITY_LOG patient		Single Population
EMR_ENCOUNTER_ADD_TEMPLATES patient		Single Population
EMR_SIGNED_ENCOUNTERS_DEV_HX patient		Single Population
EMR_SIGNED_ENCOUNTERS_FHX patient		Single Population
EMR_SIGNED_ENCOUNTERS_LEGAL_HX patient		Single Population
EMR_SIGNED_ENCOUNTERS_MARITAL_REL_HX patient		Single Population
EMR_SIGNED_ENCOUNTERS_MILITARY_HX patient		Single Population
EMR_SIGNED_ENCOUNTERS_PMHX patient		Single Population
EMR_SIGNED_ENCOUNTERS_PSHX patient		Single Population
EMR_SIGNED_ENCOUNTERS_SHX patient		Single Population

03Problems, diagnoses & assessments

Table	Description	Exports
ASSESSMENT_TOOLS reference		Single Population
ASSESSMENT_TOOL_CONCEPTS reference		Population
ASSESSMENT_TOOL_DETAILS reference		Single Population
ASSESSMENT_TOOL_SCORE_CATEGORIES reference		Single Population
ASSESSMENT_TOOL_SCORE_GROUPS reference		Population
ASSESSMENT_TOOL_SCORE_TYPES reference		Population
ASSESSMENT_TOOL_SCORE_TYPE_DETAILS reference		Single Population
ASSESSMENT_TOOL_SCORING reference		Population
CLAIM_DIAGS patient		Single Population
CLAIM_DIAGS_OLD patient		Single Population
DIAGNOSIS reference		Population
DIAGNOSIS_CODES reference		Population
DIAG_CLASSES reference		Population
DSM5_CLASSES reference		Population
DSM5_DISORDERS reference		Single Population
DSM5_DISORDER_SPECIFIERS_LINK reference		Population
DSM5_SPECIFIERS reference		Population
DSM5_SPECIFIER_CHOICES reference		Single Population
DSM5_SUB_CLASSES reference		Population
EMR_NC_PATIENTDIAGNOSIS patient		Single Population
EMR_ORDER_DIAGNOSIS_CODES patient		Single Population
EMR_PATIENT_ASSESSMENTS patient		Single Population
EMR_PATIENT_ASSESSMENT_CATEGORIZED_SCORES patient		Single Population
EMR_PATIENT_ASSESSMENT_DETAILS patient		Single Population
EMR_PATIENT_ASSESSMENT_DETAIL_SCORES patient		Single Population
EMR_PATIENT_PROTOCOL_ASSESSMENT_SCHEDULE patient		Single Population
EMR_PROBLEMS reference		Population
EMR_PROBLEMS_LIST patient	The patient's problem list with ICD and SNOMED CT codes, onset and resolution dates.	Single Population
EMR_PROBLEM_CATEGORIES reference		Population
EMR_PROTOCOL_DRUG_ASSESSMENT_DOSE_RULES reference		Population
EMR_PROTOCOL_DRUG_ASSESSMENT_SCHEDULE reference		Population
EMR_TX_PROBLEM_STATUS reference		Population
ENCOUNTER_DIAGS patient		Single Population
FUNCTIONAL_AREAS reference		Population
FUNCTIONAL_AREA_TYPES reference		Population
MCSILVER_DIAGNOSIS_CODES reference		Population
MCSILVER_DIAG_CATEGORIES reference		Population
PAT_DIAGS patient		Single Population
PAT_PROGRAMS_ASSESSED_NEEDS patient		Single Population
PAT_PROGRAMS_DSM5_DIAGS patient		Single Population
PAT_PROGRAMS_DSM5_DIAG_SPECIFIERS patient		Single Population
PAT_PROGRAMS_DSM_1 patient		Single Population
PAT_PROGRAMS_DSM_2 patient		Single Population
PAT_PROGRAMS_DSM_3 patient		Single Population
PAT_PROGRAMS_DSM_4 patient		Single Population
PAT_PROGRAMS_DSM_5 patient		Single Population
PAT_PROGRAMS_PROBLEMS patient		Single Population
PCODE_DIAGS reference		Population
PROBLEM reference		Single Population
PROBLEMGROUP reference		Population
V_ASSESSMENT_TOOL_INCOMPLETE_REASONS reference		Single Population
V_PICIS_PRESENTINGPROBLEMS reference		Single Population

04Medications, allergies, immunizations, devices

Table	Description	Exports
EMR_DRUG_TAPER_PROTOCOLS reference		Single Population
EMR_MAR_SCHEDULES patient	Medication administration record: scheduled and administered doses.	Single Population
EMR_MAR_SHIFTS reference		Population
EMR_MAR_STATUS_CODES reference		Single Population
EMR_MEDICATION_PROMPTS reference		Population
EMR_NC_PATIENTALLERGIES patient		Single Population
EMR_PATIENT_ALLERGIES patient	Allergies and intolerances, reactions and severity.	Single Population
EMR_PATIENT_DRUG_PROTOCOLS patient		Single Population
EMR_PATIENT_IMMUNIZATION patient	Immunizations administered or reported (CVX coded).	Single Population
EMR_PATIENT_IMMUNIZATION_VIS patient		Single Population
EMR_PATIENT_IMPLANTABLE_DEVICES patient	Implantable devices (UDI).	Single Population
EMR_PATIENT_MEDICATIONS patient	The patient's medication list and prescriptions (RxNorm coded).	Single Population
EMR_PATIENT_MEDICATION_HISTORY patient		Single Population
IMPLANTABLE_DEVICES reference		Single Population
IMPLANTABLE_DEVICE_GMDN_TERMS reference		Population
IMPLANTABLE_DEVICE_SNOMED reference		Population
NCI_MEDICATIONROUTE reference		Population
V_IMMUNIZATION_FINANCIAL_CLASS reference		Single Population
V_IMMUNIZATION_REFUSAL_REASON reference		Single Population
V_IMMUNIZATION_RESOURCES reference		Single Population
V_IMPLANTABLE_DEVICE_BODY_SITES_SNOMED reference		Single Population
V_IMPLANTABLE_DEVICE_BODY_SITES_UDI reference		Single Population
V_PICIS_DRUGMETHOD reference		Single Population
V_PICIS_DRUGSFREQ reference		Single Population
V_PICIS_DRUGUSED reference		Single Population

05Lab orders & results

Table	Description	Exports
EMR_ORDERS patient	Laboratory and diagnostic orders.	Single Population
EMR_ORDER_AFP patient		Single Population
EMR_ORDER_AOE patient		Single Population
EMR_ORDER_BODY_SITES patient		Single Population
EMR_ORDER_BODY_SITE_MODIFIERS patient		Single Population
EMR_ORDER_COURTESY_COPY patient		Single Population
EMR_ORDER_CYTOLOGY patient		Single Population
EMR_ORDER_DETAILS patient		Single Population
EMR_ORDER_GUARANTOR patient		Single Population
EMR_ORDER_HEAVY_METALS patient		Single Population
EMR_ORDER_INSURANCES patient		Single Population
EMR_ORDER_RESULTS patient	Laboratory results (LOINC coded) with values, units, reference ranges and abnormal flags.	Single Population
EMR_ORDER_RESULTS_ATTACHMENTS patient		Single Population
EMR_ORDER_RESULTS_AUDIT patient		Single Population
EMR_ORDER_SIGNATURES patient		Single Population
EMR_TESTS reference		Population
EMR_TEST_GROUPS reference		Population
EMR_TEST_GROUPS_MASTER reference		Population
EMR_TEST_GROUP_DETAILS reference		Population
EMR_TEST_OBSERVATIONS reference		Population
PAT_LAB_RESULTS patient		Single Population
PAT_LAB_RESULT_DETAILS patient		Single Population

06Treatment plans, protocols & standing orders

Table	Description	Exports
EMR_FORM_LINK_ENC_TX_GOALS patient		Single Population
EMR_FORM_LINK_ENC_TX_OBJECTIVES patient		Single Population
EMR_MASTER_TEMPLATE_TX_TEMPLATE_CONFIG reference		Population
EMR_PATIENT_PROTOCOLS patient		Single Population
EMR_PATIENT_PROTOCOL_ALERTS patient		Single Population
EMR_PROTOCOLS reference		Single Population
EMR_REFERRALS_IN_NEEDS patient		Single Population
EMR_TX_METHOD_OF_SERVICE reference		Population
EMR_TX_TEMPLATE_CONFIG reference		Population
EMR_V_GOAL_TYPES reference		Single Population
EMR_V_PROTOCOL_ALERT_TYPES reference		Single Population
EMR_V_TX_SEVERITY reference		Single Population
GOAL reference		Single Population
PAT_ACCIDENT_TX_PLANS patient		Single Population
PAT_EMR_TREATMENT_PLAN patient		Single Population
TREATMENT_PLAN_ACTIONS reference		Population
TREATMENT_PLAN_GOALS reference		Population
TREATMENT_PLAN_OBJECTIVES reference		Population
V_TREATMENT_TYPES reference		Single Population
V_TX_REVIEW_DUE_DAYS reference		Single Population
W_GOALS reference		Single Population
W_GOAL_GROUPS reference		Population

07Programs, episodes, referrals & nursing

Table	Description	Exports
EMR_OUTBOUND_REFERRALS patient		Single Population
EMR_REFERRALS_IN patient		Single Population
EMR_REFERRALS_IN_ATTACHMENTS patient		Single Population
EMR_REFERRALS_IN_HUG patient		Single Population
EMR_REFERRALS_IN_OVERDOSES patient		Single Population
EMR_REFERRALS_IN_PSYCH_EMERGENCIES patient		Single Population
EMR_REFERRAL_IN_IMAGES patient		Single Population
NURSING_CHECK patient		Single Population
NURSING_CHECK_MASTER reference		Single Population
NURSING_PROGRAM_LOCATIONS_ROOMS reference		Population
NURSING_PROGRAM_LOCATION_ROOM_BEDS reference		Population
NURSING_RISKS reference		Population
NURSING_SHIFTS patient		Single Population
NURSING_SHIFT_CHECKS patient		Single Population
NURSING_SHIFT_NOTES patient		Single Population
NURSING_VITALS patient		Single Population
PAT_EMR_OUTBOUND_REFERRALS patient		Single Population
PAT_PROGRAMS patient	Program admissions (episodes of care): program, admission and discharge, status and presenting problem.	Single Population
PAT_PROGRAMS_LEVEL_OF_CARE patient		Single Population
PAT_PROGRAMS_POA patient		Single Population
PAT_PROGRAMS_SNAPS patient		Single Population
PAT_PROGRAMS_SYMPTOMS patient		Single Population
PAT_REF_PROVIDERS patient		Single Population
PAT_SVC_PROVIDERS patient		Single Population
PROGRAM_CLASSES reference		Population
PROGRAM_CODES reference	Treatment programs offered by the practice.	Single Population
PROGRAM_CODE_SHIFTS reference		Population
PROGRAM_FORMS reference		Population
PROGRAM_SERVICES reference		Single Population
PROGRAM_STATUS_CODES reference		Single Population
REFERRALS patient		Single Population
REFERRAL_DESTINATIONS reference		Single Population
REFERRAL_DESTINATION_GROUPS reference		Population
REFERRAL_DESTINATION_GROUP_MEMBERS reference		Population
REFERRAL_DETAILS patient		Single Population
REFERRAL_SOURCES reference		Single Population
REFERRAL_SOURCE_GROUPS reference		Population
REFERRAL_SOURCE_GROUP_MEMBERS reference		Population
REFERRAL_SOURCE_PHONES reference		Population

08OTP / methadone dispensing

Table	Description	Exports
MMT_BOTTLE_IDS reference		Population
MMT_DISPENSE_LOCKS patient		Single Population
MMT_DISPENSING_BOTTLES reference		Single Population
MMT_DISPENSING_BOTTLE_ACTIONS patient		Single Population
MMT_DISPENSING_STATIONS reference		Single Population
MMT_DOSE_DETAILS patient	Opioid treatment program doses dispensed.	Single Population
MMT_DOSE_FORMS reference		Single Population
MMT_DOSE_IMAGES patient		Single Population
MMT_ORDERS patient	Opioid treatment program medication orders.	Single Population
MMT_ORDERS_PENDING_SIGNATURE patient		Single Population
MMT_ORDER_DETAILS patient		Single Population
MMT_ORDER_HOLDS patient		Single Population
MMT_ORDER_HOLD_TYPES reference		Single Population
MMT_ORDER_REVIEWS patient		Single Population
MMT_ORDER_SERVICES reference		Population
MMT_PUMPS reference		Single Population
MMT_REPLENISH_ORDERS reference		Population
MMT_REPLENISH_ORDER_DETAILS reference		Single Population
MMT_REPLENISH_ORDER_TOTES reference		Population
MMT_RETURN_TH_BOTTLES patient		Single Population
MMT_RETURN_TH_BOTTLE_IDS reference		Population
MMT_SCHEDULES reference		Single Population
MMT_SCHEDULE_DETAILS reference		Population
MMT_STAGES reference		Single Population
MMT_STOCK patient		Single Population
MMT_STOCK_ACTIONS reference		Single Population
MMT_STOCK_DEPLETIONS patient		Single Population
MMT_STOCK_LOCATIONS patient		Single Population
MMT_THERAPEUTIC_GUIDANCE patient		Single Population
MMT_TH_BOTTLES_LOG patient		Single Population
MMT_ZUBSOLV_DOSE_AMOUNTS reference		Population
TOXICOLOGY_POTENTIAL_DATES patient		Single Population
TOXICOLOGY_SCHEDULES patient		Single Population
TOXICOLOGY_SCHEDULE_DIAGS patient		Single Population
URINE_TESTS patient	Toxicology (urine drug screen) collections and results.	Single Population

09Specialty clinical (dental, optical, podiatry, chiro)

Table	Description	Exports
PAT_CHIROS patient		Single Population
PAT_CLASS_FINDINGS patient		Single Population
PAT_DENTALS patient		Single Population
PAT_OPTICALS patient		Single Population
PAT_PERMANENT_TEETH patient		Single Population
PAT_PODIATRICS patient		Single Population
PAT_POD_SITES patient		Single Population
PAT_PRIMARY_TEETH patient		Single Population
PAT_SYSTEMIC_COND patient		Single Population

10Documents, images & letters

Table	Description	Exports
EMR_DOCUMENTS_MASTER_IMAGES reference		Population
EMR_IMAGE_TYPES reference		Population
EMR_PATIENT_DOCUMENTS patient		Single Population
FORMS reference		Population
LETTERS reference		Single Population
PAT_IMAGES patient	Scanned and uploaded documents and images in the patient's chart.	Single Population
PAT_LETTERS patient	Letters generated for the patient.	Single Population
PAT_SIGNATURES patient		Single Population
SYSTEM_FORMS reference		Population
V_IMAGE_TYPES reference		Single Population

11Messaging, alerts, tasks & portal

Table	Description	Exports
AUDIT_HL7_MESSAGES audit		On request
EMR_ALERTS_DETAILS patient		Single Population
EMR_ALERTS_MASTER patient		Single Population
EMR_ALERT_RULES reference		Population
EMR_CLINICAL_DECISION_SUPPORT_RULES reference		Population
EMR_CLINICAL_DECISION_SUPPORT_RULE_MODIFIED reference		Population
EMR_MESSAGES_MASTER patient	Internal clinical messages about the patient.	Single Population
EMR_MESSAGE_ATTACHMENTS patient		Single Population
EMR_MESSAGE_RECIPIENTS patient		Single Population
EMR_TASKS_DETAILS patient		Single Population
EMR_TASKS_MASTER patient		Single Population
EMR_TASKS_ROLES patient		Single Population
EMR_TASKS_USERS patient		Single Population
EMR_USER_NOTIFICATIONS patient		Single Population
EMR_V_NOTIFICATION_TYPES reference		Single Population
HL7_CONTACT_TRANS reference		Population
HL7_EMPLOYMENT_STATUS_TRANS reference		Population
HL7_ETHNICITY_TRANS reference		Population
HL7_RACE_TRANS reference		Population
HL7_RECEIVER_LOG audit		On request
HL7_RELATIONSHIP_TRANS reference		Population
INTERFACE_LOG_PAT audit		On request
MISSING_TASKS_LIST patient		Single Population
PAT_EMR_MESSAGE_ATTACHMENTS patient		Single Population
PAT_EMR_MESSAGE_RECIPIENTS patient		Single Population
PORTAL_COMMUNICATION_LOG patient		Single Population
PORTAL_MESSAGES patient	Secure messages exchanged with the patient through the patient portal.	Single Population
PORTAL_MESSAGE_ATTACHMENTS patient		Single Population
PORTAL_MESSAGE_CONTACTS reference		Population
PORTAL_MESSAGE_RECIPIENTS patient		Single Population
SECURE_MESSAGES patient	Direct secure messages sent or received about the patient.	Single Population
SECURE_MESSAGE_ATTACHMENTS patient		Single Population
SECURE_MESSAGE_RECIPIENTS patient		Single Population

12Scheduling & attendance

Table	Description	Exports
APPOINTMENTS patient	Scheduled appointments and their status, provider, location, service and check-in information.	Single Population
APPOINTMENT_CLASSES reference		Single Population
APPT_HOLIDAYS reference		Population
APPT_IMAGES patient		Single Population
APPT_NUMBERS patient		Single Population
APPT_PAT_GROUPS shared		Single Population
APPT_PAT_GROUP_MEMBERS patient		Single Population
APPT_PAT_GROUP_WAIT_LIST patient		Single Population
APPT_PAYMENTS patient		Single Population
APPT_PAYORS patient		Single Population
APPT_REMINDER_RESULTS patient		Single Population
ATTENDANCES patient		Single Population
ATTENDANCE_ACTIVITIES patient		Single Population
ATTENDANCE_SERVICES patient		Single Population
CDT_HOURS patient		Single Population
EMR_PATIENT_STATUS patient		Single Population
HOLIDAYS reference		Population

13Billing: encounters, A/R, claims, remittance

Table	Description	Exports
ACCOUNTS_RECEIVABLE patient	Patient account invoices (one per billed service date or encounter); ACCOUNT is the responsible party.	Single Population
APGS patient		Single Population
APG_CODES reference		Single Population
APG_DETAILS patient		Single Population
AR_DUNNING_MESSAGES reference		Population
AR_INVOICE_NOTES patient		Single Population
AR_LINE_ITEMS patient	Charge lines on an invoice: procedure, diagnosis pointers, dates and units.	Single Population
AR_LINE_ITEM_DETAILS patient	Ledger transactions on a charge line: charges, payments, adjustments, write-offs and remittance codes.	Single Population
CLAIMA patient	Legacy claim staging records in the state Medicaid claim format.	Population
CLAIMS patient	Insurance claims (CMS-1500 / UB-04 / 837) for an invoice.	Single Population
CLAIM_BATCHES shared	Electronic claim batches (837 files) a claim was sent in.	Single Population
CLAIM_BATCH_DETAILS patient		Single Population
CLAIM_BATCH_EVENTS shared		Single Population
CLAIM_BATCH_MESSAGES shared		Population
CLAIM_BATCH_REPORTS shared		Population
CLAIM_BATCH_TRANSMISSION shared		Population
CLAIM_CLASSES reference		Single Population
CLAIM_ENCOUNTERS patient		Single Population
CLAIM_HISTORY patient		Single Population
CLAIM_HISTORY_OLD patient		Single Population
CLAIM_NOTES patient		Single Population
CLAIM_PAYMENTS patient		Single Population
CLAIM_PAYORS patient		Single Population
CLAIM_POA patient		Single Population
CLAIM_PROCESSORS reference	Directory of claim clearinghouses and payers that electronic claims are sent to.	Single Population
CLAIM_PROCESSOR_PHONES reference		Population
CLAIM_PROCESSOR_WEB_ACTIONS reference		Population
CLAIM_PROCS patient		Single Population
ENCOUNTERS patient	Billing encounters (superbills) linking appointments to charges.	Single Population
ENCOUNTER_CLASSES reference		Population
ENCOUNTER_NOTES patient		Single Population
ENCOUNTER_NUMBERS patient		Single Population
ENCOUNTER_PROCS patient		Single Population
INVOICE_NUMBERS patient		Single Population
NEIC_CLAIM_STATUS_CODES reference		Population
NEIC_STATUS_RECORDS patient		Single Population
PAT_ACCIDENTS patient		Single Population
PAT_ACCIDENT_ATTORNEYS patient		Single Population
PAT_AMB_TRIPS patient		Single Population
PAT_HOSPITAL_DATES patient		Single Population
PAT_LIABILITIES patient		Single Population
PAT_LIABILITY_EXPENSES patient		Single Population
PAT_REV_CODES patient		Single Population
PAT_SERVICES patient		Single Population
PAT_SLIDING_SCALES patient		Single Population
PAT_STATEMENT_DATES patient	Patient statements sent and balances shown.	Single Population
RCM_CASES reference		Single Population
RCM_CASE_APPTS patient		Single Population
RCM_CASE_INVOICES patient		Single Population
RCM_INTERFACE_LOG audit		On request
RCM_ISSUE_TYPES reference		Single Population
RCM_PAYMENT_LOG audit		On request
RCM_RESOLUTION_TYPES reference		Single Population
REMITTANCES shared	Electronic remittance advice (835) files received.	Single Population
REMITTANCE_DETAILS patient	Payments and adjustments reported for the patient's claims in an 835 file.	Single Population
REMITTANCE_SETS shared		Single Population
REMIT_CODES reference		Single Population
REMIT_REMARK_CODES reference		Single Population

14Insurance, eligibility & authorizations

Table	Description	Exports
AUTHORIZATIONS patient	Payer authorizations for services.	Single Population
AUTHORIZATION_DETAILS patient		Single Population
ELIGIBILITY_NUMBERS patient		Single Population
ELIG_REQUESTS patient	Insurance eligibility inquiries (270) and responses (271).	Single Population
ELIG_RESPONSES patient		Single Population
INSURANCE_POLICIES patient	Insurance policies: payer, policy and group numbers, effective dates and policy holder.	Single Population
INSURANCE_POLICY_DATES patient		Single Population
MC_PLANS reference		Population
MC_PLAN_DETAILS reference		Population
MC_PLAN_NON_COVD_PROCS reference		Population
MMIS_SVC_AUTH_EXCEPT_CODES reference		Single Population
MMIS_SVC_AUTH_EXCEPT_SPECIALTIES reference		Population
MMIS_SVC_AUTH_EXEMPT reference		Population
PAT_INSURANCES patient	The patient's insurance coverage, in order of priority, and their relationship to the policy holder.	Single Population
PAYORS reference	Directory of insurance payers.	Single Population
PAYOR_CLASSES reference		Population
PAYOR_CONTACTS patient		Single Population
PAYOR_PHONES reference		Population
PAYOR_PROV_RATE_CLASSES reference		Population
SVC_AUTH_NUMBERS patient		Single Population
SVC_AUTH_REQUESTS patient		Single Population
SVC_AUTH_RESPONSES patient		Single Population

15Codes & lookups

Table	Description	Exports
CVX_CODES reference		Single Population
EMR_V_APPT_STATUS reference		Single Population
EMR_V_APPT_STATUS_MISSED reference		Single Population
EMR_V_BODY_SITES reference		Population
EMR_V_BODY_SITE_MODIFIERS reference		Population
EMR_V_CATEGORIES_MASTER reference		Single Population
EMR_V_CATEGORY_DETAILS reference		Single Population
EMR_V_CLIENT_PROGRESS_RATING reference		Single Population
EMR_V_DLA_ICD10_SI_CROSSWALK reference		Single Population
EMR_V_DLA_MGAF_CROSSWALK reference		Single Population
EMR_V_ENC_ACTIVITY_TYPES reference		Single Population
EMR_V_MASTER_TEMPLATE_CLASSES reference		Single Population
EMR_V_RESULT_ERROR_CODES reference		Single Population
EMR_V_TEST_TRANSPORT_CONDITIONS reference		Single Population
ICD10_GEMS reference		Population
ICD9_GEMS reference		Population
LOINC reference		Population
LOINC_RAW reference		Population
NDC_CODES reference		Single Population
NDC_PACKAGES reference		Single Population
RXN_CONCEPTS reference		Population
SCT_CONCEPTS reference		Population
SCT_CROSSMAPS_ICD9 reference		Population
SCT_CROSSMAPTARGETS_ICD9 reference		Population
SCT_DESCRIPTIONS reference		Population
SCT_RELATIONSHIPS reference		Population
US_STATES reference		Single Population
V_ABNORMAL_FLAG_CODES reference		Single Population
V_ABSENCE_REASONS reference		Single Population
V_ACCIDENT reference		Single Population
V_ADJUSTMENT_TYPES reference		Single Population
V_ADMIN_METHODS reference		Single Population
V_ADMIN_SITES reference		Single Population
V_ADMISSION_SOURCE reference		Single Population
V_ADMISSION_TYPE reference		Single Population
V_AR_REASON_CODE reference		Single Population
V_AVAILABLE_TIMES reference		Single Population
V_BLOOD_TYPES reference		Single Population
V_CDA_LANGUAGES reference		Single Population
V_CLAIM_BILLING_CODE reference		Single Population
V_CLAIM_RECEIVER reference		Single Population
V_CLASS_FINDINGS reference		Single Population
V_CODING_METHOD reference		Single Population
V_CONTACT_PREFERENCES reference		Single Population
V_CONTACT_TYPES reference		Single Population
V_COUNTIES reference		Single Population
V_EDUCATION_LEVEL reference		Single Population
V_ELIG_INFO_CODES reference		Single Population
V_ELIG_REJECT_CODES reference		Single Population
V_ELIG_SVC_TYPE_CODES reference		Single Population
V_EMPLOYMENT_STATUS reference		Single Population
V_ETHNICITIES reference		Single Population
V_EXPENSE_TYPES reference		Single Population
V_EYE_COLORS reference		Single Population
V_FACILITY_TYPES reference		Single Population
V_GENDER_IDENTITY reference		Single Population
V_HAIR_COLORS reference		Single Population
V_HOMICIDAL_RISK_LEVEL reference		Single Population
V_IMPAIRMENT_TYPES reference		Single Population
V_INCOME_SOURCE reference		Single Population
V_INJURY_TYPES reference		Single Population
V_LANGUAGES reference		Single Population
V_LANGUAGES_ISO_639_2 reference		Single Population
V_LANGUAGE_ABILITY_MODES reference		Single Population
V_LANGUAGE_PROFICIENY_TYPES reference		Single Population
V_LEVEL_OF_CARE reference		Single Population
V_LIABILITY_TYPES reference		Single Population
V_LIVING_SITUATION reference		Single Population
V_MANNER_DEATH reference		Single Population
V_MARITAL_STATUS reference		Single Population
V_MILITARY_STATUS reference		Single Population
V_MMT_STOCK_SUPPLY reference		Single Population
V_MM_ABORT_STERIL reference		Single Population
V_MM_ACCIDENT reference		Single Population
V_MM_CATEGORY_OF_SERVICE reference		Single Population
V_MM_CHAP_REFERRAL reference		Single Population
V_MM_CLINIC_SPECIALTY reference		Single Population
V_MM_LICENSE_TYPE reference		Single Population
V_MM_OTHER_INSURANCE reference		Single Population
V_MM_PATSTAT_A reference		Single Population
V_MM_PATSTAT_B reference		Single Population
V_MM_PLACE_OF_SERVICE reference		Single Population
V_MM_REMIT_CODES reference		Single Population
V_MM_SPECIALTY reference		Single Population
V_NAME_PREFIX reference		Single Population
V_NAME_SUFFIX reference		Single Population
V_NEIC_HBOC_SPECIALTIES reference		Single Population
V_NOTE_TYPES reference		Single Population
V_NURSING_CHECK_DISPOSITION reference		Single Population
V_NURSING_CHECK_STATUS reference		Single Population
V_OASAS_ACHIEVE_STATUS reference		Single Population
V_OASAS_ADDICTION_STATUS reference		Single Population
V_OASAS_ADMISSION_DISPOSITION reference		Single Population
V_OASAS_ASIAN_ORIGIN reference		Single Population
V_OASAS_COA_COSA reference		Single Population
V_OASAS_COA_COSA_2024 reference		Single Population
V_OASAS_COUNTY_OF_RESIDENCE reference		Single Population
V_OASAS_CURRENT_SCHEDULE reference		Single Population
V_OASAS_DISCHARGE_DISPOSITION reference		Single Population
V_OASAS_DISCHARGE_DISPOSITIONS reference		Single Population
V_OASAS_DISCHARGE_REFERRAL_CATEGORIES reference		Single Population
V_OASAS_DISCHARGE_STATUS reference		Single Population
V_OASAS_EDUCATION_LEVEL reference		Single Population
V_OASAS_ELEMENT_OF_CARE reference		Single Population
V_OASAS_EMPLOYMENT_STATUS reference		Single Population
V_OASAS_FREQUENCY reference		Single Population
V_OASAS_GENDER_IDENTITY reference		Single Population
V_OASAS_GENDER_IDENTITY_2024 reference		Single Population
V_OASAS_HISPANIC_ORIGIN reference		Single Population
V_OASAS_LENGTH_OF_EMPLOYMENT reference		Single Population
V_OASAS_LIVING_ARRANGEMENTS reference		Single Population
V_OASAS_MARITAL_STATUS reference		Single Population
V_OASAS_MILITARY_STATUS reference		Single Population
V_OASAS_ORIENTATION_TO_CHANGE reference		Single Population
V_OASAS_ORIENTATION_TO_CHANGE_2024 reference		Single Population
V_OASAS_PACIFIC_ORIGIN reference		Single Population
V_OASAS_PRIMARY_INCOME_SOURCE reference		Single Population
V_OASAS_PRIMARY_LANGUAGE reference		Single Population
V_OASAS_PRIMARY_PAYMENT_SOURCE reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_CD reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_CJ reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_EMP_EDU reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_EMP_EDU_2024 reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_HEALTHCARE_2024 reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_HEALTH_CARE reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_PREVENTION reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_RECOVERY_SUPP_SVCS reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_SELFFAMOTHER reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_SFO_2024 reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_SOCIAL_SVCS reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_SOCIAL_SVCS_2024 reference		Single Population
V_OASAS_PRINCIPAL_REFERRAL_SOURCE_SUD reference		Single Population
V_OASAS_RACE reference		Single Population
V_OASAS_REASON_FOR_HOSPITALIZATION reference		Single Population
V_OASAS_REFERRAL_DISPOSITION reference		Single Population
V_OASAS_REINTEGRATION_SETTING reference		Single Population
V_OASAS_RESIDENCE_TYPE reference		Single Population
V_OASAS_ROUTE reference		Single Population
V_OASAS_SEXUAL_ORIENTATION reference		Single Population
V_OASAS_SEXUAL_ORIENTATION_2024 reference		Single Population
V_OASAS_SPECIAL_PROJECT reference		Single Population
V_OASAS_SUBSTANCE reference		Single Population
V_OASAS_SUBSTANCES reference		Single Population
V_OASAS_TRANSGENDER reference		Single Population
V_OASAS_TYPE_OF_RESIDENCE reference		Single Population
V_OCCUPATIONS reference		Single Population
V_OCCUPATIONS_BUS reference		Single Population
V_OCCUPATIONS_TRAIN reference		Single Population
V_ORDER_BILL_CODES reference		Population
V_ORDER_CONTROL_CODES reference		Single Population
V_ORDER_DETAIL_STATUS_CODES reference		Single Population
V_ORDER_RESULT_STATUS_CODES reference		Single Population
V_ORG_TYPE reference		Single Population
V_PATSTAT_UB reference		Single Population
V_PAT_CONTACT_RELATIONSHIPS reference		Single Population
V_PAT_INS_RELATIONSHIPS reference		Single Population
V_PAT_SIG_RELATIONSHIPS reference		Single Population
V_PAT_TIERS reference		Single Population
V_PAYMENT_SOURCE reference		Single Population
V_PAYMENT_TYPES reference		Single Population
V_PHONE_TYPES reference		Single Population
V_PICIS_CURRENTRESIDENCE reference		Single Population
V_PICIS_DISABILITY reference		Single Population
V_PICIS_EMPLOYMENTTYPE reference		Single Population
V_PICIS_INCARCERATIONSTATUS reference		Single Population
V_PICIS_LEGALSTATUS reference		Single Population
V_PICIS_LEVELOFCARE reference		Single Population
V_PICIS_MODE reference		Single Population
V_PICIS_PLACEMENT reference		Single Population
V_PICIS_PREFERREDLANGUAGE reference		Single Population
V_PICIS_REFERRALS reference		Single Population
V_PLACE_OF_SERVICE reference		Single Population
V_PLANNED_CARE reference		Single Population
V_PROC_MODIFIERS reference		Single Population
V_RACES reference		Single Population
V_RACES_CDC reference		Single Population
V_RELIGIONS reference		Single Population
V_RPT_SUBQUERY_TABLES reference		Single Population
V_SCHOOL_DISTRICTS reference		Single Population
V_SEXUAL_ORIENTATION reference		Single Population
V_SMOKING_STATUS reference		Single Population
V_SNOMED_PROCEDURES reference		Single Population
V_SOCIOCULTURAL reference		Single Population
V_SPECIALTY reference		Single Population
V_SPECIMEN_ACTION_CODES reference		Single Population
V_SPECIMEN_REJECT_CODES reference		Single Population
V_STUDENT_STATUS reference		Single Population
V_SUICIDAL_RISK_LEVEL reference		Single Population
V_SYSTEMIC_CONDITIONS reference		Single Population
V_TIME reference		Single Population
V_TYPE_OF_SERVICE reference		Single Population
V_UCUM reference		Single Population
V_UDF_CAPTIONS reference		Single Population
V_VALUE_TYPE_CODES reference		Single Population

16Templates & form metadata

Table	Description	Exports
EMR_CONTROL_TYPES reference		Population
EMR_DATA_ELEMENT_MASTER reference	Definitions of the fields on clinical forms: name, description, units, and the TABLE_NAME and COLUMN_NAME where each field's value is stored.	Single Population
EMR_FORM_LINK_ENC_ENC patient		Single Population
EMR_FORM_RULES reference		Single Population
EMR_FORM_RULE_HISTORY patient		Single Population
EMR_FORM_TYPES reference		Population
EMR_GENERIC_GRID_DATA_ELEMENTS reference		Population
EMR_GENERIC_GRID_DETAILS reference		Population
EMR_GENERIC_GRID_KEY_DATA reference		Population
EMR_GENERIC_LOOKUP_FIELDS reference		Population
EMR_GOC_KEY_VALUES reference		Population
EMR_GOC_LIST reference		Population
EMR_GOC_LIST_DETAILS reference		Population
EMR_LINK_TABLES reference		Population
EMR_MASTER_TEMPLATES reference	Clinical form (note template) definitions; EMR_ENCOUNTERS.MASTER_TEMPLATE_ID identifies the form used for an encounter.	Single Population
EMR_MASTER_TEMPLATE_ADD_ONS reference		Population
EMR_MASTER_TEMPLATE_DETAILS reference	Which sections appear on each clinical form, in display order.	Single Population
EMR_MASTER_TEMPLATE_NAMES reference		Population
EMR_MASTER_TEMPLATE_PACKAGE_DOCS reference		Population
EMR_MASTER_TEMPLATE_ROUTING reference		Population
EMR_MASTER_TEMPLATE_TYPES reference		Population
EMR_TEMPLATELIST_DETAILS reference		Population
EMR_TEMPLATES_LIST reference	Sections that make up clinical forms.	Single Population
EMR_TEMPLATE_TYPES reference		Population
FORM_GROUPS reference		Population
FORM_GROUP_MEMBERS reference		Population

17Providers, organization, locations & config

Table	Description	Exports
DEPARTMENTS reference		Single Population
EMPLOYERS reference		Single Population
EMPLOYER_PHONES reference		Population
EMR_AOE reference		Population
EMR_AOE_LINK reference		Population
EMR_CLINICAL_INTERVENTIONS reference		Population
EMR_CLINICAL_INTERVENTION_CATEGORIES reference		Population
EMR_CLINICAL_INTERVENTION_TYPES reference		Population
EMR_COMPARE_CONDITIONS reference		Population
EMR_COMPONENT_MASTER reference		Population
EMR_DEMOG_TEMPLATE_DETAILS reference		Population
EMR_LABS_MASTER reference	Directory of laboratories that orders are sent to and results received from.	Population
EMR_LAB_ORDER_LIMITS reference		Population
EMR_LOOKUP_TYPES reference		Population
EMR_MMT_ORDERS patient		Single Population
EMR_MMT_ORDER_DETAILS patient		Single Population
EMR_NC_PATIENTHEALTHPLANS patient		Single Population
EMR_PATIENT_CARE_PLAN patient		Single Population
EMR_PATIENT_CLINICAL_INSTRUCTIONS patient		Single Population
EMR_PATIENT_INSTRUCTIONS patient		Single Population
EMR_REVIEWED_CHART_ON_ENCOUNTER patient		Single Population
EMR_ROOMS_MASTER reference		Single Population
EMR_RULES_MASTER reference		Population
EMR_TYPE_MASTER reference		Population
EMR_USER_TYPES reference		Single Population
EMR_VALIDATION_RULES reference		Population
EVAL_LOCATIONS reference		Single Population
HEALTH_HOMES reference		Single Population
HEALTH_HOME_CONTACTS patient		Single Population
HEALTH_HOME_CONTACT_PHONES patient		Single Population
HEALTH_HOME_PHONES reference		Population
LOCATIONS reference	The practice's office locations.	Single Population
LOCATION_CLASSES reference		Population
LOCATION_HOUSING_UNITS reference		Population
LOCATION_LAB_IDS reference		Population
LOCATION_PHONES reference		Population
LOCATION_PROVIDER_IDS reference		Population
ORGANIZATIONS reference		Single Population
ORGANIZATION_LAB_IDS reference		Population
ORGANIZATION_PHONES reference		Population
PAT_RESOURCES patient		Single Population
PHARMACIES reference		Single Population
PHARMACY_PHONES reference		Population
PPRC_PROVIDER_LIST reference		Population
PROCEDURES reference		Single Population
PROCEDURE_DETAILS reference		Population
PROCEDURE_DUPLICATES reference		Population
PROCEDURE_UNITS reference		Population
PROVIDERS reference	Directory of the practice's providers: names, credentials, identifiers (NPI, taxonomy, license) and practice contact details.	Single Population
PROVIDER_CLASSES reference		Population
PROVIDER_DEPTS reference		Population
PROVIDER_IDS reference		Population
PROVIDER_LAB_IDS reference		Population
PROVIDER_LANGUAGES reference		Population
PROVIDER_PHONES reference		Population
RATE_CLASSES reference		Population
REFERRING_PROVIDERS reference	Directory of referring and outside providers.	Single Population
REFERRING_PROVIDER_IDS reference		Population
REFERRING_PROVIDER_PHONES reference		Population
RESOURCES reference		Single Population
REV_CODES reference		Single Population
REV_CODE_DETAILS reference		Population
SCHOOLS reference		Single Population
SCHOOL_PHONES reference		Population
SERVICES reference		Single Population
SERVICE_CLASSES reference		Population
SERVICE_DETAILS reference		Population
SERVICE_PAYORS reference		Population
SERVICE_PROGRAMS reference		Population
SERVICE_RULES reference		Population
SLIDING_SCALES reference		Single Population
SLIDING_SCALE_FEES reference		Population

18Users, roles & security

Table	Description	Exports
USERS reference	Staff directory (display names) used to interpret user identifiers in patient records.	Single Population

19Audit & logs

Table	Description	Exports
AUDIT_ACTIVITY audit		On request
AUDIT_FIELD_CHANGES audit		On request
AUDIT_FORM_ACCESS audit		On request
AUDIT_REPORT_ACCESS audit		On request
EMR_DRFIRST_ERROR_LOG audit		On request
EXCHANGE_DEBUG_LOG patient		Single Population
EXCHANGE_SYNC_LOG audit		On request
STOCKAMP_SERVER_LOG audit		On request

20Other / unclassified

Table	Description	Exports
ACTIVITIES reference		Single Population
ATTORNEYS reference		Single Population
ATTORNEY_PHONES reference		Population
BEHAVIORALDEFINITION reference		Single Population
CCBHC_CASE_LOAD_CHARACTERISTICS reference		Population
CDC_BMI_PERCENTILES reference		Population
CDC_STATURE_PERCENTILES reference		Population
CDC_WEIGHT_PERCENTILES reference		Population
CHARGE_CLASSES reference		Population
CODING_METHODS reference		Population
CONTACT_PHONES patient		Single Population
CONTACT_RELATIONS reference		Single Population
COUNTY_ZIP_CODES reference		Population
CPS_COMMUNITY_PERCENT_PROCS reference		Population
D_ACTIONS reference		Population
EVENT_CLASSES reference		Population
FAMILY_NUMBERS patient		Single Population
HOUSING_UNITS reference		Single Population
INTERVENTION reference		Population
LICENSE_PLATES reference		Single Population
MACSIS_DURATION_UNITS reference		Population
MASTERTABLE patient		Single Population
MIS_PROC_XCLD reference		Population
MU_MEASURES patient		Single Population
MU_MEASURE_EVENTS patient		Single Population
MVX_CODES reference		Single Population
NCI_DOSAGEFORM reference		Population
NCI_ROUTEOFADMINISTRATION reference		Population
NON_BILLABLE_REASONS reference		Single Population
NQF_MEASURE_POPULATIONS patient		Single Population
OBJECTIVE reference		Single Population
OBJECTIVEINTERVENTION reference		Single Population
PAT_CLASSES reference		Single Population
POS_MOD_OVERRIDES reference		Single Population
PPRC_PAYOR_LIST reference		Population
PROC_CLASSES reference		Population
PROC_GROUPS reference		Single Population
PROC_GROUP_MEMBERS reference		Population
PROC_UNIT_DETAILS reference		Population
REF_PROV_CLASSES reference		Population
TAXONOMY_CODES reference		Population
TRANSPORTS reference		Single Population
TRANSPORT_GROUPS reference		Population
TRANSPORT_GROUP_MEMBERS reference		Population
VERTEBRAE reference		Population
VISIT_CLASSES reference		Population
W_ACTIONS reference		Single Population
W_OBJECTIVES reference		Single Population
W_OBJECTIVE_FREQUENCY reference		Single Population
W_OBJECTIVE_LEVELS reference		Single Population