Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
SELECT pi.identifier, cn.name, o.value_datetime, o.concept_id, o.value_coded FROM episode_encounter ee JOIN obs o ON o.encounter_id = ee.encounter_id AND o.concept_id = 1605 AND DATE(o.obs_datetime) <> DATE(o.value_datetime) JOIN concept_name cn ON cn.concept_id = o.concept_id AND cn.concept_name_type = 'FULLY_SPECIFIED' JOIN episode_patient_program epp ON epp.episode_id = ee.episode_id JOIN patient_program pp ON pp.patient_program_id = epp.patient_program_id JOIN patient_program_attribute ppa ON ppa.patient_program_id = epp.patient_program_id AND ppa.voided = 0 JOIN patient_identifier pi ON pi.patient_id = pp.patient_id JOIN person p ON p.person_id = pi.patient_id; |
Page Comparison
Manage space
Manage content
Integrations