Sha256: e42b22ffd9138fc9f2ffaa2b91bf4f50ef64ce2cdd96b9b92675bcd32a77c6bd
Contents?: true
Size: 1.77 KB
Versions: 15
Compression:
Stored size: 1.77 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,
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
15 entries across 15 versions & 1 rubygems