种植患者预约电子档案的建立和管理

上海口腔医学 ›› 2013, Vol. 22 ›› Issue (5): 562-566.

种植患者预约电子档案的建立和管理

董正杰¹，徐侃²

(1.上海市口腔病防治院口腔种植门诊，上海 200001；2.上海交通大学医学院附属第九人民医院?口腔医学院口腔修复科，上海 200011)

收稿日期:2013-05-06 修回日期:2013-06-21 出版日期:2013-10-10 发布日期:2013-10-10
通讯作者: 徐侃，E-mail：xukan66@hotmail.com
作者简介:董正杰(1978-)，男，硕士，主治医师，

Establishment and management of electronic appointment library for dental implant patients

DONG Zheng-jie¹, XU Kan²

1.Department of Oral Implant, Shanghai Stomatological Disease Centre. Shanghai 200001; 2. Department of Prosthodontics, Ninth People’s Hospital, College of Stomatology, Shanghai Jiao Tong University School of Medicine. Shanghai 200011, China

Received:2013-05-06 Revised:2013-06-21 Online:2013-10-10 Published:2013-10-10

摘要/Abstract

摘要： 目的：探讨建立种植修复患者的预约表格，通过其颜色改变，提示各种植修复患者的预约时间，并通过其与相应种植电子病历文档的链接和编号，实现种植电子病历库的建立和科学管理。方法：以Windows XP为操作系统，2003 Microsoft Excel 应用软件为基础，设计成Excel表格。通过对Excel应用软件中“条件格式”命令的设置，使表格相应行随患者预约时间变化而改变颜色，达到提醒预约时间的目的，并对表格中种植患者姓名或种植电子病历编号与相应种植电子病历库中的文档建立相应链接。结果：建立并设置了Excel表格。当天进行种植Ⅰ期手术的患者，该行底色自动显示为红色；种植术后患者骨结合时间即将到来前2周，该行底色自动显示为黄色；当天预约好进行Ⅱ期手术或上部结构修复的复诊患者，该行底色自动显示为绿色；已经种植修复完成的患者，该行底色设置为灰色。通过点击患者姓名或种植编号，可以直接打开该患者的种植电子病历，查阅其种植基本情况。结论：通过表格颜色的变化提示种植患者的预约时间，并通过表格中患者姓名或编号的相应链接直接查阅患者的种植电子病历，具有一定的临床实用价值。

关键词: 种植预约, 电子病历, 口腔种植, 条件格式

Abstract: PURPOSE: To design an excel form which can prompt dental implant patient appointment through color change, which can scientifically manage implant EMR library through appropriate interlinkage and number. METHODS: An excel form based on operating system Windows XP was designed and software 2003 Microsoft excel was used, which was configured to change color with the passage of time by the use of command “conditional format”. RESULTS: An excel form was designed. The color turned to red automatically on the day the patient underwent implant surgery. It turned to yellow when the patient recalled 2 weeks after the first operation, to green when the patient underwent secondary operation. It was designed to be gray when all the procedures of implant restoration was finished. In addition, we could know patients’ main implant situation through directly opening his EMR when clicking on his name or number. CONCLUSIONS: Dentists can remind the implant patient appointment schedule through color change of an excel form, and can consult the implant patient EMR directly through interlinkage or number.

Key words: Implant appointment, Electronic medical record, Dental implant, Conditional format

中图分类号:

R782.12

董正杰, 徐侃. 种植患者预约电子档案的建立和管理[J]. 上海口腔医学, 2013, 22(5): 562-566.

DONG Zheng-jie, XU Kan. Establishment and management of electronic appointment library for dental implant patients[J]. Shanghai Journal of Stomatology, 2013, 22(5): 562-566.

参考文献

[1] 王鲲鹏. 即刻种植的研究进展[J].国际口腔医学杂志,2012,39(1): 136-139.
[2] 董凯. 种植体周围骨吸收影响因素的研究进展 [J]. 中国口腔种植学杂志, 2011, 16(3): 192-196.
[3] 石倚天, 赖红昌, 张志勇. 种植相关的牙槽嵴保存技术 [J]. 口腔材料器械杂志, 2011, 20(4): 208-211.
[4] 谢煜庭,乔志平.种植体与天然牙联合固定修复的临床观察 [J]. 中国口腔种植学杂志, 2013, 18(1): 46-47.
[5] 高强, 戴俊峰, 王传堂. 多层螺旋CT在牙种植术前评估的应用价值 [J]. 实用医学影像杂志, 2012, 13(5): 331-332.
[6] 刘薇丽, 张秋霞. 上颌窦内提升术种植修复上颌后牙缺失的临床观察 [J]. 中国口腔种植学杂志, 2012, 17(2): 80-82.
[7] 刘文伟,张继东.上颌窦内提升技术在口腔种植修复中的应用 [J]. 中国口腔种植学杂志, 2011, 16(3): 175-177.
[8] 韩永战, 吴友农. 关于上-下标牙位记录法[J]. 口腔生物医学, 2012, 3(3): 149-150,158.
[9] 高艳梅. 口腔种植电子病历系统建立的研究进展 [J]. 中国实用口腔科杂志, 2011, 4(9): 561-563.
[10] Noar JH, Shupac M. An orthodontic patient administration system (OPAS) for complete departmental management [J]. J Orthod, 2001, 28(1): 70-75.
[11] Filker PJ, Muckey EJ, Kelner SM, et al. Taking a quality assurance program from paper to electronic health records: one dental school’s experience [J]. J Dent Educ, 2009, 73(9): 1095-1101.
[12] 郑其望,李志文.电子病历的概念与发展趋势 [J]. 医学信息学杂志, 2008, 29(10): 50-53.
[13] 王海涛,潘巨利.增龄变化对钛种植体骨结合影响的实验研究[J]. 北京口腔医学, 2008, 16(2): 65-68.
[14] 周炜, 宋应亮, 李德华, 等. 种植体骨结合稳定性测量及相关因素分析 [J]. 实用口腔医学杂志, 2006, 22(6): 803-806.