Patient
This section contains data related to patient demographic and clinical information not captured as part of visit-related data.
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
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
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
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 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
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
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 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 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 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 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_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 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 to file attachment mapping table.
- insurance_policy_authorization_attachment_id
- insurance_policy_authorization_id
- file_attachment_id
- patient_id
- firm_global_id
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
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
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
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 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
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'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 to file attachment mapping table.
- patient_case_attachment_id
- patient_case_id
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 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
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 races. Zero or more races per patient.
- patient_race_id
- patient_id
- race
- firm_global_id
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
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
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 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-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-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-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 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