Visit

This section contains visit-related data that describe the visit as a whole or are not part of an individual component (e.g., HPI, diagnosis).

Charges for self-pay (cash) procedures. '

Preliminary or held visits will not have entries in this table.

  • bill_cash_id
  • visit_id
  • patient_id
  • diagnosis_name
  • procedure_name
  • quantity
  • charge
  • firm_global_id

Diagnosis code(s) for each CPT/HCPCS code in the bill_procedure table

  • final_bill_diagnosis_id
  • final_bill_procedure_id
  • patient_id
  • position
  • icd9
  • icd10
  • firm_global_id

Modifier(s) for each CPT/HCPCS code in the bill_procedure table

  • final_bill_modifier_id
  • final_bill_procedure_id
  • patient_id
  • position
  • modifier
  • firm_global_id

CPT/HCPCS code line item.

This table records the final bill that was sent upon finalization, including all overrides. Preliminary or held visits will not have entries in this table.

  • final_bill_procedure_id
  • visit_id
  • patient_id
  • position
  • cpt
  • quantity
  • firm_global_id

Originally computed bill before any overrides. Diagnosis code(s) for each CPT/HCPCS code in the original_bill_procedure table.

  • original_bill_diagnosis_id
  • original_bill_procedure_id
  • patient_id
  • position
  • icd9
  • icd10
  • firm_global_id

Originally computed bill before any overrides. Modifier(s) for each CPT/HCPCS code in the original_bill_procedure table

  • original_bill_modifier_id
  • original_bill_procedure_id
  • patient_id
  • position
  • modifier
  • firm_global_id

Originally computed bill before any overrides. CPT/HCPCS code line item. NOTE: This table gets populated upon finalization, preliminary or held visits will not have entries in this table.

  • original_bill_procedure_id
  • visit_id
  • patient_id
  • position
  • cpt
  • quantity
  • firm_global_id

Outcome measurement generated from a visit. One row per visit/outcome measurement. May be created as part of a chief complaint, exam, or procedure. Only one of hpi_response_id, exam_element_id, procedure_id, or procedure_body_location_id will be non-null per row.

  • outcome_measurement_id
  • visit_id
  • patient_id
  • hpi_response_id
  • exam_element_id
  • procedure_id
  • procedure_body_location_id
  • variable
  • title
  • question_text
  • value
  • units
  • firm_global_id

Review of systems. One row per visit/ros item reviewed. Items that are not reviewed do not show up in this table.

  • ros_id
  • visit_id
  • patient_id
  • question
  • type
  • flag_alert
  • value
  • firm_global_id

Individual patient encounter.

  • visit_id
  • patient_id
  • facility_id
  • physician_id
  • primary_provider_id
  • primary_biller_id
  • primary_care_provider_id
  • referring_provider_id
  • bill_overridden_staff_id
  • patient_case_id
  • fee_schedule_id
  • ordering_provider_id
  • supervising_provider_id
  • ordering_referral_contact_id
  • visit_date
  • visit_date_ld
  • type
  • visit_category
  • transition_of_care
  • pms_id
  • pms_id_type
  • fin
  • bill_as
  • archived
  • override_em_code
  • bill_by_time_minutes
  • bill_by_time_percent_counseling
  • bill_by_time_visit_type
  • bill_overridden
  • refuse_vitals
  • is_last_visit
  • visit_status
  • historical_summary
  • finalized_date
  • finalized_date_ld
  • note_created_date
  • note_created_date_ld
  • time_zone
  • date_created
  • date_modified
  • firm_global_id

Additional attendees for a visit. Zero or more entries per visit.

  • visit_attendee_id
  • visit_id
  • patient_id
  • staff_id
  • scribe
  • is_primary_provider
  • is_primary_biller
  • firm_global_id

All the descriptive codes documented in a patient visit. One visit to many codes.

  • visit_code_id
  • visit_id
  • patient_id
  • code_system
  • code_value
  • source
  • firm_global_id

Follow up(s) set for a visit. One row per visit/follow up setting.

  • visit_follow_up_id
  • visit_id
  • patient_id
  • position
  • prn
  • follow_up_time
  • follow_up_unit
  • appointment_length
  • scheduling_ok_to_double_book
  • scheduling_next_available
  • scheduling_as_previously_scheduled
  • scheduling_once_testing_is_complete
  • scheduling_prn
  • scheduling_with_physician
  • scheduling_with_pa
  • scheduling_with_np
  • scheduling_with_staff
  • scheduling_by_phone
  • other_instructions
  • firm_global_id

Follow up reason(s) set for a visit follow up. One row per visit follow up/reason.

  • visit_follow_up_reason_id
  • visit_follow_up_id
  • patient_id
  • reason
  • firm_global_id

Quality measures calculated for a visit. Only for finalized visits. One row per visit/quality measure.

  • visit_quality_measure_id
  • visit_id
  • patient_id
  • facility_id
  • staff_id
  • quality_measure
  • performance
  • modifier
  • procedure_modifier
  • numerator_code
  • override_code
  • override_modifier
  • override_numerator_code
  • override_quality_measure
  • reporting_year
  • archived
  • firm_global_id

Vitals taken during a visit. One row per visit/vitals measurement set. May enter multiple measurement sets in one visit.

  • vitals_id
  • visit_id
  • patient_id
  • taken_by_id
  • vitals_date
  • bp_diastolic
  • bp_systolic
  • bp_position
  • height
  • units_height
  • weight
  • units_weight
  • pulse
  • respiration
  • temperature
  • units_temperature
  • oxygen_saturation
  • firm_global_id