Test: Difference between revisions

From Calidus HUB
VisualWikitext
m (Testing...)
m (Testing...)
Line 23: Line 23:
= Functional Overview  =
= Functional Overview  =
== Client Requirement  ==
== Client Requirement  ==
Currently, 'stop' debrief from {{#var:System}} is not possible for C-TMS where a trip has stops but 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.
Currently, 'stop' debrief from {{#var:System}} 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 ==
== Solution Overview ==
Line 44: Line 44:
== Scope ==
== Scope ==
* This functionality will be developed in the latest version of {{#var:System}} only.
* This functionality will be developed in the latest version of {{#var:System}} 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:_Quote_.26_Document_References|Appendix A]] for a link to the specification of the changes.
* Note that the changes to ensure that Load is updated on {{#var:System}} 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.




Line 78: Line 81:
* Optionally link to the EPOD_XF_CONFIG of the Load's EPL_SITE_ID.
* 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:
* Select records based on the value of EPOD_XF_CONFIG.EPL_XF_MSG_TYPE, as follows:
** "START" - EPL_XFER_FLAG = "" AND (EPL_MILEAGE_START <> 0 OR EPL_UDF_LOAD_START <> "")
** "START" - EPL_STATUS = "I" AND EPL_XFER_FLAG = "" AND (EPL_MILEAGE_START <> 0 OR EPL_UDF_LOAD_START <> "")
** "END" or "" (blank) - (EPL_XFER_FLAG = "" OR EPL_XFER_FLAG = "P")
** "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_XFER_FLAG = "" AND (EPL_MILEAGE_START <> 0 OR EPL_UDF_LOAD_START <> "") ) OR 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 <> "") ) AND ( (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.
{{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.

Revision as of 14:33, 25 February 2014





Aptean Logo.png







PROD

Load Start Metrics

CALIDUS ePOD

25th February 2014 - 0.1
Reference: FS XXXXXX











































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 DDL field with allowed text values as follows:
    • "START" - description "When Load Started"
    • "END" - description "When Load Completed" (default value)
    • "BOTH" - description "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 <> "") ) AND ( (EPL_STATUS = "X" OR EPL_STATUS = "C") AND (EPL_XFER_FLAG = "" OR EPL_XFER_FLAG = "P") )

Note 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 NoDocument Title & IDVersionDate
1FS-311976 CTMS-ePOD Start End Stop Debrief1.0


A.2 Glossary



A.3 Authorised By


Matt Tipping
Project Manager		_____________________________

____________________(PRINT)
Client Representative		_____________________________
Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=Test&oldid=1440’