BDC – Agile Custom Software Development | Case Study: VNA of Texas
1707
single,single-post,postid-1707,single-format-standard,ajax_updown_fade,page_not_loaded,,large,shadow3

Case Study: VNA of Texas

Visiting Nurse Association of Texas

mow

The client: Visiting Nurse Association of Texas
Go to client

vna

Established in 1934, VNA is a nonprofit 501(c)(3) organization that helps older adults live with dignity and independence at home. VNA is the community’s most trusted provider of quality healthcare services in the home and is the oldest, most experienced Hospice Care provider in Texas. VNA offers Meals on Wheels in Dallas County, and VNA Hospice and Private Care in Collin, Cooke, Dallas, Denton, Ellis, Grayson, Henderson, Hunt, Kaufman, Navarro, Rockwall, Tarrant and Van Zandt counties. Call 1-800-CALL-VNA for more information.

The problem

VNA Meals on Wheels (MOW) program delivers hot, frozen and shelf-stable meals to homebound and needy elderly and disabled throughout Dallas County. Meals are prepared in VNA's kitchen and delivered by nearly 4,000 volunteers and some paid drivers. Daily census of meals is scheduled and tracked through Allscripts, a medical records database system. VNA's MOW also added RoadNet, a logistics routing system produced by United Parcel Service (UPS), to assist volunteers and drivers on their daily routes. To do so, data needed to flow between Allscripts and RoadNet in a variety of ways. An automated system was needed to pull data from Allscripts on a daily basis for regular daily meals delivery. A holiday system was needed to address managing special delivery days, such as Thanksgiving. Additionally, some elements of data are not in Allscripts and yet are needed to supplement the RoadNet data. Besides the routing, VNA also needs reports so the kitchen can prepare the appropriate number and types of meals. These reports are used to tag meals containers for drivers to improve the efficiency of delivery.

The solution

sql roadnet allscripts wpf

BDC created a Microsoft SQL Server and .NET Framework application to handle management of data exchange between systems and reporting for the kitchen. BDC consulted with VNA to discover the required use cases, each handled with the end-user in mind.

The Integration application is a C# .NET 3.5 application in the Model-View-Controller (MVC) design pattern. The View components consist of a command line tool which is used in the nightly task, and a desktop application which is used by VNA personnel. Both of these share the controller and model DLLs. The application was also designed using TDD (test-driven development). Though not 100% comprehensive, the just-riguorous-enough test cases serve as documentation of the system's functionality. An intermediate SQL Server database stores the extra data for RoadNet and provides historical information about meal orders.

The desktop application manipulates data in this database before sending it on to RoadNet. This application also allows VNA to:

  • Amend the data before it is finally imported back into RoadNet
  • Run quality control checks on the data and fix problems automatically
  • Perform easy queries against the intermediate database
  • Manually create special delivery scenarios which can override automatic processing
Retrospective

VNA can efficiently manage fairly complex delivery situations without having to re-key thousands of records that already exist in Allscripts. The system is reliable and easy to update to accommodate new challenges because of the MVC and TDD design.

VNA said about BDC:

  • “…a trusted partner”
  • “…you already have a gameplan and I feel confident that as always we will be successful”
  • “…We have enjoyed a long relationship with BDC and hope to continue for a long time to come”
For more information about VNA's Meals on Wheels, see: http://www.vnatexas.org/our-services/meals-on-wheels