The Science Journal of the American Association for Respiratory Care

2011 OPEN FORUM Abstracts

UTILIZING WEB AND DATABASE TECHNOLOGY TO CREATE A CUSTOM ADAPTABLE, MULTI-SEARCH, REAL-TIME-EDITABLE, MULTIMEDIA-RICH PROCEDURES, POLICIES AND EQUIPMENT ONLINE TOOL FOR A RESPIRATORY CARE DEPARTMENT.

Steven M. Prince1, James P. Jamieson1, Richard F. Hinds1, Donna M. Baxter2; 1Respiratory Care, Mayo Clinic, Rochester, MN; 2Anesthesiology, Mayo Clinic, Rochester, MN

BACKGROUND: A need existed to design, develop and deploy a faster and easy-to-use procedures, policies and equipment online tool, available 24 hours a day for clinical staff. Additionally, the need to incorporate robust functionality to manage real-time data changes and generate reports for management was desired. The subsequent solution transformed departmental information searching and retrieval, facilitated consistent, ongoing training and education of staff and simplified procedure/policy/equipment management with real-time editing and reporting capabilities to ensure quick, continuous quality improvement. METHOD: Requirements for the online tool were determined by meeting with department management and users. Ongoing reviews of the tool in the development phase allowed for modifications prior to live deployment. Server-side web programming (ColdFusion 7/9), client-side scripting and formatting (Javascript, HTML and Cascading Style Sheets) and database technology (SQL Server 2005) were used to design and develop the tool. Meta data collection was incorporated to allow for quick adaptability of the tool. Eight months of search data was reviewed. A survey was deployed to obtain user feedback. RESULTS: 1,217 procedures, policies and equipment web pages are managed by the tool, with end users submitting, on average, 775 open text searches per month, representing only a portion of total use of the tool (count does not include hyperlinked, index use) Average search time of just under half a second (.471 seconds) for open text searching for the top ten most-searched-for terms. A 26% (n=36) response rate was achieved for the survey. The following survey respondents agreed or strongly agreed that the online tool: Is easy to use (72%) Helps them do their job better (75%) Enhances their education of equipment (86%) Enhances their education of procedures (89%) Enhances their education of policies (78%) CONCLUSIONS: Utilizing web and database technology, a fast, easy-to-use, adaptable solution was created which transformed departmental procedure, policy and equipment information search and retrieval, enhanced education and enabled real-time editing and management of information. The tool is available on the Intranet to over 50,000 employees, 24 hours a day. Additional studies are necessary to further quantify endpoints such as staff satisfaction, information retention, increased compliance with procedures and policies and cost benefit analysis. Sponsored Research - None