When the time came to leave their legacy system behind, six of Ontario’s Family Service Agencies formed a partnership and worked with Coyote Software Corporation to craft the perfect replacement. The result: CaseWORKS, a comprehensive case management and recording system. CaseWORKS is now being adopted by a growing number of health and social service organizations.
The fact that many of Ontario’s Family Service agencies were still using a DOS-based client database as recently as 2005—almost 20 years after Microsoft first introduced the Windows operating system—tells you something about that sector’s innate resourcefulness. Maybe it’s because they’re essentially all problem-solvers of one kind or another—counsellors helping families cope with all of life’s toughest challenges, supervisors juggling all of their caseworkers’ burgeoning caseloads, and executive directors striving for the sustainability of their perpetually under-funded agencies. It may also be because CSMS, the custom DOS-based system that they managed to keep using for so long, continued to meet their specialized needs better than any other database available on the market.
Whatever the reason, in 2004 a group of six Ontario Family Service agencies got together and decided that it was finally time to replace their antiquated database with a modern, web-based alternative. They recruited one of CSMS’ originators, Kirk Were, to guide them through a comprehensive requirements analysis and feasibility study, and embarked upon a search for the ideal replacement for CSMS. The solution needed to meet the needs of their core job functions for case administration and management, and it needed to be affordable and connected to a sustainable model for ongoing support and future enhancements.
They had a long wish list. According to Nancy Brown, Executive Director of Halton Family Services, “We wanted a comprehensive database program that would handle all of our client information, as well as billing and scheduling. We wanted something that would do it all, in a
The agencies considered three approaches: build from scratch, off the shelf, or buy and modify. Recognizing that they would likely need such a system to contain many custom-built features, they also prepared criteria for choosing the ideal software development firm to hire. “We didn’t want too large a company,” said Linda Dayler, Executive Director of Catholic Family Services of Hamilton and President of Family Services Ontario. “We wanted a vendor that would give us personal attention, be cost-effective, and capable of developing and supporting a system that would meet our specific needs. We also wanted them to have a familiarity with the social services sector.”
After months of searching and presentations by six different short-listed vendors, in the
“The number one reason that we all cited was Coyote’s ability to work with us on an individual basis, and their personalities. They were open, they were creative, they listened, they wanted to be innovative, and they weren’t trying to fit us as a square peg in a round hole,” said Ms. Dayler. “The other companies’ approach was ‘this is our system and you’ll have to adapt to it’.
Ms. Brown added that “Coyote had extensive experience building solutions for many health and social service sectors—including mental health, child welfare, and supervised access That was attractive to us, as was the fact that their software worked, and that they were local. When Kirk, who has an extensive background in building software for health and social service organizations (5,000 physicians and hundreds of community-based agencies), began to talk with them on our behalf, he was also very impressed with what he saw.” The feeling was mutual: as a result of these initial meetings, Mr. Were eventually joined forces with Coyote and continued to guide the development of the CaseWORKS system from within the company.
With the firm selected, the elaborate task of building the software began. From the outset, Coyote took a consultative approach that both Ms. Dayler and Ms. Brown describe as “a true partnership between Family Services Agencies and Coyote.” The company’s business analysts conducted an extensive study of the agencies’ operations, closely watching counsellors and other staff members at their jobs in order to understand, capture and translate their workflows into
The ambitious project took months of dialogue with individuals and committees representing each type of worker’s needs, and numerous software prototypes were produced along the way for testing, feedback and revision. “We certainly felt heard,” said Ms. Brown. “When we said to Coyote, we need you to come in and hear about how we do things, and we need to be assured that this product is going to meet our needs, that definitely happened.”
In addition to crafting the software to meet the specific needs of Family Service caseworkers, Coyote also helped to craft the creative funding structure that allowed all of the participating not-for-profit agencies to afford the system being built. Ms. Dayler explained, “In many systems, you have a limited number of users and then you pay for any additional users above that. But this license is quite different. There is no limit on users. Licensing is based on organizational size, making it affordable for large and small organizations. It is a unique arrangement and a partnership model that works.”
Besides the fairness of the fee structure, the terms of the licensing agreement also require new organizations purchasing the database to pay an initial fee which goes into a trust that is used for further development of the system. An executive committee keeps a list of development priorities and decides when and how to allocate the funds in the trust. As Ms. Dayler put it, “It’s like a co-op. The more agencies we have, the more we have in our reserve fund. It’s very affordable, which was one of our criteria. And it had to be sustainable as well. What’s the point of putting in all that money if we couldn’t sustain it with our annualized budgets?”
The Final Product
When it came time to test the final product, now called CaseWORKS, Ms. Dayler’s Catholic Family Services of Hamilton was chosen as the pilot site because it was one of the
After the success of the initial test, CaseWORKS was then implemented in all five of the other agencies, in each case allowing them to finally say farewell to their DOS-based legacy system without losing any of its historical data. Ms. Dayler explained, “Coyote had to create an interface so that we could move our old data into our new CaseWORKS system.” Ms. Brown agreed, “The data conversion from our legacy system was a concern that we had, and it went quite smoothly. That data is now in
In the end, were they satisfied with the whole development process? In Ms. Brown’s opinion, “It has been excellent. Coyote has been accessible, they stuck to the original cost structure, they’ve given us pretty realistic delivery dates, and they have provided what they said they’d provide. I really am very, very positive about what Coyote has done for us.”
Ms. Dayler was equally positive about the development process. “Yes, Coyote had a learning curve, but fortunately they already had some knowledge because they had developed other social service systems. So they built on that knowledge, and then we taught them. And they taught us. They came to each of our organizations, they met with each group, and our users went to Coyote. So it was a really good mutual relationship, where we really built those bridges together. We really did learn together.”
As for the results of all that learning, collaboration and software development, both Executive Directors are effusive in their praise of the
“We’ve really liked the fact that
She continued, “I love being able to go into the records really, really easily, and the other supervisors like that as well. Say you want to make sure that a worker is up to date on their recording. We can either look at the service events and see the recording dates, or we can very easily go right into the electronic record, open up that recording and see if it has been done adequately. This is all from the comfort of our own desk, very easily and quickly.
“The same applies for records in our branch offices: if we want to look at the dictation in a worker’s record in one of our other locations, we can do so with the same ease as with any other record that is here. For example, a supervisor at one of our satellite offices recently had a very, very difficult case, and she was emailing me saying, ‘Nancy, would you read the notes I just made on this case?’ Which I was then able to do with just a few clicks of the mouse. It was wonderful! Now, because it’s all in CaseWORKS, anybody who needs secure access to a case record can do so if they have the authorization.”
Ms. Dayler pointed out more benefits to supervisors. “Our Agency has many and varied programs and services, and we need to have the right metrics to monitor our caseloads and staff time. With the new
Both offered numerous examples to indicate that
“It allows us to schedule, and we can also do our recording right on the database. You pull up a client, and you do your case notes right there. That allowed us to enhance our central intake. Which means that staff is spending a lot more time doing
Ms. Brown added, “We recently lost two of our major employee assistance contracts, so we had to reduce staff costs wherever possible. CaseWORKS enabled us to do better client processes with
She pointed out another benefit to funders: “With our legacy system, I could never tell our four United Way funding agencies exactly how many people had received our services in their community. CaseWORKS gives me those numbers. This enables me to give the United Way a far more accurate reflection of how many people are benefiting from their support.”
The system also provides new levels of information to her own staff. “One of the new capacities has been the ability to see a person’s enrolment in different programs. If I’m looking for Jane Smith, I can find how she’s registered in CaseWORKS and see immediately that she’s enrolled in our services for abused women, our credit
Ms. Dayler agreed that new levels of information are now available to her staff as well. “This system allows us to enter associations and collaterals—you can enter not only the
Because of the nature of their agencies’ services, some of
She added, “We also have more reporting capabilities now. For example, the whole process of doing a 6-month review, which
She continued, “We also now have a much better waiting list capability. Because it’s an aged waiting list organized by agency-defined criteria. That’s certainly
Update 2007: two years on
As it grows, the Family Services’