以線上分析處理技術分析急診病患72小時內回診相關因素與特性-以某區域教學醫院為例

An Application of Online Analytical Processing on Investigating Related Factors and Characteristics Which Effect 72-Hour Emergency Department Revisits -Based on Experiences from Regional Teaching Hospital

陳志文(Chih-Wen Chen)

指導教授 ： 蔡正發

國立屏東科技大學/管理學院/高階經營管理碩士在職專班/碩士(2016年)

摘要

臺灣自1995年三月開辦全民健保以來，於近二十年間隨著全民健保普及化、民眾就醫習慣改變、與急診本身的24小時營運及快速服務等特性，急診的醫療量呈現大幅成長。急診已成為人民重要就醫第一道窗口，而由於急診所遇疾病常具多樣性、急迫性、與潛在危險等特性，且急診醫師常需在短時間內即對病情做下判斷與處置，故急診品質好壞攸關全民健康福祉。針對急診醫療現有諸多監控機制，而從醫院各項急診相關評鑑，到各種急診醫療品質指標，總有著「急診72小時返診比率」這一項目。且72小時內返診之病患常易有併發症，會增加民眾與醫院後續醫療成本。
現今資訊系統是醫院醫療運作基本架構，其已累積了龐大有用資料於儲存裝置中，但醫療人員常坐擁寶山卻不知如何開發運用。本研究先行建立資料倉儲(Data Warehouse)，再執行線上分析處理(Online Analytical Processing ,OLAP)。利用OLAP多層次操作功能，在各資料維度中運用向上整合、向下分析、橫向比較等方法而獲得許多重要結論。
本研究獲得結果:病患返診後檢傷級數一級與二級之重症病患比率增加；而五級輕症病患比率亦有增加。返診後住院率為30.63%遠高於一般急診病患住院率。返診前檢傷一級病患，返診後有最高住院率(80.95%)。返診病患前次離急診動態為「自動出院」者，有高住院率，較嚴重者有死亡個案。返診後前三大診斷依次為：腹痛、發燒、非傳染性胃腸炎及大腸炎，但醫師間有個別差異。返診診斷為發燒者有高住院率，逾五成患者須進一步醫療處置。同時有急專、內專訓練者返診率較平均返診率低。結論與建議：返診病患病情變化呈現輕重症二端比率皆增加，當設法降低重症返診與安排輕症非急診醫療管道。原檢傷一級病患與自動出院病患返診後病情最為嚴重，對此類病患離院時宜作更多評估與處置。每位急診醫師常見返診的診斷略有差異，經由大數據分析可得醫師個人化資料，作為改善與監測工具。

關鍵字：急診、72小時返診、線上分析處理

關鍵字

急診 ； 72小時返診 ； 線上分析處理

並列摘要

Since the Taiwan national health insurance system was established starting 1995, the population of the emergency department has increased tremendously in the recent 20 years due to the following: the popularization of the national health insurance system, the change of health seeking customs and the 24 hour fast service offered by the emergency department. The emergency department has become the public’s first priority medical choice, together with the variety, promptness and potential danger that the emergency department might come upon, the quality of the emergency department crew’s medical judgment and treatment is crucial for assuring public health. Therefore, various emergency department quality control systems, such as emergency department related evaluations and emergency department medication criteria include “72-hour Emergency Department Return Rate” unexceptionally. Moreover, 72-hour emergency department revisiting patients usually return with complications, which is likely to raise further public and hospital medical costs.
Nowadays, ‘the data system’ used to store enormous patient information has become the basic structure for hospital operation in most hospitals, however efficient application still remains unexplored. This research will start with the establishment of ‘Data Warehouse’, following the execution of ‘Online Analytical Processing’, then integrate, analyze and compare data by manipulating the multi dimensional data function of OLAP in order to pursue prominent conclusions.
The results are as follows: the ratio of critical medical condition patients among triage level 1 and 2 revisiting patients is raised. In addition, the ratio of level 5 non-urgent patients is also raised. Revisiting patients’ admission rate reached 30.63%, much higher than that of the emergency department. The admission rate of previous triage level 1 revisiting patients is the highest (80.95%). Revisiting patients who discharged against medical advice (AMA) during the previous visit show high admission rate, even more severe, death cases. The top three priority of revisiting diagnosis are: abdominal pain, fever and non-transmissible gastroenteritis, yet diagnosis between medical crew show individual difference. Revisiting diagnosis with fever show high admission rate, up to 50% patients require further health treatment. The rate of revisiting patients treated by the emergency doctor with both emergency and internal medicine training is lower than average.
Conclusions and suggestions of this research are as follows: the rates of revisiting patient’s condition among critical medical condition and non-urgent patients are raised at both extremes, thus decreasing critical medical condition revisiting patients and optional medical assistance arrangement for non-urgent patients should be made. Triage level 1 and AMA discharge patients suffer most severe condition, so more evaluation and management should be executed prior to the patient’s discharge. Common diagnosis among revisiting patients directed by each emergency doctor show difference. However, individual information can be sought via Big Data analysis, serving simultaneously as an improvement and monitoring tool.

Keywords: Emergency Department, 72-hour revisit, Online Analytical Processing

並列關鍵字

Emergency Department ； 72-hour revisit ； Online Analytical Processing

參考文獻

1. 周美儀、林淑美、黃莉蓉、趙子傑（2012）。2011年 [醫院評鑑持續性監測制度] 試辦作業成果分享。醫療品質雜誌，6(2)，P58 - 62。

2. 邱曉彥、 陳麗琴、 林琇珠、桑潁潁、康巧娟、 邱艷芬（2008）。台灣急診檢傷新趨勢-五級檢傷分類系統。護理雜誌，55(3)，P.87-91。

11. 葉時烊、胡百敏、廖浩欽、林作彥、王少谷、廖訓禎(2010)。急診病人三日內重返急診之分析: 全民健康保險研究資料庫之抽樣歸人檔資料分析。台灣急診專科醫師期刊，2(1), P.6-13。

12. 廖熏香（2011）。指標系統再進化-臺灣臨床成效指標介紹。醫療品質

診的急診病患: 分析危險因子和回診原因。中華民國急救加護醫學會雜誌。14(3)，P. 93-98。