Clinical Indicators Monitoring System Research And Implementation Of ETL Process

After the new healthcare reform,the national health insurance system structure has basically taken shape in China.The implementation of the medical insurance system has changed the clinical medical model,from the experience of medical treatment to the transition of evidence-based medicine,the highly integrated hospital information management system.China healthcare reform in the transition from a personal payment system to different levels of health care system.Medical expenses has gradually become an important part and a heavy burden of the state and every family.The implementation of healthcare system requires hospitals to provide low-cost,high quality,wide coverage of medical services.Based on this,the Clinical Indicators monitoring system is used to solve the following problems: financial opportunities,medical quality,disease thinning,doctor behavior,clinical optimization.At the same time,the top three hospitals in China,including data collection,index definition,behavior analysis to achieve the medical administrators to help and improve.The Clinical Indicators monitoring system is dedicated to helping the hospital administrator to read healthcare information to avoid unnecessary financial losses.The financial and management loopholes that may exist in hospital management.Tips for hospital managers to carry out process and medical quality optimization of the starting point.Implement highly integrated hospital information system,so that the hospital management decisionmaking should be gradually to the data based decision analysis of the transition.Through the combination of theory and practice,this study takes into account the international and domestic environment and the status quo,combined with China's specific situation and problems and to explore and implement the Clinical Indicators monitoring system based on the top three hospitals as a pilot.Specific research purposes: 1.Clear indicator definition;2.Collect interface data of top three hospitals,3.Define data cleaning rules;4.ICD encoding's definition and unity;5.Data modeling and building data warehouse;6.Data exchange ETL process;7.Re defining the reference standard;8.Finally,the dynamic algorithm is used to realize the function of early warning;Through the literature search to grasp the definition of clinical medical indicators at home and abroad,encoding rule definition and the definition of related technologies to develop the research content,the late use of the project to collect information and compare the data collected in the top three hospitals.The system collects data from 2012/5 to 2013/7,contains Hospital Information System,electronic,medical record data and other data information.Results:1.Financial opportunity report: according to the foreign medical insurance process and medical insurance payment information,develop a few more important index,to different weight,calculate the general of a disease of reasonable cost,a hospital reference to the reasonable cost as the basis to calculate the savings can save money.Such as the total number of patients,the severity of the disease,the average length of hospital stay,and then the hospital admission rate,the average rate of death,iatrogenic complications,etc..2.Medical quality report: according to the system standard,according to the diagnosis and treatment process of each common disease of the important medical indicators,evaluation of target hospitals in the disease management performance,for the management of medical quality control.3.Disease detailed analysis report: Based on a common disease,collect all the expenses in the clinical path,including the different departments,different drugs and auxiliary examination,so that decision-makers clearly see the cost of the disease.4.The doctor reported: system to understand the doctor's diagnosis and treatment behavior,including the number of admissions of patients,the disease severity and the evaluation of the different indicators of the patient management,can objectively evaluate the doctor of clinical medical level.Through 1 years of hospital data collection,the pilot application found that only 17% of data in the sampling data including diagnostic code and no code,discharge status,hospitalization type and hospital sources are not complete,the lack of these data to at least affect the 55% indicators.The average length of stay in China is 10.97 days and the United States is 4 days,so the reference standard should be redefined.