• 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
    • Advocacy
    • Strategic Plan, 2020-2023
    • Committees
      • 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
      • Social Justice and Health Equity
      • Excellence in Community Surgery
      • 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
    • NBT Innovation Weekend
    • SAGES Annual Meeting
      • 2023 Scientific Session Call For Abstracts
      • 2023 Emerging Technology Call For Abstracts
    • CME Claim Form
    • Industry
      • Advertising Opportunities
      • Exhibit Opportunities
      • Sponsorship Opportunities
    • Future Meetings
    • Past Meetings
      • SAGES 2022
      • SAGES 2021
    • Related Meetings Calendar
  • Join SAGES!
    • 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
    • SAGES Stories Podcast
    • 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
    • COVID-19 Annoucements
    • Troubleshooting Guides
  • Education
    • OpiVoid.org
    • SAGES.TV Video Library
    • Safe Cholecystectomy Program
      • 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
    • HPB/Solid Organ Program
    • Courses for Residents
      • Advanced Courses
      • Basic Courses
    • Video Based Assessments (VBA)
    • Robotics Fellows Course
    • MIS Fellows Course
    • Facebook Livestreams
    • Free Webinars For Residents
    • SMART Enhanced Recovery Program
    • 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
    • NEW-Area of Concentrated Training Seal (ACT)-Advanced Flexible Endoscopy-Coming Soon!
    • SAGES Fellowship Certification for Advanced GI MIS and Comprehensive Flexible Endoscopy
    • Multi-Society Foregut Fellowship Certification
    • SAGES Research Opportunities
    • Fundamentals of Laparoscopic Surgery
    • Fundamentals of Endoscopic Surgery
    • Fundamental Use of Surgical Energy
    • Job Board
    • SAGES Go Global: Global Affairs and Humanitarian Efforts
  • Search
    • Search All SAGES Content
    • Search SAGES Guidelines
    • Search the Video Library
    • Search the Image Library
    • Search the Abstracts Archive
  • Store
    • “Unofficial” Logo Products
  • 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

575

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…

Critical View of Safety (CVS) Challenge QR Code

The SAGES Critical View of Safety Challenge – Donate Your Lap Chole Videos!

The Society of American Gastrointestinal and Endoscopic Surgeons is hosting the first Artificial Intelligence Data Challenge conducted by surgeons. The aim of this challenge is to generate a large and diverse dataset of laparoscopic cholecystectomy videos, annotated with respect to the subcomponents of the Critical View of Safety (CVS). Computer scientists from all over the […]

Respuesta de SAGES al Estudio NordICC sobre el beneficio de las colonoscopias de detección

SAGES desea aclarar los resultados del estudio NordICC y colocarlos en contexto de los esfuerzos de varias agencias nacionales para reducir el riesgo de cáncer colorrectal – la segunda causa de muerte por cáncer más frecuente en los Estados Unidos-, mediante la promoción de la detección y tratamiento oportuno de las lesiones.

SAGES Response to NordICC Study Regarding Benefit of Screening Colonoscopies

The NordICC Study recently published in The New England Journal of Medicine and widely reported on by media outlets has raised questions regarding the benefit of screening colonoscopy in lowering the risk of colorectal cancer and cancer-related deaths among otherwise healthy and symptom-free men and women aged 55 to 64. Provocative headlines and commentaries have […]

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

Important Links

SAGES 2023 Meeting Information

Healthy Sooner: Patient Information

SAGES Guidelines, Statements, & Standards of Practice

SAGES Manuals

 

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

Copyright © 2023 Society of American Gastrointestinal and Endoscopic Surgeons