School Based Health Center (SBHC)

×

Error message

  • Deprecated function: Methods with the same name as their class will not be constructors in a future version of PHP; views_display has a deprecated constructor in require_once() (line 3256 of /var/www/vhosts/msnmedia.com/httpdocs/includes/bootstrap.inc).
  • Deprecated function: Methods with the same name as their class will not be constructors in a future version of PHP; views_many_to_one_helper has a deprecated constructor in require_once() (line 127 of /var/www/vhosts/msnmedia.com/httpdocs/sites/all/modules/ctools/ctools.module).

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