诊断与病原一致性
附件5：确诊/病原携带者与实验室阳性、病种与病原名称一致性（日期区间）。
mid_disease_index · 具有实验室病原检测阳性结果的确诊病例或病原携带者病例
从左侧选择一条 SELECT
或点「一键概览」/「对比 HIS」。
服务器查询日志
2026-07-23 08:19:10
detail #1
50.0 ms
DB 127.0.0.1
mid_disease_index · 具有实验室病原检测阳性结果的确诊病例或病原携带者病例
total=7 page=1
--具有实验室病原检测阳性结果的确诊病例或病原携带者病例
select a.disease_name,a.serial_number,* from mid_disease_index a,mid_ex_lab_item b
where a.diagnose_state_code in ('2','4')
and a.mid_ex_lab_item_id=b.id
and (b.examination_result_code in ('01','04','05','06','15','16','17') or b.examination_quantification_ri='2')
and a.opflag='99'
and a.create_date::date BETWEEN '2026-07-01' and '2026-07-23'
and a.org_code='451123020'
order by a.create_date desc
2026-07-23 08:18:50
detail #1
45.0 ms
DB 127.0.0.1
mid_disease_index · 具有实验室病原检测阳性结果的确诊病例或病原携带者病例
total=0 page=1
--具有实验室病原检测阳性结果的确诊病例或病原携带者病例
select a.disease_name,a.serial_number,* from mid_disease_index a,mid_ex_lab_item b
where a.diagnose_state_code in ('2','4')
and a.mid_ex_lab_item_id=b.id
and (b.examination_result_code in ('01','04','05','06','15','16','17') or b.examination_quantification_ri='2')
and a.opflag='99'
and a.create_date::date BETWEEN '2026-07-23' and '2026-07-23'
and a.org_code='451123020'
order by a.create_date desc