上海口腔医学

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

• 临床研究 • 上一篇    下一篇

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

董正杰1，徐侃2   

  1. (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-jie1, XU Kan2   

  1. 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

PDF (PC)

345

被引次数

2

摘要： 目的：探讨建立种植修复患者的预约表格，通过其颜色改变，提示各种植修复患者的预约时间，并通过其与相应种植电子病历文档的链接和编号，实现种植电子病历库的建立和科学管理。方法：以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

中图分类号: