Skip to content
Case study

Replacing a 20-Year-Old Access System with a Centralized Case Management Application for a Long Beach Nonprofit

Endertech partnered with Safe Refuge, a Long Beach nonprofit addiction treatment provider, to replace a fragile 20-year-old Access and spreadsheet system with a modern web-based case management application that centralizes intake, housing, scheduling, medical, attendance, HR, and reporting workflows.
Replacing a 20-Year-Old Access System with a Centralized Case Management Application for a Long Beach Nonprofit
Results
  • Created a more scalable, maintainable digital foundation to support Safe Refuge’s long-term community service mission.
  • Delivered flexible configuration tools, including editable lookup lists and a column configurator for customizable list views.
  • Enhanced the organization’s ability to meet government and grant reporting requirements with standardized records and reports.
  • Implemented a fine-grained role-based permission system to control access across many staff roles and departments.
  • Improved data quality and consistency through structured CRUD interfaces, validation, and confirmation dialogs.
  • Migrated legacy data into the new system, reducing dependence on outdated tools and preserving historical records.
  • Provided dashboards and in-app alerts so staff can see key tasks and statuses without relying solely on email.
  • Reduced manual effort with automations such as automatic attendance record creation when sign-in sheets are printed.
  • Replaced a fragile 20-year-old Access and spreadsheet setup with a centralized, web-based case management application.
  • Streamlined discharge and legal communication through workflows that automatically generate court and agency letters.
  • Supported accounting and financial oversight with structured contract data such as daily rate values for reporting.
  • Unified intake, housing, scheduling, medical, attendance, HR, and reporting workflows into a single platform.

Safe Refuge is a vital nonprofit in the Long Beach community, helping hundreds of people on their road to recovery from addiction across multiple residential properties. Over decades of service, their operations had grown more complex, while their software had not. A fragile combination of a 20-year-old Microsoft Access database and countless spreadsheets was struggling to keep up with intake, housing, medical records, attendance, and state-mandated reporting.

Endertech partnered with Safe Refuge to design and implement a custom web-based case management platform that consolidates these critical workflows into a single, centralized system used daily by staff across the organization.

Client Context

Safe Refuge operates as a nonprofit behavioral health and substance-abuse treatment provider in Southern California, with multiple properties and programs. Dozens of staff members support hundreds of clients at different stages of their recovery, often over many months.

The organization must document almost every aspect of a client’s journey: intake and eligibility, housing assignments, daily attendance, course and program participation, medical and medication history, and discharge outcomes. They also must produce reliable reports to satisfy state grant and regulatory requirements, all while protecting sensitive client information.

The Challenge

Safe Refuge’s legacy tools were never designed for this level of operational and regulatory complexity. Over time, a patchwork of spreadsheets and an aging Access database emerged, with key challenges:

  • Fragmented data and workflows: Different departments (intake, housing, medical, HR, accounting) managed overlapping data in separate files and tools.

  • Manual, error-prone reporting: Staff had to compile information from multiple systems to meet state-mandated and internal reporting needs.

  • Complex multi-month care workflows: Tracking a client across intake, contracts, housing moves, courses, attendance, medical events, and discharge was difficult to coordinate and audit.

  • Limited configurability: Many essential lookup values and drop-down lists required developer changes, slowing down day-to-day operations.

  • Aging infrastructure risk: The Access database was on its last legs, posing reliability and continuity risks for a mission-critical program.

The Opportunity

By replacing the legacy environment with a centralized, browser-based application, Safe Refuge could:

  • Give every department a shared, accurate view of client information.

  • Standardize workflows for intake, housing, attendance, medical, and discharge.

  • Support government reporting requirements with more reliable, validated data.

  • Reduce manual data entry and reconciliation work across spreadsheets.

  • Provide configurable tools that staff could adapt without developer intervention.

  • Lay a stable foundation for the next decade of growth and community service.

Endertech’s Role

Endertech served as Safe Refuge’s strategic software development partner, responsible for understanding their end-to-end operations and translating them into a robust, maintainable web application.

