Documentation/EHI_Export/docs/tables/patient_data.html
| 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.
|
| 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 |