FS 315750 PROD Load Start Metrics
PROD
Load Start Metrics
CALIDUS ePOD
25th February 2014 - 0.1
Reference: FS 315750
Contents
Functional Overview
Client Requirement
Currently, 'stop' debrief from CALIDUS ePOD is not possible for C-TMS where a trip has stops with no orders (e.g. start-up (SU) stop or closedown (CL) stop where no order activity occurs). Trips are therefore not set to COMPLETED status.
Solution Overview
A message needs to be triggered from CALIDUS ePOD to cover the debrief of the stop times for start-up (SU) and/or closedown (CL) stops. C-TMS needs to handle these new messages and update the stop times on the appropriate trip stops.
A new trigger point is required in CALIDUS ePOD to generate the CALIDUS ePOD_EXPORT_LOAD message exactly as above but as soon as possible after the the start ODO is captured:
This will be utilised to send the stop level debrief actual times for the SU stop and also the start ODO value.
Analysis is required to find a logical point where this can be triggered, ensuring that it is only sent once at the start.
When the load is downloaded to the device for the first time the device date and time are stored in the following fields:
- EPL_LOAD_START_ACTUAL_DATE
- EPL_LOAD_START_ACTUAL_TIME
The ODO reading is also stored in the following field:
- EPL_MILEAGE_START
Scope
- This functionality will be developed in the latest version of CALIDUS ePOD only.
- This functionality will be developed in the Android application only and will not be available in the Windows Mobile application.
- CALIDUS TMS functionality is mentioned only by reference in this solution - see Appendix A for a link to the specification of the changes.
- Note that the changes to ensure that Load is updated on CALIDUS ePOD after the Load Metrics entry at the start of the load have already been completed in the latest version of the Android application, so no further modifications are required to that system.
Set-up
Pre-requisites
- A working CALIDUS ePOD system.
Menu Structure
None
Data
Modify or create an EPOD_XF_CONFIG record for EPL_XF_ID "LOAD" and ensure this has an EPL_XF_MSG_TYPE set to "BOTH". Assign this to a Site.
Functional Description
Admin Changes
Add the following new fields to the XF Config Maintenance screen XF_Config.aspx:
- EPL_XF_MSG_TYPE - A text field with allowed text values as follows:
- "START" - When Load Started
- "END" - When Load Completed - default value
- "BOTH" - When Load Started and Completed
This should be enabled for entry for export ID "LOAD" only. Note that the existing blank field value should default to "END".
Import/Export Changes
The current functionality to send LOAD_UPDATE messages (EPL_XF_ID = "LOAD") will be extended. The existing field EPL_XF_MSG_TYPE (referred to as EPL_XF_MSG_TYPES in other specifications) will be extended to define whether the process is sending messages at the start of a load (value "START"), end of a load (values "END" or blank) or both (value "BOTH").
This will be achieved by changing the existing database procedure EPOD_XFER_SELECT_LOAD to:
- Optionally link to the EPOD_XF_CONFIG of the Load's EPL_SITE_ID.
- Select records based on the value of EPOD_XF_CONFIG.EPL_XF_MSG_TYPE, as follows:
- "START" - EPL_STATUS = "I" AND EPL_XFER_FLAG = "" AND (EPL_MILEAGE_START <> 0 OR EPL_UDF_LOAD_START <> "")
- "END" or "" (blank) - (EPL_STATUS = "X" OR EPL_STATUS = "C") AND (EPL_XFER_FLAG = "" OR EPL_XFER_FLAG = "P")
- "BOTH" - The two above combined i.e. (EPL_STATUS = "I" AND EPL_XFER_FLAG = "" AND (EPL_MILEAGE_START <> 0 OR EPL_UDF_LOAD_START <> "") ) OR ( (EPL_STATUS = "X" OR EPL_STATUS = "C") AND (EPL_XFER_FLAG = "" OR EPL_XFER_FLAG = "P") )
Note: The existing load creation DAL and database definition or EPOD_LOAD and the database procedure EPOD_LOAD_INSERT must be checked to ensure that new loads are created with a blank value in EPL_XFER_FLAG.
The existing .NET procedure EPOD_SYS_EXPORT.ExportAllOutstandingLoads will take the returned records and interface them as per the settings. Note that any without a valid EPOD_XF_CONFIG against the site will be set as transferred (value "Y"). This procedure will be modified to check the value of EPL_XFER_FLAG before it is changed, as follows:
- "" (Blank) - Set to "N".
- "N" or "P" - Set to "Y".
The actual export XML sent for load updates need not be changed, as it already contains all the details required by external systems to update correctly.
Appendix A: Quote & Document References
| Cost Details | ||||
| Activity | Estimate No. of Days |
No. of Days | Rate per Day (£) | Cost (£ Exc. VAT) |
| Requirements | 0.00 | 0.00 | 0 | £0.00 |
| Change Request Evaluation | 0.00 | 0.00 | 0 | £0.00 |
| Functional Specification | 0.00 | 0.50 | 0 | £0.00 |
| Technical Specification | 0.00 | 0.00 | 0 | £0.00 |
| Development | 0.00 | 1.50 | 0 | £0.00 |
| Testing and Release | 0.00 | 0.25 | 0 | £0.00 |
| Implementation | 0.00 | 0.25 | 0 | £0.00 |
| Project Management | First argument to "number_format" must be a number. | First argument to "number_format" must be a number. | 0 | £First argument to "number_format" must be a number. |
| TOTAL | First argument to "number_format" must be a number. | First argument to "number_format" must be a number. | £First argument to "number_format" must be a number. | |
| Estimate excludes training, release to live and go live support. |
A.1 References
| Ref No | Document Title & ID | Version | Date |
| 1 | FS-311976 CTMS-ePOD Start End Stop Debrief | 1.0 |
A.2 Glossary
A.3 Authorised By
Matt Tipping | Project Manager | _____________________________ |
____________________(PRINT) | Client Representative | _____________________________ |
