Skip to content

Initiative Brief

Jump to bottom
kyle-hauber edited this page Jan 28, 2020 · 6 revisions

What is the Problem and Why?

Problem

Prevention Point provides services to promote health, empowerment and safety for communities affected by drug use and poverty. They operate over a dozen services across multiple locations and are funded by over 25 city, state, and federal sources. Today, they collect and store participant data on paper forms, partner systems, and excel workbooks stored on a MS Cloud instance. This creates several key problems:

  • Inefficient resource allocation
    • Due to disparate systems, 33 - 50% of staff time is being used for data entry and reporting purposes, rather than direct service
  • Poorly serving participants
    • Without a centralized view of the participant, Prevention Point is unable to provide holistic care and is missing opportunities to better address their needs and/or connect participants to other valuable services
  • Limited fundraising capabilities
    • Raising funds requires setting, measuring, and achieving goals. Prevention point’s data is so scattered, they are unable to effectively measure their performance, thus making it difficult to attain funding

Why?

  • Program has never had enough infrastructure and financial ability to hire someone to build or maintain such a system
  • Program funding is silo-ed, negating initiative for building one system

Why Code Philly? Why Now?

Code Philly has a group of talented software professional who are willing to volunteer their time to make a difference in the community. This alleviates the stress of funding an internal software team

How will we measure success? What are the most important goals?

  • Adoption of our SaaS app for PPP's General Services
  • Prevention Point no longer needs separate systems for general service programming
  • Positive Qualitative feedback from Front Desk Employees
  • Positive Qualitative feedback from non-Front Desk Employees
  • Positive Qualitative feedback from PPP Leadership

In-Scope

Centralized Data System

A single program where Prevention Point can input participant information, manage their front-desk processes (check-in and queue management), and search for participant information.

Front-Desk Check-in System

  • Participant Data Ingestion
    • Ability to input new participants
    • Ability to update existing participant information
    • From any location and/or device
    • Ability to search for existing participants
  • Queue management
    • Ability to mark when people leave without being seen
    • Ability to mark when people are seen
    • Ability to manage incoming participants in a queue
    • Ability to prioritize participants based on urgency level
      • Scale 1 - 5
  • For STEP program ONLY - participants can have scheduled appointments
    • Ability to see scheduled appointments for each day
    • Ability to easily port scheduled appointments into the queue for that day
  • Provider Data Ingestion
    • Ability to access participant data for any general services program
    • Ability to access all program forms from one location
    • Ability to input form data for all programs

Data Output Capabilities

Prevention Point needs to be able to output their program and participant information into an external system so that they can run their own queries

  • Data in backend system that is accessible by open-source BI Tool

Out of Scope

Building an in-app reporting system

Clone this wiki locally