Sha256: cc5b40904fb48d5ea63e20df4e2579b704c67e1b7eaaf176715ee68bd08557db
Contents?: true
Size: 1.46 KB
Versions: 15
Compression:
Stored size: 1.46 KB
Contents
select
P.id,
P.secure_id,
(upper(P.family_name) || ', ' || P.given_name) as "patient_name",
P.nhs_number,
P.local_patient_id as hospital_numbers,
P.sex,
P.born_on,
date_part('year', age(P.born_on)) as "age",
RPROF.esrf_on,
Mx.modality_name,
case when pw.id > 0 then true else false end as on_worryboard,
(select bmi from clinic_visits cv2 where cv2.patient_id = P.id and bmi > 0 order by date desc limit 1) as bmi,
TXRSD."name" tx_status,
PA.values -> 'HGB' ->> 'result' as hgb,
(PA.values -> 'HGB' ->> 'observed_at')::date as hgb_date,
PA.values -> 'URE' ->> 'result' as ure,
(PA.values -> 'URE' ->> 'observed_at')::date as ure_date,
PA.values -> 'CRE' ->> 'result' as cre,
(PA.values -> 'CRE' ->> 'observed_at')::date as cre_date,
PA.values -> 'EGFR' ->> 'result' as egfr
from renalware.patients P
left join patient_worries pw on pw.patient_id = p.id
left outer join renalware.pathology_current_observation_sets PA on PA.patient_id = P.id
left outer join renalware.renal_profiles RPROF on RPROF.patient_id = P.id
left outer join renalware.transplant_registrations TXR on TXR.patient_id = P.id
left outer join renalware.transplant_registration_statuses TXRS on TXRS.registration_id = TXR.id AND TXRS.terminated_on IS NULL
left outer join renalware.transplant_registration_status_descriptions TXRSD on TXRSD.id = TXRS.description_id
inner join renalware.patient_current_modalities Mx on Mx.patient_id = P.id and Mx.modality_code = 'supportive_care'
Version data entries
15 entries across 15 versions & 1 rubygems