patient_data


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of patient_data.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Main patient record that contains patient demographic information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
person_patient_link.patient_id Defined in XML R

Surrogate id of the record used as the primary incrementing key
uuid BINARY 16 √ NULL

UUID of the record
title VARCHAR 255 ''

Title of the patient
language VARCHAR 255 ''

Language preference of the patient
financial VARCHAR 255 ''

Financial information of the patient
fname VARCHAR 255 ''

First name of the patient
lname VARCHAR 255 ''

Last name of the patient
mname VARCHAR 255 ''

Middle name of the patient
DOB DATE 10 √ NULL

Date of Birth of the patient
street VARCHAR 255 ''

Street address of the patient
postal_code VARCHAR 255 ''

Postal code of the patient’s address
city VARCHAR 255 ''

City of the patient’s address
state VARCHAR 255 ''

State of the patient’s address
country_code VARCHAR 255 ''

Country code of the patient’s address
drivers_license VARCHAR 255 ''

Driver’s license of the patient
ss VARCHAR 255 ''

Social Security Number of the patient
occupation LONGTEXT 2147483647 √ NULL

Occupation of the patient. UNEMPLOYED, STUDENT, PT STUDENT, or anything else to indicate employed.
phone_home VARCHAR 255 ''

Home phone number of the patient
phone_biz VARCHAR 255 ''

Business phone number of the patient
phone_contact VARCHAR 255 ''

Contact phone number of the patient
phone_cell VARCHAR 255 ''

Cell phone number of the patient
pharmacy_id INT 10 0
pharmacies.id Defined in XML R

The patient’s default pharmacy to send prescriptions to
status VARCHAR 255 ''

Marital Status: M = Married, S = Single, or something else
contact_relationship VARCHAR 255 ''

Relationship of the contact person
date DATETIME 19 √ NULL

Date related to the patient
sex VARCHAR 255 ''

Gender of the patient
referrer VARCHAR 255 ''

Referrer of the patient
referrerID VARCHAR 255 ''

ID of the referring user
providerID INT 10 √ NULL
users.id Defined in XML R

The id of the assigned provider to this user
ref_providerID INT 10 √ NULL
users.id Defined in XML R

The id of the user that referred this patient
email VARCHAR 255 ''

Email address of the patient
email_direct VARCHAR 255 ''

Trusted Direct email address of the patient
ethnoracial VARCHAR 255 ''

Ethnicity/Race information of the patient
race VARCHAR 255 ''

Race of the patient
ethnicity VARCHAR 255 ''

Ethnicity of the patient
religion VARCHAR 40 ''

Religion of the patient
interpretter VARCHAR 255 ''

Interpreter information for the patient
migrantseasonal VARCHAR 255 ''

Migrant/Seasonal worker information
family_size VARCHAR 255 ''

Family size information of the patient
monthly_income VARCHAR 255 ''

Monthly income information of the patient
billing_note TEXT 65535 √ NULL

Billing notes for the patient
homeless VARCHAR 255 ''

Homeless status of the patient
financial_review DATETIME 19 √ NULL

Financial review date
pubpid VARCHAR 255 ''