Our engagement included:

  • In-depth discovery across departments to map real-world workflows.

  • Product and data design for a unified domain model spanning intake, housing, medical, attendance, HR, and reporting.

  • Iterative agile delivery across many sprints, incrementally rolling out modules and enhancements.

  • Ongoing refinement based on user feedback and evolving operational needs.

Our Approach

Given the breadth of Safe Refuge’s operations and the sensitivity of client data, we took a phased, disciplined approach:

  • Domain-driven discovery: We began by cataloging core entities—clients, properties, units, beds, sponsors, probation agencies, employees, contracts, medications, and more—and aligning them with real processes in each department.

  • Modular system design: We structured work into focused epics for intake, contracts, scheduling, medical, attendance, HR, reporting, passes, disciplinary review board (DRB), printable documents, roles & permissions, and configuration tools.

  • Agile, multi-sprint delivery: The backlog spanned more than thirty sprints, allowing Safe Refuge to see progress regularly, validate features in real workflows, and adjust priorities.

  • Security and access control: We implemented a fine-grained, role-based permission model enforced at both the UI and API/controller levels, ensuring staff only see and edit the data appropriate to their role.

  • Quality and staging: Tasks to set up testing, staging environments, and automated checks were built into the project to support safe, incremental releases.

What We Delivered

1. Centralized Client & Housing Management

We implemented full create/read/update/delete (CRUD) capabilities for core client and housing entities, replacing many fragmented spreadsheets with a single source of truth.

  • Client records: Structured profiles capturing demographics and key program-related information.

  • Housing assets: Properties, units, and beds managed within the system so staff can track where each client is placed.

  • Sponsors & agencies: Entities such as sponsors and probation agencies managed in one place for consistent reporting.

This foundation allows staff across departments to work from the same verified data and reduces duplication and inconsistencies.

2. Scheduling, Courses, and Attendance Automation

Scheduling and attendance are central to demonstrating program compliance and client engagement. The application supports:

  • Class and schedule management: Tools to define schedules, course requirements, and recurring activities.

  • Schedule change workflows: Requests and approvals for schedule changes, with audit trails for accountability.

  • Calendar views & printing: Calendar-style views and printable schedules for staff and program use.

  • Automated attendance records: When staff print sign-in sheets, the system automatically generates the associated attendance records, reducing manual data entry.

These features help Safe Refuge maintain accurate attendance histories and support the evidence required for state reporting and internal quality assurance.

3. Medical & Medication Tracking

The system includes a dedicated medical domain to help staff manage health-related information within an appropriate, structured framework.

  • Medical entities: CRUD for prescriptions, medications, pharmacies, and related health records.

  • Medication history: Logging and history features to see medication changes and events over time.

  • Testing records: Support for tracking items such as TB tests and other key health-related data points.

By organizing this information in a single system rather than scattered files, Safe Refuge can better support accurate record-keeping and respond to reporting and audit needs.

4. Discharge & Legal Workflow Automation

Discharge is a critical moment for clients and for Safe Refuge’s reporting obligations. We implemented workflows to support:

  • Structured discharge processes: Clear steps for staff to complete when a client exits a program.

  • Automated legal and court letters: When certain contacts or discharge events are recorded, the system can automatically generate appropriate letters to courts or agencies based on predefined templates and rules.

These automations reduce manual document preparation and help ensure consistent, timely communication with external stakeholders.

5. Reporting, Printable Documents, and Accounting Support

Reporting is where Safe Refuge’s data becomes actionable for funders, regulators, and internal leadership. We delivered a rich set of reporting and printable document tools, including:

  • Printable documents: Sign-in sheets, housing charts, and other operational documents generated directly from live data.

  • Operational and program reports: A variety of reports aligned with real-world oversight and management needs.

  • Accounting-related fields: For example, contracts can include daily rate values to support financial and billing calculations and reporting.

By tying reports and printouts directly to the underlying data, Safe Refuge reduces the risk of discrepancies and the effort required to produce regular documentation.

6. Dashboards, Alerts, and To-Do Visibility

