247942 Database system solutions for SBHC clinic and staff performance, service and treatment reporting information required by the school district and other community partners

Sunday, October 30, 2011

Dorothy Zirkle, RN, PHN, PhD , Price Charities, San Diego, CA
Deepinder Kaur, PhD, MSc , Health Services, Price Charities, San Diego, CA
Deborah Morton, PhD, MA , Dept of Family & Preventive Medicine, Division of Epidemiology, University of California, San Diego, La Jolla, CA
Objectives: School-Based Health Centers (SBHCs) in an urban neighborhood provide needed health care services to its uninsured/underinsured students most of whom are low income and/or newly arrived immigrants/refugees. In order to track visits, services and treatments, and evaluate staff performance and the utilization of SBHC resources in association with the long-term benefits of improved health such as academic performance and reduced absenteeism, we created a comprehensive, tailored database (Health Management System/HMS) for three existing SBHCs and one new SBHC. Methods: Designed in collaboration with school nurses, HMS has a nurse-friendly interface with drop-down menus allowing easy recording of the daily student visits including the chief complaint, diagnosis, treatment and education offered or referrals made. HMS allows for recording various health screens e.g. vision, hearing, dental, body mass index and blood pressure with a simple check box. HMS automatically generates up-to-date summaries by aggregating visit data required for monthly reports to the school district and other community partners. Results: HMS can link with school enrollment information such as age, race/ethnicity, gender, grade and attendance records to be merged with clinic information to illustrate the long-range benefits of SBHCs. This system allows for standardized comparisons of geographically associated SBHCs in an urban multiethnic setting. Conclusions: HMS allows accessing of SBHC visit information in a convenient electronic format. HMS summary reports determine clinic and staff performance along with evaluating the impact of improved student heath in relation to academic performance and absenteeism rates. HMS can serve as a model database for SBHCs nation-wide.

Learning Areas:
Administration, management, leadership
Public health or related nursing

Learning Objectives:
1. identify existing reasons for students to visit SBHC 2. describe the use of SBHC data for implementaion of care, clinic and staff performance, service planning, and cost management. 2. The participant will be able to explain and summarize the creation, development, and management of a database system tailored specifically for an SBHC and how to link this system with the school student enrollment system. 3. The participant will be able demonstrate the use of a tailored database visit/patient record system for report generation required by the school district and independent outside funding and community partners and how these data can be used for health science research on topics such as clinic performance, utilization and cost analyses, trends in complaints, diagnoses, treatments and disease/conditions prevalence rates.

Keywords: School-Based Health Care, Data Collection

Presenting author's disclosure statement:

Qualified on the content I am responsible for because: I am a nurse Phd involved in community based access to health care and school based health clinic creation and administration
Any relevant financial relationships? No

I agree to comply with the American Public Health Association Conflict of Interest and Commercial Support Guidelines, and to disclose to the participants any off-label or experimental uses of a commercial product or service discussed in my presentation.