Proposed future changes to Location and Transfer Ready and related fields
We also collect Transfer Ready DtTm tmp entry in the L TmpV2 table. This info should really be inherently linked with its associated location, ie it should form one record, likely with two date fields.
There is some desire to store the Service tmp entry data in a field in this structure as well, although it really doesn't fit there relationally (there can be different number of records for these). In any case, there is some desire to move these out of the L TmpV2 table.
Add a new L_Locations table (and user interface components) to contain the following:
- Unit, Unit_Start_DtTm, Unit_End_DtTm, transfer ready (yes/no), transfer ready date_time(if yes), Comment
Add a new L_Services table (and user interface components)to contain the following: Service, Service_Start_DtTm, service end datetime, unit, comment.
- remove Boarding Loc, Service tmp entry, Transfer Ready DtTm, Accept DtTm, Arrive DtTm, possibly Service/Location.
The fields we are planning to change are deeply integrated into our processes, so a lot of documentation and cross checks would need to be reviewed and updated. A lot of these already have unanswered questions. At a meeting 2021-02-11 with Allan, Julie, Tina and Trish we determined that we don't have enough resources right now to deal with existing questions, never mind a major overhaul. So, it was decided to shelve this for now and review in 6 months. Tina has booked a meeting for Oct 13 2021 to review.