The public facing Medical Record Number (MRN) of the patient
pid BIGINT 19 0
amendments.pid Defined in XML R
ar_activity.pid Defined in XML R
ar_session.patient_id Defined in XML R
billing.pid Defined in XML R
care_team.pid Defined in XML R
care_team_member.care_team_id Defined in XML R
claims.patient_id Defined in XML R
clinical_plans.pid Defined in XML R
document_templates.pid Defined in XML R
documents.foreign_id Defined in XML R
drug_sales.pid Defined in XML R
ehi_export_job_patients.pid FK_ehi_export_job_patients_patient_id C
ehi_export_job_task_patients.pid FK_ehi_export_job_task_patients_patient_id C
employer_data.pid Defined in XML R
extended_log.patient_id Defined in XML R
external_encounters.ee_pid Defined in XML R
external_procedures.ep_pid Defined in XML R
form_CAMOS.pid Defined in XML R
form_CAMOS_category.pid Defined in XML R
form_CAMOS_item.pid Defined in XML R
form_CAMOS_subcategory.pid Defined in XML R
form_care_plan.pid Defined in XML R
form_clinical_instructions.pid Defined in XML R
form_clinical_notes.pid Defined in XML R
form_dictation.pid Defined in XML R
form_encounter.pid Defined in XML R
form_eye_acuity.pid Defined in XML R
form_eye_antseg.pid Defined in XML R
form_eye_base.pid Defined in XML R
form_eye_biometrics.pid Defined in XML R
form_eye_external.pid Defined in XML R
form_eye_hpi.pid Defined in XML R
form_eye_locking.pid Defined in XML R
form_eye_mag_dispense.pid Defined in XML R
form_eye_mag_impplan.pid Defined in XML R
form_eye_mag_orders.pid Defined in XML R
form_eye_mag_wearing.PID Defined in XML R
form_eye_neuro.pid Defined in XML R
form_eye_postseg.pid Defined in XML R
form_eye_refraction.pid Defined in XML R
form_eye_ros.pid Defined in XML R
form_eye_vitals.pid Defined in XML R
form_functional_cognitive_status.pid Defined in XML R
form_history_sdoh.pid Defined in XML R
form_misc_billing_options.pid Defined in XML R
form_observation.parent_observation_id Defined in XML R
form_observation.pid Defined in XML R
form_observation.user Defined in XML R
form_questionnaire_assessments.pid Defined in XML R
form_reviewofs.pid Defined in XML R
form_ros.pid Defined in XML R
form_soap.pid Defined in XML R
form_taskman.PATIENT_ID Defined in XML R
form_track_anything.pid Defined in XML R
form_vitals.pid Defined in XML R
form_vitals_calculation.pid Defined in XML R
forms.pid Defined in XML R
history_data.pid Defined in XML R
immunization_observation.imo_pid Defined in XML R
immunizations.patient_id Defined in XML R
insurance_data.pid Defined in XML R
issue_encounter.pid Defined in XML R
lists.pid Defined in XML R
medex_recalls.r_pid Defined in XML R
onsite_documents.pid Defined in XML R
onsite_portal_activity.patient_id Defined in XML R
onsite_signatures.pid Defined in XML R
form_aftercare_plan.pid Defined in XML R
form_ankleinjury.pid Defined in XML R
form_bronchitis.pid Defined in XML R
form_gad7.pid Defined in XML R
form_note.pid Defined in XML R
form_painmap.pid Defined in XML R
form_phq9.pid Defined in XML R
form_prior_auth.pid Defined in XML R
form_sdoh.pid Defined in XML R
form_transfer_summary.pid Defined in XML R
form_treatment_plan.pid Defined in XML R
openemr_postcalendar_events.pc_pid Defined in XML R
patient_access_onsite.pid Defined in XML R
patient_care_experience_preferences.patient_id Defined in XML R
patient_history.pid Defined in XML R
patient_reminders.pid Defined in XML R
patient_tracker.pid Defined in XML R
patient_treatment_intervention_preferences.patient_id Defined in XML R
pnotes.pid Defined in XML R
prescriptions.patient_id Defined in XML R
pro_assessments.patient_id Defined in XML R
procedure_order.patient_id Defined in XML R
questionnaire_response.patient_id Defined in XML R
rule_patient_data.pid Defined in XML R
shared_attributes.pid Defined in XML R
therapy_groups_participant_attendance.pid Defined in XML R
therapy_groups_participants.pid Defined in XML R
transactions.pid Defined in XML R
voids.patient_id Defined in XML R

The internal patient identifier used throughout the export to represent this unique patient record
genericname1 VARCHAR 255 ''

Generic name field 1
genericval1 VARCHAR 255 ''

Generic value field 1
genericname2 VARCHAR 255 ''

Generic name field 2
genericval2 VARCHAR 255 ''

Generic value field 2
hipaa_mail VARCHAR 3 ''

HIPAA Mail setting
hipaa_voice VARCHAR 3 ''

HIPAA Voice setting
hipaa_notice VARCHAR 3 ''

HIPAA Notice setting
hipaa_message VARCHAR 20 ''

HIPAA Message setting
hipaa_allowsms VARCHAR 3 'NO'

HIPAA Allow SMS setting
hipaa_allowemail VARCHAR 3 'NO'

HIPAA Allow Email setting
squad VARCHAR 32 ''

The Athletic Squad this patient is a member of
fitness INT 10 0

The sport team Fitness level assigned to this patient
referral_source VARCHAR 30 ''

Source of referral for the patient
usertext1 VARCHAR 255 ''

User text field 1
usertext2 VARCHAR 255 ''

User text field 2
usertext3 VARCHAR 255 ''

User text field 3
usertext4 VARCHAR 255 ''

User text field 4
usertext5 VARCHAR 255 ''

User text field 5
usertext6 VARCHAR 255 ''

User text field 6
usertext7 VARCHAR 255 ''

