ER CTMS 036-018
EMERGENCY RELEASE - CTMS 11.0
RELNOTE ER036-018
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| DATA_MSG_SMS_VALUES_370562.sql | Data Script | 1.1 | 370562 | Email / SMS Delivery | 3 | SMS and emails will be sent to the recipients of the orders based on the formats of the SMS_EMAIL messages for the appropriate medium of SMS or EMAIL.
The data will be converted for the new PO_REF, DEL_DATE_AM and DEL_DAY_AM formats. PO_REF will be obtained from a reference of that type for the order. AM will be translated as AM for the morning or PM for the afternoon for the arrival time of the trip stop at the location. Orders that are on the trip when the status is updated will be assessed for the single message event by trip. Any orders that are assigned to a trip at the required status will be assessed individually for the single message by order and trip. Added collection orders can trigger a message event for an EN-ROUTE trip but delivery orders cannot. System parameter SEND_SMS_EMAIL when Y only triggers message events at ACCEPTED trip status. When set to a specific trip status, the message event will be triggered at that trip status instead. System parameter TRM_SEND_PRE_DELIVERY_MSG when Y will trigger message events at TENDERED and EN-ROUTE trip status. These message events must be formatted at the appropriate trip status to be sent. |
| TIU_TRIP_STATUS.sql | Database Trigger | 5.55 | " | " | " | " |
| TRG_SHA_LOAD_TRIPS.sql | Database Trigger | 1.10 | " | " | " | " |
| MSG_PROCESSING.sql | Message Processing Database Package | 5.71 | " | " | " | " |
