ParaPlan by EnGraph Software can import trips provided by the brokerage company LogistiCare. They provide a CSV file containing trips that our clients are contracted to perform, and we import them into ParaPlan. It’s a really neat system and it allows companies to provide non-emergency medical transportation to regions that might not otherwise have these services available.

Invariably, trips change before the execution date. Sometimes, they are updated with a different destination, other times, they are completely cancelled. To allow for these situations to be properly handled, LogistiCare included a TripStatus field. This field will be either NEW, MODIFIED or CANCELED.

ParaPlan will handle each case differently:

NEW
A new trip is inserted into ParaPlan.

MODIFIED
ParaPlan looks up the existing trip using the LogistiCareID. If it finds it, it updates the trip and unschedules it if it is already assigned to a Route. If it cannot find the existing trip, it generates a new one and makes it available for scheduling.

CANCELED
ParaPlan looks up the existing trip using the LogistiCareID. If it finds it, it cancels the trip and removes any Route assignment. If it cannot find the existing trip, it creates a new trip with the provided information, then cancels it.