To reduce reliance on email and ad-hoc reminders, the system surfaces key actions and statuses inside the application itself.

  • Dashboards: High-level summaries help staff see important information at a glance.

  • In-app alerts and to-dos: Tasks and follow-ups appear where staff work, prompting timely action and improving coordination.

This improves day-to-day operational awareness and helps ensure that critical steps in client care are not overlooked.

7. Roles, Permissions, and Configuration Tools

Because many staff across locations and departments rely on the system, fine-grained security and flexibility were essential.

  • Role-based permissions: A role system controls who can view, create, edit, or delete specific data, enforced both in the user interface and at the API/controller level.

  • Configurable lookups: Administrators can manage dropdown values (such as codes and categories) without needing a developer, adapting the system as programs evolve.

  • Column Configurator: Users can configure list views, choosing which columns to display and saving preferred column/filter configurations for faster daily work.

These capabilities give Safe Refuge control over how the system behaves and appears, while preserving necessary safeguards around sensitive data.

8. Data Migration and Environment Setup

Transitioning from the legacy Access and spreadsheet environment required careful data handling and deployment planning.

  • Data import & migration: Legacy datasets were imported into the new data model, reducing the need to maintain old systems in parallel.

  • Staging and testing: Dedicated tasks set up staging servers and testing infrastructure, allowing Safe Refuge to validate new features and migrations before they reached production.

This approach helped minimize disruption during go-live and ensured the new system started with as complete and accurate a dataset as possible.

Complexity Handled

The Safe Refuge project demonstrates Endertech’s ability to handle meaningful real-world complexity:

  • Bringing together intake, contracts, housing, scheduling, attendance, medical, HR, passes, and DRB workflows into a single application.

  • Managing intricate scheduling and schedule-change approval processes with audit trails and printable schedules.

  • Supporting structured medical and medication tracking within a broader case management context.

  • Generating a wide variety of reports and printable documents, including operational, legal, and accounting-related outputs.

  • Implementing a detailed role and permission model needed for a multi-role, multi-location operation handling sensitive information.

  • Migrating data from legacy Access and CSV sources into a new, unified platform.

Results & Business Value

While Safe Refuge’s primary mission is not measured in revenue alone, the new system delivers meaningful operational and organizational value:

  • Centralized operations: A single, web-based back-office application replaced a fragile mix of spreadsheets and Access databases.

  • Unified departmental workflows: Intake, housing, scheduling, medical, attendance, HR, and reporting now share consistent data and processes.

  • Reduced manual effort: Automations such as attendance generation on sign-in sheet printing and auto-generated legal letters remove repetitive manual steps.

  • Improved data quality: Structured CRUD interfaces, validation rules, and confirmation dialogs help prevent errors and support accurate reporting.

  • Better visibility and accountability: Dashboards and in-app alerts help staff see what needs attention without relying solely on email.

  • Greater administrative control: Configurable dropdowns and column configurations allow Safe Refuge to adapt the system as programs evolve without additional development work for every small change.

  • Stronger foundation for compliance reporting: With standardized records and reporting tools, Safe Refuge is better positioned to meet government and grant reporting requirements.

The result is not just new software, but a more stable and adaptable digital foundation for Safe Refuge’s next decades of community service.

Why This Work Matters

For nonprofits like Safe Refuge, technology must support complex, mission-critical operations without overshadowing the human work at the center. This project shows how Endertech can:

  • Modernize an aging, fragmented system into a cohesive web application.

  • Translate detailed, multi-department workflows into practical, maintainable software.

  • Balance usability, configurability, and control in environments with sensitive client data.

  • Support organizations whose responsibilities include both direct care and rigorous reporting obligations.

Have a Similar Challenge?

If your organization is running critical programs on aging databases and spreadsheets, Endertech can help you design and build a modern system tailored to your workflows. We partner with nonprofits, treatment providers, and mission-driven organizations to deliver:

  • Custom case management and back-office applications

  • Secure, role-based web platforms for multi-department teams

  • Reporting and printable document solutions aligned to regulatory requirements

  • Ongoing support and iterative improvement

Reach out to discuss how we can help stabilize your systems and create a stronger digital foundation for your mission.