Moving Meal Deliveries To Sams

Moving From A Custom Care Management Application To Sams

In order to stop doing duplicate data entry, BACS decided to move their meal delivery information from a custom application(Care Management) into SAMS. They were already using SAMS for entering some client information so many of their clients already had SAMS records.

The first step was to print out all the client delivery routes from Care Management and recreate them in SAMS. Unfortunately, SAMS does not have any sort of import facility for this sort of data.

As clients in SAMS were added to routes it was also necessary to create Care Management and Service Plan records for them in SAMS. I wrote queries and reports in the old Care Management system to produce a client directory that included all the information from the old system that needed to be moved to SAMS. As care management and service plan information was being created in SAMS it became clear that many of the clients had other outdated information in their records…. so checking each piece of information that should correspond to the information in the old Care Management system became part of the task for each client record.

BACS offers on option for clients who do not eat pork to  get “no pork” meals when the day’s regular meal contains pork. They also deliver frozen meals before the weekend or before a holiday to some of their clients. To adapt the SAMS service plans so they could record this information we introduced a set of sub-service categories. So a client who gets meals on M-W-F but also gets frozen meals over the weekend would have an additional service entry for 2 frozen meals on Friday.

The old caremanagement system had several check boxes for options like NO MILK and several note fields to help the drivers remember vital information about different clients deliveries. In SAMS the check box options were converted to text in the SAMS notes field and the information about locating the building/apartment the client lived in was entered in the additional information for the client address.