CTMS 11.0 ER019-014: Difference between revisions
From Calidus HUB
(Created page with "<!-- MEDIA LANDSCAPE YES --> {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER019-014 }} {{ERTableHeader}} {{ERTableRow |DP_TOMTOM.sql ...") |
No edit summary |
||
| Line 18: | Line 18: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
|CT_SEQ_TT_VEH_GRP_329251.sql | |CT_SEQ_TT_VEH_GRP_329251.sql | ||
|Create Table Script | |Create Table Script | ||
|1.2 | |1.2 | ||
| Line 28: | Line 28: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
|CT_SEQ_TT_VEHMILE_329251.sql | |CT_SEQ_TT_VEHMILE_329251.sql | ||
|Create Table Script | |Create Table Script | ||
|1.2 | |1.2 | ||
| Line 38: | Line 38: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
|CT_SEQ_TT_SPEED_329251.sql | |CT_SEQ_TT_SPEED_329251.sql | ||
|Create Table Script | |Create Table Script | ||
|1.2 | |1.2 | ||
| Line 48: | Line 48: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
|CT_SEQ_TT_PARKED_329251.sql | |CT_SEQ_TT_PARKED_329251.sql | ||
|Create Table Script | |Create Table Script | ||
|1.2 | |1.2 | ||
| Line 477: | Line 477: | ||
|" | |" | ||
}} | }} | ||
{{ERTableFooter}} | |||
<table border="1px" width="100%"> | <table border="1px" width="100%"> | ||
<tr> | <tr> | ||
| Line 493: | Line 491: | ||
<tr> | <tr> | ||
<td></td> | <td>GEO_TOMTOM_ARCH_DAYS</td> | ||
<td></td> | <td>Database</td> | ||
<td></td> | <td>365</td> | ||
<td></td> | <td>Number of days to keep the archive data</td> | ||
</tr> | </tr> | ||
Latest revision as of 18:39, 22 March 2016
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 |
