Sha256: a61d27f32a770020e8493518e0b5275eee0af0d7b696511f89f45e9e23f7b4b9
Contents?: true
Size: 971 Bytes
Versions: 11
Compression:
Stored size: 971 Bytes
Contents
SELECT distinct on (mp.patient_id, mp.id)
mp.id,
mp.patient_id,
mp.drug_id,
mp.treatable_type,
mp.treatable_id,
mp.dose_amount,
mp.dose_unit,
mp.medication_route_id,
mp.route_description,
mp.frequency,
mp.notes,
mp.prescribed_on,
mp.provider,
mp.created_at,
mp.updated_at,
mp.created_by_id,
mp.updated_by_id,
mp.administer_on_hd,
mp.last_delivery_date,
drugs.name as drug_name,
drug_types.code AS drug_type_code,
drug_types.name AS drug_type_name
FROM medication_prescriptions mp
left outer join medication_prescription_terminations mpt ON mpt.prescription_id = mp.id
inner JOIN drugs ON drugs.id = mp.drug_id
left outer join drug_types_drugs ON drug_types_drugs.drug_id = drugs.id
left outer join drug_types ON drug_types_drugs.drug_type_id = drug_types.id
where (mpt.terminated_on IS NULL OR mpt.terminated_on > current_date)
order by mp.patient_id asc, mp.id asc;
Version data entries
11 entries across 11 versions & 1 rubygems