Sha256: df10c9b4e4288f1b133232d60d0da001d6f74bb791b7f14a0b871171624d5fd8
Contents?: true
Size: 1.87 KB
Versions: 17
Compression:
Stored size: 1.87 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 where 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,
case when TXRSD.code not ilike '%permanent' then true else false end as tx_candidate,
case
when (convert_to_float(PA.values->'HGB'->>'result') < 100.0) then '< 100'
when (convert_to_float(PA.values->'HGB'->>'result') > 130.0) then '> 130'
else NULL
end as hgb_range,
case
when (convert_to_float(values->'URE'->>'result') >= 30.0) then '>= 30'
else NULL
end as urea_range
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 and TXRS.started_on <= current_date
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 = 'low_clearance'
Version data entries
17 entries across 15 versions & 1 rubygems