Canadian Journal of Anesthesia, Vol 39, 716-723, Copyright © 1992 by Canadian Anesthesiologists' Society

ARTICLES

Development of a computerized database for the study of anaesthesia care

DK Rose, MM Cohen, DF Wigglesworth and DA Yee
Department of Anaesthesia, St. Michael's Hospital, Toronto, Ontario.

To record, tabulate and report problems associated with anaesthesia, we have developed an information collection system and computer software to follow all patients attended by an anaesthetist at a teaching hospital in Canada. For the last 15 mo, data for 17,000 patients have been collected and the system is ongoing. Data collection is from three sources: carbonless copies of the handwritten Operating Room (OR) and Post Anaesthetic Care Unit (PACU) records, other hospital databases, and postoperative visits. Adverse events (observations which differ from specific physiological variables, or require an intervention and do not normally occur during the routine conduct of anaesthesia), are defined directly on each OR and PACU record. These events are recorded when they occur by the attending anaesthetist or the PACU nurse. All data are verified by a research nurse and an anaesthetist. Computer software, developed from DBase IV, is used to track 95 individual items on preoperative status and anaesthetic technique and another possible 1,450 selections for drugs, physicians, airways, surgical procedures and events for each patient. Data are analyzed with SAS software and reports generated to link the casemix and process with outcome. Comparison of data entered into the computer programme to a retrospective chart review revealed discrepancies of less than 0.5%. Collection, verification and computer entry takes five minutes per patient and the on-going cost is estimated at $4 per patient record. Analysis of the information collected in this database has been useful for research of adverse outcome following anaesthesia, resident expertise profiles, and the administrative management of an anaesthesia department.