1 / 14

Web-Based Integration of Data Collection and Reporting Based on SAS Foundation Technologies

Beate Danielsen, Health Information Solutions Soora Wi, Kaiser Permanente Eileen Walsh, Kaiser Permanente. Web-Based Integration of Data Collection and Reporting Based on SAS Foundation Technologies. Is this Presentation for You?.

damian
Download Presentation

Web-Based Integration of Data Collection and Reporting Based on SAS Foundation Technologies

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. Beate Danielsen, Health Information Solutions Soora Wi, Kaiser Permanente Eileen Walsh, Kaiser Permanente Web-Based Integration of Data Collection and Reporting Based on SAS Foundation Technologies

  2. Is this Presentation for You? • Need for customized data collection possibly at different sites connected by an intranet or the internet • SAS foundation technologies available including staff resources familiar with those technologies • Need for customized data reports delivered via an intranet or the internet • Need for flexibility in terms of data collected and reports generated

  3. Structure of Presentation • Brief introduction to a custom data collection at Kaiser Permanente – Division of Research • Status and challenges 2 years ago • Features of re-designed application • Cost / Benefit considerations • Outlook and future goals

  4. Introduction to NMDS • Neonatal Minimum Data Set (NMDS) • On-line data collection from Kaiser Permanente’s 6 Level III Neonatal Intensive Care Units •  18,000 infants screened annually for eligibility •  3,000 eligible infants annually • Up to  800 variables collected per infant stay • Data used for monitoring health outcomes, participation in QI initiatives, performing research, and more • On-line reporting

  5. Status and Challenges 2 Years Ago • Web-based application relying on HTML, JavaScript, JSP/Java/JDBC, Tomcat, Oracle, and SAS • Necessity of exporting Oracle tables into SAS • Limited on-line help • Limited real-time error checking • Lack of on-line reporting • Considerable delay between NICU encounter and its abstraction into the database and additional delays to NICU reports • Need of outside programmer for system changes such as addition of new variables or any type of application maintenance • No support of other constituents

  6. Re-Designed Application Web server passes variables in specific format generated via CGI script Browser sends http request (a completed HTML form) Kaiser DOR Intranet Kaiser DOR Intranet Data Client PC Web server returns HTML and other generated content such as figures, XML documents, etc. that it received from application server Runs SAS program and sends result as HTML / XML Application Server SAS Base SAS/IntrNet SAS/Graph Unix System Web Server Apache Unix System broker.cgi

  7. NMDS-V Application Features • Web-based • SAS data sets • DBs fully managed through application • Data integrity checks built into application using JavaScript and comprehensive SAS-based error check

  8. NMDS-V Application Features (continued) • User-friendly environment with relevant help screens • Multiple levels of access (e.g., review-only user, abstractor, supervisor, DB reports only) • Database activity reports and other custom reports helpful in the abstraction process • Integration of an expanded data collection on a subset of cases

  9. NMDS-V Application Features (continued) • Integrated reporting • Ability to populate some of the SAS DBs from other sources • Support DB generation to meet needs of multiple constituents: national and statewide patient outcome registries, payer-sponsored quality benchmarking programs, and regional/local QI initiatives by KP clinical staff

  10. Cost / Benefit Considerations Legacy System Re-designed SAS-based System Simpler set up requiring SAS only Real-time error checks Flexible: Data collection, user management, reporting, support of QI projects built-in Application built and in production within 6 months Staff time needed for data entry reduced from 6.0 to 4.0 FTEs Increased independence of KP staff • More complicated set up requiring the maintenance of multiple software products • Limited real-time error checking • Relatively inflexible, data collection only with limited flexibility to add/remove data elements

  11. Outlook and Future Goals • Integration of legacy data into re-designed application • Population of database variables through other KP databases particularly the EMR further reducing abstracting time • Continuous improvement of application interface based on user feedback • Expanded reporting

  12. Response to Concerns / Questions • SAS/IntrNet only solutions are difficult to maintain • Entirely dependent on the application designer • NMDS implementation makes it easy to find relevant modules (“gatekeeper” macro) • asp.net is a better solution • Only available on Windows-based web servers, therefore not platform independent • Need for ASP programmer

  13. Summary SAS Foundation Technologies combined with basic web techniques provide a powerful tool to institutions vested in SAS to generate completely customized and flexible solutions for data collection and informative reporting.

  14. Contact Information Beate Danielsen, Health Information Solutionsbeate@health-info-solutions.com Soora Wi, Kaiser PermanenteSoora.Wi@kp.org Eileen Walsh, Kaiser PermanenteEileen.M.Walsh@kp.org

More Related