Definition

Purpose

The problem model extracts problem/diagnoses data for patients included in specific recruit studies. It captures clinical problems and chronic conditions recorded in EMIS Web with personally identifiable information preserved.

Information

This patient-linked model provides a record of significant clinical problems and diagnoses for patients. Each problem record is uniquely identified by emis_problem_guid and tracks problem status and resolution over time.

• emis_problem_guid (PK): The unique identifier for the problem record
• emis_patient_guid (FK): Patient identifier with PII preserved
• emis_code_id (FK): The clinical code for the problem
• study_id (FK): Study cohort identifier

Examples

Get all problems for a patient

SELECT *
FROM hive.explorer_recruit.problem
WHERE patient_id = 123456789
LIMIT 100;

Find problems for a specific study

SELECT *
FROM hive.explorer_recruit.problem
WHERE study_id = 'STUDY001'
LIMIT 100;

Find active problems with significance

SELECT
  emis_observation_guid,
  patient_id,
  problem_status_description,
  fhir_significance
FROM hive.explorer_recruit.problem
WHERE end_date IS NULL
  AND patient_id = 123456789
LIMIT 100;