data collection database management and reporting in real time based on sas and other applications n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Data Collection, Database Management and Reporting in Real-Time based on SAS and Other Applications PowerPoint Presentation
Download Presentation
Data Collection, Database Management and Reporting in Real-Time based on SAS and Other Applications

Loading in 2 Seconds...

play fullscreen
1 / 13

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


  • 144 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Data Collection, Database Management and Reporting in Real-Time based on SAS and Other Applications' - orly


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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

Health Information Solutions

california perinatal quality care collaborative
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

status two years ago
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

infrastructure
Infrastructure
  • Microsoft/Access
  • Microsoft/Excel
  • Adobe Acrobat Writer and Distiller
  • WINRAR
  • SAS®/Base, SAS/GRAPH®, SAS/STAT®
  • Java

Health Information Solutions

solution
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

www based data base management 1
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

www based data base management 2
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

www based data base management 3
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

www based data base management 4
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

www based data base management 5
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

www based data reporting
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

cost benefit note
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

outlook
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