hosxp+รายงาน LAB เบาหวาน
select distinct v.vn,v.hn,v.vstdate,v.spclty,c.clinic,p.pname,p.fname,p.lname,v.pdx,v.dx0,v.dx1,v.dx2,v.dx3,v.dx4,v.dx5,
o.bpd,o.bps,o.egfr,o.bmi,
lb1.lab_order_result as ‘BUN’,
lb2.lab_order_result as ‘CR’,
lb3.lab_order_result as ‘Uric asid’,
lb6.lab_order_result as ‘TG’,
lb7.lab_order_result as ‘Chol’,
lb8.lab_order_result as ‘K+’,
lb9.lab_order_result as ‘HDL’,
lb10.lab_order_result as ‘LDL’,
lb11.lab_order_result as ‘HbA1C’,
lb12.lab_order_result as ‘MALB+’,
lb13.lab_order_result as ‘Protein’
from vn_stat v
left outer join lab_head lh on lh.vn=v.vn
left outer join opdscreen o on o.vn=v.vn
left outer join patient p on p.hn=v.hn
left outer join lab_order lb on lb.lab_order_number=lh.lab_order_number
left outer join lab_order lb1 on lb.lab_order_number=lb1.lab_order_number and lb1.lab_items_code in (’77’)
left outer join lab_order lb2 on lb.lab_order_number=lb2.lab_order_number and lb2.lab_items_code in (’78’)
left outer join lab_order lb3 on lb.lab_order_number=lb3.lab_order_number and lb3.lab_items_code in (’79’)
left outer join lab_order lb6 on lb.lab_order_number=lb6.lab_order_number and lb6.lab_items_code in (‘103’)
left outer join lab_order lb7 on lb.lab_order_number=lb7.lab_order_number and lb7.lab_items_code in (‘102′)
left outer join lab_order lb8 on lb.lab_order_number=lb8.lab_order_number and lb8.lab_items_code in (’91’)
left outer join lab_order lb9 on lb.lab_order_number=lb9.lab_order_number and lb9.lab_items_code in (’92’)
left outer join lab_order lb10 on lb.lab_order_number=lb10.lab_order_number and lb10.lab_items_code in (’81’)
left outer join lab_order lb11 on lb.lab_order_number=lb11.lab_order_number and lb11.lab_items_code in (‘198’)
left outer join lab_order lb12 on lb.lab_order_number=lb12.lab_order_number and lb12.lab_items_code in (‘225′)
left outer join lab_order lb13 on lb.lab_order_number=lb13.lab_order_number and lb13.lab_items_code in (’45’)
left outer join clinicmember c on c.hn=v.hn
where v.vstdate between ‘2012-11-01’ and ‘2013-05-31′ and v.spclty=’13’ and c.clinic in (‘001′,’002’)
and lb.lab_items_code in (‘225′,’77’,’78’,’79’,’103′,’102′,’91’,’92’,’81’,’198′,’45’)
ตัวชี้วัด คลีนิคพิเศษ
select distinct v.vn,v.hn,v.vstdate,v.spclty,c.number,p.pname,p.fname,p.lname,v.pdx,v.dx0,v.dx1,v.dx2,v.dx3,v.dx4,v.dx5,
o.bpd,o.bps,o.egfr,o.bmi,lb.lab_items_name_ref,lb.lab_order_result as resultlab,lb.lab_items_code
from vn_stat v
left outer join lab_head lh on lh.vn=v.vn
left outer join opdscreen o on o.vn=v.vn
left outer join patient p on p.hn=v.hn
left outer join lab_order lb on lb.lab_order_number=lh.lab_order_number
left outer join clinicmember c on c.hn=v.hn
where v.vstdate between ‘2012-11-01’ and ‘2013-05-31′ and v.spclty=’13’
and lb.lab_items_code in (‘377′,’77’,’78’,’79’,’219′,’601′,’103′,’102′,’91’,’92’,’81’)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
select pq.doctor,d.name,
count(pq1.vn) as total_OPD,count(pq2.vn) as total_ER,
count(pq3.vn) as total_Dent,count(pq4.vn) as total_LR,
count(pq.vn) as total_All
from pq_doctor pq
left outer join doctor d on d.code = pq.doctor
left outer join pq_doctor pq1 on pq1.vn = pq.vn
and pq1.doctor = pq.doctor and pq.depcode = ‘001’
left outer join pq_doctor pq2 on pq2.vn = pq.vn
and pq2.doctor = pq.doctor and pq.depcode = ‘002’
left outer join pq_doctor pq3 on pq3.vn = pq.vn
and pq3.doctor = pq.doctor and pq.depcode = ‘003’
left outer join pq_doctor pq4 on pq4.vn = pq.vn
and pq4.doctor = pq.doctor and pq.depcode = ‘004’
where pq.doctor_date between ‘2010-05-01’ and ‘2010-05-10’
and pq.depcode in (‘001′,’002′,’003′,’004’)
group by pq.doctor
order by pq.doctor
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ผู้ป่วยคลีนิคเบาหวาน FBS or DTX น้อยกว่าหรือเท่ากับ 130 หยิบมาจาก hosxp.net ขอบคุณที่ให้ความรู้ครับ เดียวจะมาประยุกต์ใช้ดูครับ
select distinct v.hn,v.vstdate,c.number,concat(p.pname,p.fname,” “,p.lname) as ptname,lb.lab_order_result as LDL
from vn_stat v
left outer join lab_head lh on lh.vn=v.vn
left outer join opdscreen o on o.vn=v.vn
left outer join patient p on p.hn=v.hn
left outer join lab_order lb on lb.lab_order_number=lh.lab_order_number
left outer join clinicmember c on c.hn=v.hn
where v.vstdate between ‘2009-02-01’ and ‘2009-06-31’ and c.clinic =”001″ and v.spclty =”01” and lb.lab_order_result <=130 and lb.lab order_result is not null and lb.lab_order_result <>””and lb.lab_items_code in (‘3073’, ‘3045’, ‘3001’, ‘3036’)
ความเห็นล่าสุด