BACKGROUND: Quality assurance is increasingly important in the current health care climate. An electronic database can be used for tracking patient information and as a research tool to provide quality assurance for patient care. OBJECTIVE: An electronic database was developed for the Acute Pain Service, University of Alberta Hospital (Edmonton, Alberta) to record patient characteristics, identify at-risk populations, compare treatment efficacies and guide practice decisions. METHOD: Steps in the database development involved identifying the goals for use, relevant variables to include, and a plan for data collection, entry and analysis. Protocols were also created for data cleaning quality control. The database was evaluated with a pilot test using existing data to assess data collection burden, accuracy and functionality of the database. RESULTS: A literature review resulted in an evidence-based list of demographic, clinical and pain management outcome variables to include. Time to assess patients and collect the data was 20 min to 30 min per patient. Limitations were primarily software related, although initial data collection completion was only 65% and accuracy of data entry was 96%. CONCLUSIONS: The electronic database was found to be relevant and functional for the identified goals of data storage and research.
BACKGROUND: Quality assurance is increasingly important in the current health care climate. An electronic database can be used for tracking patient information and as a research tool to provide quality assurance for patient care. OBJECTIVE: An electronic database was developed for the Acute Pain Service, University of Alberta Hospital (Edmonton, Alberta) to record patient characteristics, identify at-risk populations, compare treatment efficacies and guide practice decisions. METHOD: Steps in the database development involved identifying the goals for use, relevant variables to include, and a plan for data collection, entry and analysis. Protocols were also created for data cleaning quality control. The database was evaluated with a pilot test using existing data to assess data collection burden, accuracy and functionality of the database.  RESULTS: A literature review resulted in an evidence-based list of demographic, clinical and pain management outcome variables to include. Time to assess patients and collect the data was 20 min to 30 min per patient. Limitations were primarily software related, although initial data collection completion was only 65% and accuracy of data entry was 96%. CONCLUSIONS: The electronic database was found to be relevant and functional for the identified goals of data storage and research.
Authors: Florian D Naal; Carl Neuerburg; Gian M Salzmann; Monika Kriner; Fabian von Knoch; Stefan Preiss; Tomas Drobny; Urs Munzinger Journal: Arch Orthop Trauma Surg Date: 2008-04-15 Impact factor: 3.067
Authors: Debra B Gordon; June L Dahl; Christine Miaskowski; Bill McCarberg; Knox H Todd; Judith A Paice; Arthur G Lipman; Marilyn Bookbinder; Steve H Sanders; Dennis C Turk; Daniel B Carr Journal: Arch Intern Med Date: 2005-07-25
Authors: Mohammad Sami Walid; Stephen N Donahue; Dana M Darmohray; Leon A Hyer; Joe Sam Robinson Journal: Pain Pract Date: 2008-07-25 Impact factor: 3.183
Authors: Colleen J Dunwoody; Dina A Krenzischek; Chris Pasero; James P Rathmell; Rosemary C Polomano Journal: J Perianesth Nurs Date: 2008-02 Impact factor: 1.084