CTMS 11.0 ER019-014
From Calidus HUB
EMERGENCY RELEASE - CTMS 11.0
RELNOTE ER019-014
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| DP_TOMTOM.sql | TomTom Interfaces | 1.16 | 329251 | CR-16/PO:61534719 | 3 | New overnight process to extract lots of data out of Webfleet and store in C-TMS. Will need to manually create an EDI process to run nightly (after midnight) to run the new code DP_TOMTOM.OVERNIGHT_DOWLOAD. Will also need to have created a level 2 queue for ignition messages. | Ed Bond |
| CT_SEQ_TT_VEH_GRP_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_SEQ_TT_VEHMILE_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_SEQ_TT_SPEED_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_SEQ_TT_PARKED_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_SEQ_TT_MESSAGES_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_SEQ_TT_IGNITION_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_SEQ_TT_EVENTS_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_SEQ_TT_DRIV_GRP_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_SEQ_TT_DRIVER_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_SEQ_TT_BLUELIGHT_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_SEQ_TT_ACCEL_329251.sql | Create Table Script | 1.2 | " | " | " | " | " |
| CT_TOM_VEH_GROUP_329251.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_TOM_VEHICLE_MILEAGE_329251. | Create Table Script | 1.1 | " | " | " | " | " |
| CT_TOM_SPEEDING_329251.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_TOM_PARKED_LOCS_329251.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_TOM_ORDER_EVENTS_329251.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_TOM_MESSAGES_329251.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_TOM_IGNITION_329251.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_TOM_DRIV_GROUP_329251.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_TOM_DRIVER_KPI_329251.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_TOM_BLUELIGHT_329251.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_TOM_ACCELERATION_329251.sql | Create Table Script | 1.1 | " | " | " | " | " |
| TRG_TT_VEH_GROUP_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_TT_VEHMILE_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_TT_SPEEDING_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_TT_PARK_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_TT_MESSAGES_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_TT_IGNITION_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_TT_EVENTS_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_TT_DRIV_GROUP_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_TT_DRIV_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_TT_BLUELIGHT_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_TT_ACCELERATION_BI.sql | Trigger | 1.1 | " | " | " | " | " |
| V_TOM_VEH_GROUP.sql | View | 1.1 | " | " | " | " | " |
| V_TOM_VEHICLE_MILEAGE.sql | View | 1.1 | " | " | " | " | " |
| V_TOM_SPEEDING.sql | View | 1.1 | " | " | " | " | " |
| V_TOM_PARKED_LOCS.sql | View | 1.1 | " | " | " | " | " |
| V_TOM_ORDER_EVENTS.sql | View | 1.2 | " | " | " | " | " |
| V_TOM_MESSAGES.sql | View | 1.2 | " | " | " | " | " |
| V_TOM_IGNITION.sql | View | 1.2 | " | " | " | " | " |
| V_TOM_DRIV_GROUP.sql | View | 1.1 | " | " | " | " | " |
| V_TOM_DRIVER_KPI.sql | View | 1.1 | " | " | " | " | " |
| V_TOM_BLUELIGHT.sql | View | 1.1 | " | " | " | " | " |
| V_TOM_ACCELERATION.sql | View | 1.1 | " | " | " | " | " |
| AT_SCH_TRIP_STOP_329251.sql | Alter Table Script | 1.1 | " | " | " | " | " |
| DATA_ADM_SYSTEM_PARAM_329251.sql | Data Script | 1.1 | " | " | " | " | " |
| New Parameters | |||
| Parameter Name | Config Level | Setting Value | Result |
| GEO_TOMTOM_ARCH_DAYS | Database | 365 | Number of days to keep the archive data |
