ตัวชี้วัด คลีนิคพิเศษ
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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ใส่ความเห็น
คุณต้องเข้าสู่ระบบ เพื่อจะพิมพ์ความเห็น