Sha256: a6cc668e96096bbf651fb6396ba5693fcbee032dc77d936845d3b6b7113d2e96
Contents?: true
Size: 1.02 KB
Versions: 177
Compression:
Stored size: 1.02 KB
Contents
select p.id as patient_id, (select result from pathology_current_observations where description_code = 'HGB' and patient_id = p.id) as hgb_result, (select observed_at from pathology_current_observations where description_code = 'HGB' and patient_id = p.id) as hgb_observed_at, (select result from pathology_current_observations where description_code = 'CRE' and patient_id = p.id) as cre_result, (select observed_at from pathology_current_observations where description_code = 'CRE' and patient_id = p.id) as cre_observed_at, (select result from pathology_current_observations where description_code = 'URE' and patient_id = p.id) as ure_result, (select observed_at from pathology_current_observations where description_code = 'URE' and patient_id = p.id) as ure_observed_at, (select result from pathology_current_observations where description_code = 'MDRD' and patient_id = p.id) as mdrd_result, (select observed_at from pathology_current_observations where description_code = 'MDRD' and patient_id = p.id) as mdrd_observed_at from patients p
Version data entries
177 entries across 177 versions & 1 rubygems