School Based Health Center (SBHC)

Client Description
The State Public Health Division houses the School-Based Health Center Program, which certifies the SBHCs and provides support to communities to promote the health and well-being of the school-aged population through evidence-based best practices within a public health framework. SBHCs are medical clinics that offer primary care services within or on school grounds to school-aged youth and often times the broader community.

Scope
Created a database from scratch to replace spreadsheets and other miscellaneous document types to organize the program. This included:

  • Accessible with full feature set by 10 staff members in program
  • Accessible via web to each of the ~50 schools in the program
  • Manage staff, hours of operation & job function for each center
  • Track student health encounters using large data sets down to the doctor visit level
  • Full reporting module allows stored and ad hoc reports
  • Import and export capability supporting multiple formats
  • Survey with iPad interface that directly communicates with database

Timeline

  • System planning to go-live was a very short timeframe
  • First portion of the system was live within 3 weeks of start date
  • Entire system was built in 6 months, by two developers
  • Budget for project was ~$30,000

Methodology

  • Agile programming: build code in small portions, test and deploy
  • Involve SBHC staff in all aspects of development to ensure features work as required by staff, not just according to spec document
  • Built in FileMaker Pro

Outcome

  • Delivered on time and on budget
  • System is in use and thriving, being extended by SBHC staff

 

Referral Contact:
Matt Pitney

Operations & Policy Analyst
School-Based Health Centers
Maternal & Child Health Assessment, Evaluation and Informatics
Oregon Public Health Division
800 NE Oregon Street, Suite 825
Portland, OR 97232