• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

SAGES

Reimagining surgical care for a healthier world

  • Home
    • COVID-19 Annoucements
    • Search
    • SAGES Home
    • SAGES Foundation Home
  • About
    • Who is SAGES?
    • SAGES Mission Statement
    • Strategic Plan, 2020-2023
    • Committees
      • Descriptions and Video Updates
      • Request to Join a SAGES Committee
      • SAGES Board of Governors
      • Officers and Representatives of the Society
      • Committee Chairs and Co-Chairs
      • Full Committee Rosters
      • SAGES Past Presidents
    • Donate to the SAGES Foundation
    • Awards
      • George Berci Award
      • Pioneer in Surgical Endoscopy
      • Excellence In Clinical Care
      • International Ambassador
      • IRCAD Visiting Fellowship
      • Distinguished Service
      • Early Career Researcher
      • Researcher in Training
      • Jeff Ponsky Master Educator
      • Excellence in Medical Leadership
      • Barbara Berci Memorial Award
      • Brandeis Scholarship
      • Advocacy Summit
      • RAFT Annual Meeting Abstract Contest and Awards
  • Meetings
    • COVID-19 Announcements
    • SAGES 2020 Meeting Information
    • 2021 Scientific Session Call For Abstracts
    • 2021 Emerging Technology Session Call For Abstracts
    • 2018 Prevent BDI Consensus Conference
    • CME Claim Form
    • Industry
      • Advertising Opportunities
      • Exhibit Opportunities
      • Sponsorship Opportunities
    • Future Meetings
    • Past Meetings
      • Leadership Development and Health Policy Conference Videos
      • SAGES Quality Summit Meeting
      • SAGES 2019
      • SAGES 2018
      • SAGES 2017
      • SAGES 2016
      • SAGES 2015
      • SAGES 2014
      • SAGES 2013
    • Related Meetings Calendar
  • Membership
    • Membership Benefits
    • Membership Applications
      • Active Membership
      • Affiliate Membership
      • Associate Active Membership
      • Candidate Membership
      • International Membership
      • Medical Student Membership
    • Member News
      • Member Spotlight
      • Give the Gift of SAGES Membership
  • Patients
    • Healthy Sooner – Patient Information for Minimally Invasive Surgery
    • Patient Information Brochures
    • Choosing Wisely – An Initiative of the ABIM Foundation
    • All in the Recovery: Colorectal Cancer Alliance
    • Find a SAGES Member
  • Publications
    • COVID-19 Annoucements
    • SAGES Clinical / Practice / Training Guidelines, Statements, and Standards of Practice
    • Patient Information Brochures
    • TAVAC – Technology and Value Assessments
    • Surgical Endoscopy and Other Journal Information
    • SAGES Manuals
    • SCOPE – The SAGES Newsletter
    • Troubleshooting Guides
  • Education
    • SAGES.TV Video Library
    • Virtual Hernia Clinic
    • The SAGES Safe Cholecystectomy Program
    • The Safe Cholecystectomy Didactic Modules
    • Masters Program
      • SAGES Facebook Program Collaboratives
      • Acute Care Surgery
      • Bariatric
      • Biliary
      • Colorectal
      • Flexible Endoscopy (upper or lower)
      • Foregut
      • Hernia
      • Robotics
    • Educational Opportunities
    • The SAGES HPB/Solid Organ Program
    • Courses for Residents
      • Advanced Courses
      • Basic Courses
    • Endorsed Courses
    • SAGES Robotics Fellows Courses
    • MIS Fellows Course
    • Facebook Livestreams
    • Free Educational Webinars For Residents
    • SMART Enhanced Recovery Program
    • SAGES Quality Initiative
    • SAGES OR SAFETY Video
    • SAGES at Cine-Med
      • SAGES Top 21 MIS Procedures
      • SAGES Pearls
      • SAGES Flexible Endoscopy 101
      • SAGES Tips & Tricks of the Top 21
  • Opportunities
    • SAGES Research Opportunities
    • SAGES Endorsed Courses
    • Fundamentals of Laparoscopic Surgery
    • Fundamentals of Endoscopic Surgery
    • Fundamental Use of Surgical Energy
    • Job Board
    • SAGES Go Global: Global Affairs and Humanitarian Efforts
    • Fellowship Certification
  • Search
    • COVID-19 Announcements
    • Search All SAGES Content
    • Search SAGES Guidelines
    • Search the Video Library
    • Search the Image Library
    • Search the Abstracts Archive
  • Blog
    • All Blog Posts
    • COVID-19
    • Notes from the Battlefield
    • A (Positive) Way Forward
    • President Posts
  • Log In

Compiling Provation MD – A Powerful Data Mining Tool Amenable to Statistical Analysis

Victor B Tsirline, MD MS, Igor Belyansky, MD, David A Klima, MD, Cynthia M Hlavacek, Kristian T Dacey, Amy E Lincourt, PhD, Ronald F Sing, DO FACS, B. Todd Heniford, MD FACS. Carolinas Medical Center, Charlotte, NC 28204

