title: The development of an electronic database for Acute Pain Service outcomes.
abstract: 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.
  
  
  METHODS
  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.&nbsp;
  
  
  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.affiliation: Adult Acute Apin Service, University of Alberta Hospital. brandy.love@albertahealthservices.ca
authors.forename: Brandy L
authors.initials: BL
authors.lastname: Love
authors.forename: Louise A
authors.initials: LA
authors.lastname: Jensen
authors.forename: Donald
authors.initials: D
authors.lastname: Schopflocher
authors.forename: Ban Ch
authors.initials: BCh
authors.lastname: Tsui
mesh_terms: D059787:Acute Pain / Q000628:therapy*; D000293:Adolescent; D000328:Adult; D000368:Aged; D057286:Electronic Health Records / Q000706:statistics & numerical data*; D005260:Female; D006801:Humans; D020407:Internet; D008297:Male; D008875:Middle Aged; D018710:Pain Clinics; D059408:Pain Management; D010147:Pain Measurement; D055815:Young Adult