Abstract:

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.

Key words: Tuberculosis,multidrug resistance, Multiphasic screening, Population surveillance, Software design, Database management systems