Background
Clinical research is highly dependent on the availability of data, its accuracy, completeness, and suitability for analysis. ProVation™ MD is a dictation system for endoscopic procedures made by Wolters Kluwer and is used in over 700 sites and 7000 clinical users. ProVation contains a powerful text analysis module, which potentially enables rapid analysis of a virtually unlimited number of procedure reports. The data generated by ProVation does not lend itself to statistical analysis by virtue of its complexity, as a result, its use as a research tool is limited. We have developed a methodology to overcome this problem.

Methods
At the Carolinas Healthcare System some 30,000 endoscopic procedures are dictated in the ProVation system annually. We queried procedures performed between 2003 and 2010. Text mining engine extracted statements from endoscopy reports into the following categories: Procedure Name, Providers and their Roles, Indications for Procedure, Findings with Locations and corresponding Maneuvers, Complications, Medications, Impressions, Recommendations, and Endoscopy Instruments. The results was a 3 dimensional variable-length array of discrete text value. The maximum number of values in each category across all records was explicitly determined, together comprising a maximum of 250 data elements per endoscopy record. The resulting dataset table was imported into Microsoft Access as raw data table. A series of dynamic action queries was generated using Visual Basic for Applications (VBA) to construct a relational database with tables corresponding to each Category, all linked to the master table using standard indexing methodologies. The variables in the dataset were electronically examined for sparsity and variability, and were assimilated into clinically relevant supersets. The data was then compiled into the final table with one procedure record per row, capturing commonly occurring data in multiple dichotomy sets and combining sparse data into aggregate variables.

Results
A total of 95,378 exam records were generated by ProVation, containing up to 3 procedures per exam, for a total of 189,156 procedures. The dataset contained 103,805 lower GI endoscopy reports, 66,888 upper GI endoscopy reports, 6,197 bronchoscopies, and 4,195 ERCPs. The relational database contained 9 categories and 2 subcategories, with each record having up to 20 data values per category – a total of 3,667,119 non-blank text elements. Each category was comprised of up to 1,000 unique elements. Contextually similar elements were grouped together by descriptors, resulting in 20 to 100 unique descriptors per category. The relational database was flattened into a spreadsheet of one endoscopy record per row for further statistical analysis. The entire conversion process from ProVation text mining to the final spreadsheet amenable to analysis required no additional input from the user.

Conclusion
The application of systematic data mining methods to ProVation MD dictation system allows rapid analysis of vast amounts of clinical data, providing a powerful research tool for those who utilize the system in clinical practice. Our conversion process required limited user input, irrespective of the database size and making it practical to analyze a virtually unlimited number of reports in a timeframe of hours to days.
 


Session: Emerging Technology Poster
Program Number: ETP090
View Poster

Post Views: 427

Share this:

  • Twitter
  • Facebook
  • LinkedIn
  • Pinterest
  • WhatsApp
  • Reddit

Related

« Return to SAGES 2011 abstract archive

Our Mission

Innovate, educate and collaborate to improve patient care.

Recently, on SAGES…

Free SAGES Webinar: Lessons from COVID on Living and Thriving as Surgeons

SAGES recognizes that the COVID-19 pandemic has had a big impact on surgical practice and in surgeon wellness. SAGES’ Reimagining the Practice of Surgery Taskforce will present “Finding the Opportunities: Lessons from COVID and How We Live and Thrive as Surgeons”  to look at ways in which innovative leadership at various levels may help transform […]

Daniel Herron, MD

An opportunity to slow down and appreciate the small joys in life

Dan Herron, MD shares insights with Dana Telem, MD on lessons learned from COVID-19 Fear, anxiety and uncertainty has dominated the first half of 2020. Never before have we, as healthcare providers, been asked to do so much with so little—whether it’s resources like personal protective equipment, dusting off skills related to critical care, or […]

covid testing stock

Notes from the Battlefield – May 14, 2020

Coronavirus Global Surgical Collaborative (CVGSC)* An initiative sponsored by SAGES in collaboration with EAES, AEC, KSELS, and ELSA A group of surgical leaders from affected countries have joined to discuss what they are learning during this Covid-19 Global crisis. The following is a brief summary of what they feel may be useful information to disseminate to the surgical […]

Contact SAGES

Society of American Gastrointestinal and Endoscopic Surgeons
11300 W. Olympic Blvd Suite 600
Los Angeles, CA 90064 USA
webmaster@sages.org
Tel: (310) 437-0544

Find Us Around the Web!

  • Facebook
  • Twitter
  • YouTube

Newsletter Subscription

  • This field is for validation purposes and should be left unchanged.

Important Links

SAGES 2020 Meeting Information

Healthy Sooner: Patient Information

SAGES Guidelines, Statements, & Standards of Practice

SAGES Manuals

 

  • taTME Study Info
  • Foundation
  • SAGES.TV
  • MyCME
  • Educational Activities

[footer_backtotop] · Log in

Copyright © 2021 Society of American Gastrointestinal and Endoscopic Surgeons · Legal
· Managed by BSC Management, Inc