基于Power Pivot构建新病原学阳性肺结核患者耐药筛查辅助监测系统  

Construction of a monitoring system for drug resistance screening of new pathogen positive pulmonary tuberculosis cases based on Power Pivot

作　　者：闫银锁 陶荔莹[1] 张红伟[1] 李艳圆 高志东[1] YAN Yin-suo;TAO Li-ying;ZHANG Hong-wei;LI Yan-yuan;GAO Zhi-dong(Department of Prevention and Control,Beijing Research Institute for Tuberculosis Control,Beijing 1000359 China)

机构地区：[1]北京结核病控制研究所防控科

出　　处：《结核病与肺部健康杂志》2019年第4期294-298,共5页Journal of Tuberculosis and Lung Health

基　　金：首都卫生发展科研专项（2011-1012-01）

摘　　要：为了及时掌握新病原学阳性肺结核患者耐药筛查工作质量,规范耐药筛查工作,作者采用Power Pivot工具构建耐药筛查辅助监测系统。系统建成后能够按照年、季度等时间条件,区、机构等地域条件生成不同交互维度下新病原学阳性患者耐药筛查报表,并精准生成未进行耐药筛查患者名单。Power Pivot工具作为《中国疾病预防控制信息系统》子系统《结核病信息管理系统》统计模块的辅助和补充,可为灵活、快速、准确反映耐药筛查工作质量提供解决方案。In order to understand the quality of drug resistance screening for new pathogen positive tuberculosis(TB)cases and standardize the drug resistance screening,Power Pivot tool was used in this study to construct a drug resistance screening auxiliary monitoring system.After the construction of the system,it can generate the drug resistance screening reports of new pathogen positive TB patients in different interactive dimensions according to the time conditions such as year,quarter and regional conditions such as region,institution,and accurately generate the list of patients who not screened for drug resistance.As an assistant and supplement to the statistical module of Tuberculosis Information Management System,a subsystem of the China Information System for Disease Control and Prevention,the tool provides a solution to reflect the quality of drug resistance screening work flexibly,quickly and accurately.

关 键 词：结核 抗多种药物性 多相筛查 人群监测 软件设计 数据库管理系统 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]