User text field 7
usertext8 VARCHAR 255 ''

User text field 8
userlist1 VARCHAR 255 ''

User list field 1
userlist2 VARCHAR 255 ''

User list field 2
userlist3 VARCHAR 255 ''

User list field 3
userlist4 VARCHAR 255 ''

User list field 4
userlist5 VARCHAR 255 ''

User list field 5
userlist6 VARCHAR 255 ''

User list field 6
userlist7 VARCHAR 255 ''

User list field 7
pricelevel VARCHAR 255 'standard'

Price level information of the patient
regdate DATETIME 19 √ NULL

Registration Date
contrastart DATE 10 √ NULL

Date contraceptives initially used
completed_ad VARCHAR 3 'NO'

Completed Ad information
ad_reviewed DATETIME 19 √ NULL

Date Ad reviewed
vfc VARCHAR 255 ''

VFC information
mothersname VARCHAR 255 ''

Mother’s name
guardiansname TEXT 65535 √ NULL

Guardian’s name
allow_imm_reg_use VARCHAR 255 ''

Allow Immunization Registry Use
allow_imm_info_share VARCHAR 255 ''

Allow Immunization Information Sharing
allow_health_info_ex VARCHAR 255 ''

Allow Health Information Exchange
allow_patient_portal VARCHAR 31 ''

Allow Patient Portal
deceased_date DATETIME 19 √ NULL

Date of Decease
deceased_reason VARCHAR 255 ''

Reason of Decease
soap_import_status TINYINT 3 √ NULL

SOAP Import Status (1-Prescription Press 2-Prescription Import 3-Allergy Press 4-Allergy Import)
cmsportal_login VARCHAR 60 ''
care_team_provider TEXT 65535 √ NULL

List of care team providers where each id is the provider id contained in the users.id. Entries are separated by a the pipe | symbol.
care_team_facility TEXT 65535 √ NULL

List of care team facilities where each id is the facility/organization id contained in the facilities.id. Entries are separated by a the pipe | symbol
care_team_status TEXT 65535 √ NULL
county VARCHAR 40 ''
industry TEXT 65535 √ NULL
imm_reg_status TEXT 65535 √ NULL
imm_reg_stat_effdate TEXT 65535 √ NULL
publicity_code TEXT 65535 √ NULL
publ_code_eff_date TEXT 65535 √ NULL
protect_indicator TEXT 65535 √ NULL
prot_indi_effdate TEXT 65535 √ NULL
guardianrelationship TEXT 65535 √ NULL
guardiansex TEXT 65535 √ NULL
guardianaddress TEXT 65535 √ NULL
guardiancity TEXT 65535 √ NULL
guardianstate TEXT 65535 √ NULL
guardianpostalcode TEXT 65535 √ NULL
guardiancountry TEXT 65535 √ NULL
guardianphone TEXT 65535 √ NULL
guardianworkphone TEXT 65535 √ NULL
guardianemail TEXT 65535 √ NULL
sexual_orientation TEXT 65535 √ NULL
gender_identity TEXT 65535 √ NULL
birth_fname TEXT 65535 √ NULL
birth_lname TEXT 65535 √ NULL
birth_mname TEXT 65535 √ NULL
dupscore INT 10 -9
name_history TINYTEXT 255 √ NULL
suffix TINYTEXT 255 √ NULL
street_line_2 TINYTEXT 255 √ NULL
patient_groups TEXT 65535 √ NULL
prevent_portal_apps TEXT 65535 √ NULL
provider_since_date TINYTEXT 255 √ NULL
created_by BIGINT 19 √ NULL
users.id Defined in XML R

The id of the user that initially created this record
updated_by BIGINT 19 √ NULL
users.id Defined in XML R

The id of the user that last updated this record
preferred_name TINYTEXT 255 √ NULL
nationality_country TINYTEXT 255 √ NULL
last_updated DATETIME 19 current_timestamp()
tribal_affiliations TEXT 65535 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘tribal_affiliations’
sex_identified TEXT 65535 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘administrative_sex’
interpreter_needed TEXT 65535 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘yes_no_unknown’ and represents whether an interpreter is needed for this patient
advance_directive_user_authenticator BIGINT 19 √ NULL
users.id Defined in XML R

fk to users.id of the user who authenticates that the advance care directive is valid.

Indexes

Constraint Name Type Sort Column(s)
id Performance Asc id
idx_patient_dob Performance Asc DOB
idx_patient_name Performance Asc/Asc lname + fname
pid Must be unique Asc pid
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation