Validating emergency department vital signs using a data quality engine for data warehouse.
Validating emergency department vital signs using a data quality engine for data warehouse.
复制标题
DOI：
10.2174/1874431101307010034
复制
发表时间：
2013-01-01
期刊：
影响因子：
--
通讯作者：
Baumlin, K
中科院分区：
文献类型：
--
作者：
Genes, N;Chandra, D;Baumlin, K
背景技术背景：在我们的急诊科信息系统中的生命体征被输入到自由文本字段的心率，呼吸率，血压，体温和氧饱和度。目的：我们试图将这些文本条目转换成一个更有用的形式，为研究和QA的目的，在进入数据仓库。我们推导出一系列规则，并为转换后的值分配质量分数，符合生理参数的生命体征在整个年龄范围和疾病谱在急诊科看到。验证这些条目显示，98%的自由文本数据具有完美的质量分数，符合既定的生命体征参数。平均生命体征随年龄的变化符合预期。质量评分的下降最常见的原因是记录温度（华氏度而不是摄氏度）;具有此错误的生命体征仍可转换使用。错误发生更频繁的高分流期间，虽然错误率并没有与分流volume.CONCLUSIONS：在开发一种方法，从我们的急诊科信息系统导入自由文本的生命体征数据，我们现在有一个数据仓库，一个广泛的阵列的质量检查的生命体征，允许分析和人口统计学和结果的相关性。
BACKGROUND: Vital signs in our emergency department information system were entered into free-text fields for heart rate, respiratory rate, blood pressure, temperature and oxygen saturation.OBJECTIVE: We sought to convert these text entries into a more useful form, for research and QA purposes, upon entry into a data warehouse.METHODS: We derived a series of rules and assigned quality scores to the transformed values, conforming to physiologic parameters for vital signs across the age range and spectrum of illness seen in the emergency department.RESULTS: Validating these entries revealed that 98% of free-text data had perfect quality scores, conforming to established vital sign parameters. Average vital signs varied as expected by age. Degradations in quality scores were most commonly attributed logging temperature in Fahrenheit instead of Celsius; vital signs with this error could still be transformed for use. Errors occurred more frequently during periods of high triage, though error rates did not correlate with triage volume.CONCLUSIONS: In developing a method for importing free-text vital sign data from our emergency department information system, we now have a data warehouse with a broad array of quality-checked vital signs, permitting analysis and correlation with demographics and outcomes.