CC/HPI

This section contains chief complaint and history of present illness data.

Records patients following up on a previous visit. Different than a chief complaint collected in the hpi_response_* tables.

  • hpi_follow_up_id
  • diagnosis_referenced_id
  • visit_id
  • patient_id
  • follow_up_reason
  • status
  • treatment_compliant
  • firm_global_id

One or more measurements associated with a follow up. Measurements are defined and entered for each diagnosis the patient is following up on.

  • hpi_follow_up_measurement_id
  • hpi_follow_up_id
  • patient_id
  • variable
  • title
  • question_text
  • type
  • value
  • value_title
  • firm_global_id

Additional information collected for each follow up. Multi-select responses for each question. One row per follow up/question/value.

  • hpi_follow_up_value_id
  • hpi_follow_up_id
  • patient_id
  • question
  • value
  • firm_global_id

Chief complaint and History of Present Illness (HPI) taken during a visit. NOTE: All hpi questions are patient-reported, and thus may differ from other structured information inputted by a physician.

  • hpi_response_id
  • visit_id
  • patient_id
  • body_detail_level
  • chief_complaint
  • context
  • duration
  • location
  • modifying_factors
  • quality
  • severity
  • signs_and_symptoms
  • timing
  • firm_global_id

One or more body locations associated with a chief complaint. Body locations are selected using a pre-defined anatomical atlas.

  • hpi_response_body_location_id
  • hpi_response_id
  • patient_id
  • body_part
  • simple_description
  • detail_description
  • zone
  • firm_global_id

Additional information collected about each chief complaint. Metadata items are defined and entered for each chief complaint. Records all question, single-input, and single-select responses.

  • hpi_response_metadata_id
  • hpi_response_id
  • patient_id
  • variable
  • question_text
  • type
  • component
  • value
  • duration_days
  • duration_months
  • duration_weeks
  • duration_years
  • firm_global_id

Multi-select responses for hpi_response_metadata. One or more rows per hpi_response_metadata_id.

  • hpi_response_metadata_selection_id
  • hpi_response_metadata_id
  • patient_id
  • value
  • text_value
  • firm_global_id