Patient
This section contains data related to patient demographic and clinical information not captured as part of visit-related data.
allergy
Zero or more allergies per patient. Based on FirstDataBank (FDB).
- allergy_id
- patient_id
- allergen_type
- allergen_description
- allergy_status
- date_recorded
- date_started
- date_ended
- severity
- reaction_anaphylaxis
- reaction_angioedema
- reaction_hives
- reaction_rash
- reaction_shortness_of_breath
- reaction_swelling
- reaction_weal
- reaction_diarrhea
- reaction_dizziness
- reaction_fatigue
- reaction_gi_upset
- reaction_liver_toxicity
- reaction_nausea
- reaction_other
- reaction_other_value
- firm_global_id
card_on_file
Patient credit cards documented in patient chart. One row per patient per card.
- card_on_file_id
- patient_id
- created_by_staff_id
- modified_by_staff_id
- brand
- status
- expiration_date
- date_created
- date_modified
- firm_global_id
chart_note
Stores comments associated with a patient’s chart. One row per chart note.
- chart_note_id
- firm_id
- author_patient_id
- author_staff_id
- patient_id
- visit_id
- assigned_staff_id
- author_name
- assigned_staff_name
- note_title
- note_text
- note_type
- note_status
- note_sub_status
- communication_method
- sub_communication_method
- visible
- patient_visible
- patient_account_expired
- display_at_top
- archived
- note_created_date
- date_sent
- finalized_date
- firm_global_id
chart_note_signature
Stores signatures associated with a patient's chart notes. One row per chart note signature.
- chart_note_signature_id
- chart_note_id
- patient_id
- signature_staff_id
- signature_note
- signature_date
- firm_global_id
chart_segmentation_event
Chart segmentation report table, one row per event.
- chart_segmentation_event_id
- patient_id
- staff_id
- patient_last_name
- patient_first_name
- patient_mrn
- staff_last_name
- staff_first_name
- event_type
- event_reason
- event_status
- event_start_date
- event_end_date
- firm_global_id
family_history
Patient family history conditions list, may be zero or more entries per patient. Based on SNOMED family history terms.
- patient_id
- snomed
- condition
- status
- date_recorded
- mother
- father
- sister
- brother
- daughter
- son
- uncle
- aunt
- nephew
- niece
- grandmother
- grandfather
- grandson
- granddaughter
- none
- other
- firm_global_id
guarantor
Patient's guarantor information.
- guarantor_id
- patient_id
- relation_to_patient
- last_name
- first_name
- middle_name
- prefix
- suffix
- date_of_birth
- same_as_patient_address
- country
- street1
- street2
- city
- state
- zipcode
- home_phone_number
- work_phone_number
- mobile_phone_number
- firm_global_id
immunization
Immunization recorded in the patient clipboard. One row per patient/immunization. NOTE: does not include immunizations given from a procedure or plan.
- immunization_id
- patient_id
- administered_by_id
- ordered_by_id
- created_by_staff_id
- cvx_code
- short_description
- full_vaccine_name
- lot_number
- expiration_date
- manufacturer
- amount
- units
- coding_system
- body_site
- route
- start_date
- end_date
- source
- refusal_reason
- administration_note
- vfc_class
- status
- firm_global_id
insurance_group
Insurance group information. One row per patient/insurance group. Collected from PMS or manual entry.
- insurance_group_id
- patient_id
- active
- name
- payer_scenario
- description
- firm_global_id
insurance_group_policy
Insurance policy assigned to one or more groups. One row per group/policy.
- insurance_group_policy_id
- insurance_group_id
- insurance_policy_id
- patient_id
- rank
- firm_global_id
insurance_policy
Insurance policy information. One row per patient/insurance policy. Collected from PMS or manual entry.
- insurance_policy_id
- patient_id
- payer_id
- payer_address_id
- facility_payer_address_id
- payer_plan_id
- fee_schedule_id
- source_of_payment_typology
- patient_self_paying
- active
- insurance_company_name
- plan_name
- policy_type
- policy_number
- group_number
- payer_id_number
- insurance_code
- insurance_phone_number
- ranking
- policy_effective_date
- policy_term_date
- eligibility_active
- eligibility_last_updated_time
- copay_type
- copay_amount
- copay_deductible
- deductible_remaining
- copay_percent
- referral_needed
- referral_number
- referral_number_of_visits
- referral_effective_date
- referral_expiration_date
- insurance_street1
- insurance_street2
- insurance_city
- insurance_state
- insurance_zipcode
- insurance_country
- insurance_card_name_override
- patient_first_name
- patient_last_name
- patient_middle_name
- patient_name_prefix
- patient_name_suffix
- relationship_to_policy_holder
- policy_patient_name
- policy_holder_last_name
- policy_holder_first_name
- policy_holder_middle_name
- policy_holder_gender
- policy_holder_marital_status
- policy_holder_date_of_birth
- policy_holder_race
- policy_holder_home_phone_number
- policy_holder_work_phone_number
- policy_holder_mobile_phone_number
- policy_holder_street1
- policy_holder_street2
- policy_holder_city
- policy_holder_state
- policy_holder_zipcode
- policy_holder_country
- billing_address_same_as_patient
- policy_holder_employer_name
- policy_holder_employer_phone_number
- policy_holder_employer_street1
- policy_holder_employer_street2
- policy_holder_employer_city
- policy_holder_employer_state
- policy_holder_employer_zipcode
- policy_holder_employer_country
- relationship_to_guarantor
- guarantor_last_name
- guarantor_first_name
- guarantor_middle_name
- guarantor_gender
- guarantor_marital_status
- guarantor_date_of_birth
- guarantor_mrn
- guarantor_chart_number
- guarantor_race
- guarantor_street1
- guarantor_street2
- guarantor_city
- guarantor_state
- guarantor_zipcode
- guarantor_country
- guarantor_home_phone_number
- guarantor_work_phone_number
- facility_plan_name
- facility_policy_number
- facility_group_number
- facility_same_as_professional
- authorization_for_office_visit
- inpatient_services_precertification
- outpatient_services_preauthorization
- insurance_card_front_image
- insurance_card_back_image
- customer_service_street1
- customer_service_street2
- customer_service_city
- customer_service_state
- customer_service_zipcode
- customer_service_email_address
- customer_service_website_address
- customer_service_phone_number
- customer_service_fax_phone_number
- claims_street1
- claims_street2
- claims_city
- claims_state
- claims_zipcode
- claims_email_address
- claims_website_address
- claims_phone_number
- claims_fax_phone_number
- appeals_street1
- appeals_street2
- appeals_city
- appeals_state
- appeals_zipcode
- appeals_email_address
- appeals_website_address
- appeals_phone_number
- appeals_fax_phone_number
- precertification_street1
- precertification_street2
- precertification_city
- precertification_state
- precertification_zipcode
- precertification_email_address
- precertification_website_address
- precertification_phone_number
- precertification_fax_phone_number
- firm_global_id
insurance_policy_authorization
Insurance policy authorization.
- insurance_policy_authorization_id
- insurance_policy_id
- patient_case_id
- staff_id
- referral_contact_id
- patient_id
- authorization_type
- authorization_number
- authorization_entry_date
- authorization_start_date
- authorization_end_date
- number_of_authorized_visits
- authorized_visits_remaining
- unlimited_visits
- description
- additional_notes
- active
- firm_global_id
insurance_policy_authorization_ appt_type
Insurance policy authorization to specific appointment types mapping table.
- insurance_policy_authorization_appt_type_id
- insurance_policy_authorization_id
- appointment_type_id
- patient_id
- firm_global_id
insurance_policy_authorization_ attachment
Insurance policy to file attachment mapping table.
- insurance_policy_authorization_attachment_id
- insurance_policy_authorization_id
- file_attachment_id
- patient_id
- firm_global_id
intra_mail
intra_mail table contains all the IntraMail messages created in Encompass.
- intra_mail_id
- firm_id
- author_patient_id
- author_staff_id
- patient_id
- visit_id
- lab_request_id
- chart_note_id
- patient_representative
- subject
- message_body
- priority
- is_draft
- is_auto_reply
- firm_global_id
intra_mail_recipient
Links IntraMail messages with the message recipients.
- intra_mail_recipient_id
- intra_mail_id
- recipient_patient_id
- recipient_staff_id
- firm_group_id
- recipient_type
- message_flagged
- message_read
- message_archived
- firm_global_id
medical_history
Past medical history information. Includes conditions from generic Past Medical History and specialty-specific medical history. Zero or more entries per patient. Users can add custom conditions with SNOMED codes, so the SNOMED column contains the most accurate information.
- medical_history_id
- patient_id
- source
- value
- snomed
- secondary_snomed
- other_value
- firm_global_id
medication
Patient current medication list. Zero or more entries per patient.
- medication_id
- patient_id
- rx_id
- drug_name
- generic_name
- is_generic
- strength
- strength_units
- route
- source
- dose
- dose_form
- frequency
- indication
- date_started
- date_ended
- during_visit
- active
- firm_global_id
patient
Patient demographics, practice data, and single-response clipboard information.
- patient_id
- firm_id
- primary_provider_id
- primary_care_provider_id
- referring_provider_id
- financial_category_id
- patient_created_by_id
- last_appointment_id
- next_appointment_id
- nursing_room_facility_id
- last_name
- first_name
- middle_name
- prefix
- suffix
- nick_name
- marital_status
- previous_name
- employment_status
- date_of_birth
- age_in_years
- age_in_months
- birth_city
- birth_state
- birth_zipcode
- birth_country
- deceased
- date_of_death
- sex
- sexual_orientation
- sexual_orientation_other_text
- language
- language_code
- race_american_indian_or_alaska_native
- race_asian
- race_black_african_american
- race_native_hawaiian_pacific_islander
- race_white
- race_other
- race_unknown
- race
- ethnic_group
- gender_identity
- gender_identity_other_text
- patient_preferred_pronoun
- preferred_contact_method
- emergency_contact_name
- emergency_contact_phone_number
- receive_appointment_text_reminders
- last_appointment_date
- last_appointment_type
- next_appointment_date
- next_appointment_type
- spouse_name
- spouse_phone_number
- caretaker_name
- caretaker_phone_number
- preferred_phone
- mobile_phone_number
- home_phone_number
- work_phone_number
- home_fax_phone_number
- work_fax_phone_number
- emergency_phone_number
- pager_phone_number
- other_phone_number
- preferred_phone_number
- preferred_phone_number_type
- ok_to_leave_detailed_message
- alternate_email
- email_opt_in
- declined_email_address
- home_street1
- home_street2
- home_city
- home_state
- home_zipcode
- home_country
- home_start_date
- home_end_date
- seasonal_street1
- seasonal_street2
- seasonal_city
- seasonal_state
- seasonal_zipcode
- seasonal_country
- seasonal_start_date
- seasonal_end_date
- employer_name
- occupation
- occupation_code
- industry
- industry_code
- mrn
- pqrs_id
- established_patient
- rx_history_consent
- last_visit_date
- last_payment_plan_status
- medicare_number
- medicaid_number
- immunization_registry_status
- immunization_registry_status_effective_date
- immunization_registry_protection_indicator
- immunization_registry_protection_indicator_eff
- ective_date
- immunization_registry_publicity_setting
- immunization_registry_publicity_setting_effecti
- ve_date
- pms_id
- pms_id_type
- archived
- portal_enabled
- username
- last_login
- good_login_count
- bad_login_count
- account_locked
- representative_portal_enabled
- representative_last_name
- representative_first_name
- representative_middle_name
- representative_username
- representative_last_login
- representative_account_locked
- sticky_note
- sticky_note_last_edit
- last_menstrual_period
- last_pelvic_exam
- last_mammogram
- last_pap_smear
- gravida
- para
- tab
- sab
- gest_age_birth
- birth_lbs
- birth_oz
- maternal_illness
- forceps_delivery
- medication_other
- allergy_nkda
- allergy_other
- smoking_status
- smoking_start_date
- smoking_quit_date
- smoking_packs_per_day
- smoking_total_years
- smoking_additional_details
- alcohol_screening
- exercise_status
- caffeine_use
- occupation_and_workplace
- place_of_residence
- nursing_room_facility_name
- nursing_room_identifier
- pneumonia_vaccination
- health_care_proxy
- health_care_proxy_designee_name
- health_care_proxy_designee_phone_number
- living_will
- do_not_intubate
- do_not_resuscitate
- ema_test_patient
- has_card_on_file
- card_on_file_expiration_date_max
- full_cardiopulmonary_resuscitation
- family_history_other
- account_status
- status_date_modified
- restricted
- has_active_payment_plan
- payment_plan_types
- date_last_seen_by_pcp
- portal_enabled_date
- firm_global_id
patient_business_unit_setting
Lookup for information on whether patient statements are enabled for a Patient, for a specific business unit. One row per patient per business unit.
- patient_business_unit_id
- patient_id
- business_unit_id
- patient_business_unit_statement_preference
- patient_business_unit_auto_pay_status
- last_statement_date
- firm_global_id
patient_case
Patient's case information. Typically associated with workers compensation, auto accidents or personal injuries.
- patient_case_id
- patient_id
- staff_id
- insurance_policy_id
- case_type
- case_name
- case_number
- injury_date
- injury_state
- unable_to_work_start_date
- unable_to_work_end_date
- active
- firm_global_id
patient_case_attachment
Patient case to file attachment mapping table.
- patient_case_attachment_id
- patient_case_id
patient_case_contact
Patient's contact information for case.
- patient_case_contact_id
- patient_case_id
- patient_id
- first_name
- last_name
- contact_type
- phone_number
- fax_phone_number
- active
- firm_global_id
patient_history
Patient history specific to the medical domain (single-response only). One row per patient.
- patient_history_id
- patient_id
- sunscreen
- sunscreen_spf
- tanning_salon
- melanoma_fh
- breast_cancer_fh
- malignant_hyperthermia_fh
- herbal_medications
- firm_global_id
patient_pharmacy
Pharmacies assigned to a patient. One row per patient/pharmacy. Collected from Surescripts or manual entry.
- patient_pharmacy_id
- patient_id
- surescripts_pharmacy
- ncpdpid
- default
- name
- phone_number
- fax_number
- street1
- street2
- city
- state
- zipcode
- country
- firm_global_id
patient_race
Patient races. Zero or more races per patient.
- patient_race_id
- patient_id
- race
- firm_global_id
patient_sticky_note_history
Patient Sticky Note History provides one row of history per patient edit of their sticky note.
- patient_sticky_note_history_id
- patient_id
- sticky_note
- sticky_note_date_created
- firm_global_id
problem_list
Patient problem list, may be zero or more entries per patient. Based on ICD9, ICD10, and SNOMED. codes generated from a diagnosis and conditions selected in the clipboard add codes to this table.
- problem_list_id
- patient_id
- diagnosis_id
- date_diagnosed
- problem_modified_date
- end_date
- problem_type
- status
- icd9
- icd10
- snomed
- firm_global_id
procedure_log
Patient procedure log, may ber zero or more entries per patient. Based on SNOMED and LOINC. Some procedures recorded in the procedure table do not add entries to this table. May include codes that are not procedures, see type column.
- procedure_log_id
- patient_id
- procedure_date
- procedure_snomed
- site_snomed
- reason_snomed
- loinc
- type
- firm_global_id
social_history
Social history details. Includes alcohol, drug use, sexual activity, and driving. Zero or more rows per patient.
- social_history_id
- patient_id
- value
- firm_global_id
specialty_family_history
Specialty-specific family history. Zero or more entries per patient. Users can add custom conditions with SNOMED codes, so the SNOMED column contains the most accurate information.
- specialty_family_history_id
- patient_id
- source
- value
- snomed
- secondary_snomed
- other_value
- firm_global_id
specialty_history
Specialty-specific history that does not fit into medical, surgical, pediatric, or family history. Zero or more entries per patient. Users can add custom conditions with SNOMED codes, so the SNOMED column contains the most accurate information.
- specialty_history_id
- patient_id
- source
- value
- snomed
- secondary_snomed
- other_value
- firm_global_id
specialty_pediatric_history
Specialty-specific pediatric history. Zero or more entries per patient. Users can add custom conditions with SNOMED codes, so the SNOMED column contains the most accurate information.
- specialty_pediatric_history_id
- patient_id
- source
- value
- snomed
- secondary_snomed
- other_value
- firm_global_id
surgical_history
Surgical history details. Includes surgeries from generic Past Medical History and specialty-specific medical history. Zero or more rows per patient. Users can add custom conditions with SNOMED codes, so the SNOMED column contains the most accurate information.
- surgical_history_id
- patient_id
- source
- value
- snomed
- secondary_snomed
- other_value
- firm_global_id