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

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
claims.patient_id Defined in XML R
clinical_plans.pid Defined in XML R
documents.foreign_id Defined in XML R
drug_sales.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_aftercare_plan.pid Defined in XML R
form_ankleinjury.pid Defined in XML R
form_bronchitis.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_misc_billing_options.pid Defined in XML R
form_note.pid Defined in XML R
form_observation.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_questionnaire_assessments.pid Defined in XML R
form_reviewofs.pid Defined in XML R
form_ros.pid Defined in XML R
form_sdoh.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_transfer_summary.pid Defined in XML R
form_treatment_plan.pid Defined in XML R
form_vitals.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
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
document_templates.pid Defined in XML R
form_gad7.pid Defined in XML R
issue_encounter.pid Defined in XML R
openemr_postcalendar_events.pc_pid Defined in XML R
patient_access_onsite.pid 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
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 DATE 10 √ 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

Indexes

Constraint Name Type Sort Column(s)
id Performance Asc id
pid Must be unique Asc pid
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation