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
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
ethnoracial VARCHAR 255 ''

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

Race of the patient
ethnicity VARCHAR 255 ''

Ethnicity 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
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_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_observation.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_soap.pid Defined in XML R
form_taskman.PATIENT_ID 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_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_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_track_anything.pid Defined in XML R
form_transfer_summary.pid Defined in XML R
form_treatment_plan.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 MEDIUMTEXT 16777215 √ 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)
email_direct VARCHAR 255 ''

Trusted Direct email address of the patient
cmsportal_login VARCHAR 60 ''
religion VARCHAR 40 ''

Religion of the patient
industry MEDIUMTEXT 16777215 √ NULL
county VARCHAR 40 ''
care_team_provider MEDIUMTEXT 16777215 √ 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.
billing_note MEDIUMTEXT 16777215 √ NULL

Billing notes for the patient
imm_reg_status MEDIUMTEXT 16777215 √ NULL
imm_reg_stat_effdate MEDIUMTEXT 16777215 √ NULL
publicity_code MEDIUMTEXT 16777215 √ NULL
publ_code_eff_date MEDIUMTEXT 16777215 √ NULL
protect_indicator MEDIUMTEXT 16777215 √ NULL
prot_indi_effdate MEDIUMTEXT 16777215 √ NULL
guardianrelationship MEDIUMTEXT 16777215 √ NULL
guardiansex MEDIUMTEXT 16777215 √ NULL
guardianaddress MEDIUMTEXT 16777215 √ NULL
guardiancity MEDIUMTEXT 16777215 √ NULL
guardianstate MEDIUMTEXT 16777215 √ NULL
guardianpostalcode MEDIUMTEXT 16777215 √ NULL
guardiancountry MEDIUMTEXT 16777215 √ NULL
guardianphone MEDIUMTEXT 16777215 √ NULL
guardianworkphone MEDIUMTEXT 16777215 √ NULL
guardianemail MEDIUMTEXT 16777215 √ NULL
uuid BINARY 16 √ NULL

UUID of the record
care_team_facility MEDIUMTEXT 16777215 √ 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
sexual_orientation MEDIUMTEXT 16777215 √ NULL
gender_identity MEDIUMTEXT 16777215 √ NULL
birth_fname MEDIUMTEXT 16777215 √ NULL
birth_lname MEDIUMTEXT 16777215 √ NULL
birth_mname MEDIUMTEXT 16777215 √ NULL
dupscore INT 10 -9
care_team_status MEDIUMTEXT 16777215 √ NULL
name_history TEXT 65535 √ NULL
suffix TEXT 65535 √ NULL
street_line_2 TEXT 65535 √ NULL
patient_groups MEDIUMTEXT 16777215 √ NULL
prevent_portal_apps MEDIUMTEXT 16777215 √ NULL
provider_since_date TEXT 65535 √ 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 TEXT 65535 √ NULL
nationality_country TEXT 65535 √ NULL
last_updated DATETIME 19 current_timestamp()

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