patient_data

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

BIGINT

√

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

√

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

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

pharmacies.id

Defined in XML

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

√

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

√

NULL

users.id

Defined in XML

The id of the assigned provider to this user

ref_providerID

INT

√

NULL

users.id

Defined in XML

The id of the user that referred this patient

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

√

NULL

Financial review date

pubpid

VARCHAR

255

The public facing Medical Record Number (MRN) of the patient

pid

BIGINT

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

HIPAA Mail setting

hipaa_voice

VARCHAR

HIPAA Voice setting

hipaa_notice

VARCHAR

HIPAA Notice setting

hipaa_message

VARCHAR

HIPAA Message setting

hipaa_allowsms

VARCHAR

'NO'

HIPAA Allow SMS setting

hipaa_allowemail

VARCHAR

'NO'

HIPAA Allow Email setting

squad

VARCHAR

The Athletic Squad this patient is a member of

fitness

INT

The sport team Fitness level assigned to this patient

referral_source

VARCHAR

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

√

NULL

Registration Date

contrastart

DATE

√

NULL

Date contraceptives initially used

completed_ad

VARCHAR

'NO'

Completed Ad information

ad_reviewed

DATE

√

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

Allow Patient Portal

deceased_date

DATETIME

√

NULL

Date of Decease

deceased_reason

VARCHAR

255

Reason of Decease

soap_import_status

TINYINT

√

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

religion

VARCHAR

Religion of the patient

industry

MEDIUMTEXT

16777215

√

NULL

county

VARCHAR

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

√

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

-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

√

NULL

users.id

Defined in XML

The id of the user that initially created this record

updated_by

BIGINT

√

NULL

users.id

Defined in XML

The id of the user that last updated this record

preferred_name

TEXT

65535

√

NULL

nationality_country

TEXT

65535

√

NULL

last_updated

DATETIME

current_timestamp()

Showing 1 to 127 of 127 entries

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation