Beyond Data Capture: A Single Institutional Experience with Establishing a Pelvic Floor Surgery Web Based Database

Wai Lee, Chris Du, Chong Choe, John D. Massman, Jason Kim, Una J. Lee, Alvaro Lucioni, Kathleen C. Kobashi

Research output: Contribution to journalArticlepeer-review

1 Scopus citations

Abstract

Introduction:The American Urological Association has highlighted the need for complete and long-term data collection in female pelvic medicine and reconstructive surgery. We describe our institution's experience with transitioning our pelvic floor surgery database to a secure web based platform. In this article we share this experience and its challenges to help facilitate the process for other institutions.Methods:In 1999 our institution implemented electronic data capture of pelvic floor cases using a stand-alone spreadsheet. By 2001 it was apparent that this modality could no longer sustain growth while maintaining data integrity. We converted to a relational database system but limitations involving multiuser data entry and efficient querying became apparent. After consultation with outcomes research experts across the country we evaluated database alternatives for capacity, ease of use and security. REDCap® (Research Electronic Data Capture), a low cost, server based database software, provided all 3.Results:In 2011 the transition of our electronic outcomes database to REDCap commenced. The transition required approximately 100 person-hours for data dictionary creation and 200 person-hours for the transfer of existing data into REDCap. A database administrator was hired to maintain data integrity, automate the process of generating questionnaires for long-term followup and facilitate data queries.Conclusions:We describe the transition of our institution's outcomes database to REDCap providing the means for secure and streamlined data capture and quality assurance. This platform also facilitates effective multi-institutional collaboration with the goals of developing quality data to advance research and improve care for our patients.

Original languageEnglish (US)
Pages (from-to)127-131
Number of pages5
JournalUrology Practice
Volume7
Issue number2
DOIs
StatePublished - Mar 1 2020

Keywords

  • data aggregation
  • database management systems
  • pelvic floor
  • reconstructive surgical procedures
  • urology

ASJC Scopus subject areas

  • Urology

Fingerprint

Dive into the research topics of 'Beyond Data Capture: A Single Institutional Experience with Establishing a Pelvic Floor Surgery Web Based Database'. Together they form a unique fingerprint.

Cite this