1 / 13

Data Collection, Database Management and Reporting in Real-Time based on SAS and Other Applications

Data Collection, Database Management and Reporting in Real-Time based on SAS and Other Applications. Beate Danielsen, MA, PhD Barbara Murphy, RN, MSN Jeffrey B. Gould, MD, MPH. California Perinatal Quality Care Collaborative.

orly
Download Presentation

Data Collection, Database Management and Reporting in Real-Time based on SAS and Other Applications

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Data Collection, Database Management and Reporting in Real-Time based on SAS and Other Applications Beate Danielsen, MA, PhD Barbara Murphy, RN, MSN Jeffrey B. Gould, MD, MPH Health Information Solutions

  2. California Perinatal Quality Care Collaborative • Development of perinatal outcomes and information which allows for data driven performance improvement and benchmarking throughout California • Quality improvement of NICU care • Collaboration of a large and diverse network of stakeholders • Development of CPQCC Data Base for Research and QI Health Information Solutions

  3. Status Two Years Ago • 40 participating centers • Data submitted electronically or on paper • Data errors and errors introduced through data handling (e.g., scanning) • Elaborate and staff-intensive data correction process • Error reports, quarterly reports, annual summary report voluminous and staff-time intensive • Different programming languages used • Anticipation of enrollment of 80 more centers • Little time for research Health Information Solutions

  4. Infrastructure • Microsoft/Access • Microsoft/Excel • Adobe Acrobat Writer and Distiller • WINRAR • SAS®/Base, SAS/GRAPH®, SAS/STAT® • Java Health Information Solutions

  5. Solution • WWW-based application handling: • Data Base Management, Error and Quarterly Reporting • Annual Reporting • Additional products needed: • MySQL & PHP • JavaScript • SAS/IntrNet® Health Information Solutions

  6. WWW-Based Data Base Management (1) • Add Data • Verification whether data for ID were previously submitted • Real-time error checking via JavaScript • Only error-free records can be submitted • Context-sensitive help • SAS/IntrNet® used to process data and add them to the CPQCC Master Data Base Health Information Solutions

  7. WWW-Based Data Base Management (2) • Edit Data • Edit previously submitted data that might have been received as paper form, EDS submission, or via the WWW • SAS/IntrNet® used to retrieve previously submitted data from the CPQCC Master Data Base; the WWW form populated based on JavaScript and HTML that is generated by SAS® Health Information Solutions

  8. WWW-Based Data Base Management (3) • Error reports • Error reports generated in real-time • Besides errors, submission statistics are displayed such as total number of records, total number of submissions per record, etc. • SAS/IntrNet® produces error report as HTML, Microsoft/Excel and PDF documents • Quarterly reports • Generated 4 times a year by CPQCC staff and uploaded on the web server Health Information Solutions

  9. WWW-Based Data Base Management (4) • Send reports/data via e-mail • SAS/IntrNet® sends error reports, quarterly reports, or center-specific data extract to designated contact • The requested item is sent as a zipped, encrypted, and password-protected file • Real-time feedback to users Health Information Solutions

  10. WWW-Based Data Base Management (5) • Additional functionality provided for CPQCC data center staff • Addition of scanned data forms stored as Microsoft/Access data base • Screening and addition of electronic data • Instant network report with a number of network statistics • Instant application server activity report • Additional send functions Health Information Solutions

  11. WWW-Based Data Reporting • Shows annual data for a center compared to all CPQCC network centers • Data presented as tables, standardized tables, and specialized charts • SAS/IntrNet® used to produce charts allowing an immense amount of graphical QI materials that can be navigated easily by the user Health Information Solutions

  12. w/out SAS/IntrNet ® Hiring of 2 additional staff members One additional Teleform license Paper and mail supplies Additional center-specific resources With SAS/IntrNet ® SAS/IntrNet license Application server Web server Staff training to ease transition to web-based data entry and reporting Cost-Benefit Note Health Information Solutions

  13. Outlook • Successful transition from EDS and paper-based data submissions to web-based submissions hinges upon quality technical support and CPQCC staff training • On-line data collection has fully started earlier this year • Real-Time Reporting will hopefully be possible in 2006 • Valuable staff time has been freed up to focus on research and QI goals Health Information Solutions

More Related