291378

DHL C-TMS

Debrief

FUNCTIONAL SPECIFICATION - 10.7

24/10/2011 - 3.0
Reference: FS 291375-MS-8KNJ3E

Functional Overview

Client Requirement

Capture Hours worked on behalf of DHL

Solution

Additional fields will be added to the Driver Debrief Tab of the Trip Debrief form to capture the total Driver’s Work time in Days, Hours and Minutes, as per the existing field which capture Trip, Drive and Break times.

It is assumed these fields will be populated by manual debrief entry staff and that no integration changes will be needed as part of this RIO

The display of the new fields will be controlled by a system parameter.

Scope

This change will be applied to system version 10.7

Set-up

Pre-requisites

None

Menu Structure

Unchanged

Data

A new cost centre based system parameter will be created DEBRIEF_DRIVERS_HOURS this parameter will control the display of the new fields in the trip debrief screen.

A new field will be added to the SCH_TRIP table to hold total driver hours.

Implementation Advice

A system super user will be required to ensure that the system parameters are correctly set.

Functional Description

Manual Debrief

A new column will be added to the SCH_TRIP table to hold drivers work time in minutes. Three new fields for Drivers work time in Days, Hours and Minutes will be added to the Driver Debrief tab of the Trip Debrief screen. These fields will only be displayed if the DEBRIEF_DRIVERS_HOURS system parameter is set if this parameter is not set the fields should not be displayed and the current functionality will be used. A suggested layout is displayed below.

The fields will be numeric. The values entered must be less than the total trip time. The information entered will be converted into minutes as per the current format for total trip work and total trip break and then stored in the total driver hours column.

Orders Driver Time Debrief

The driver times for microlise enabled orders will be debriefed automatically from Microlise. Microlise currently sends the trip stop actual arrive and depart times. Actual arrive at the SU stop is used to set the START_TIME on the trip and Actual depart from the final stop is used to set the END_TIME on the trip.

The difference between the two values will be calculated to determine the driver time. The driver time will be stored in minutes, and will be converted to days, hours, minutes on the Debrief screen when the trip is displayed.

If the order is a Network Rail order and the actual arrive time on the SU stop and the actual depart time on the last stop have been populated, Validate_Trip will calculate the driver minutes using the trip start and end times.

Modules to be changed

Module Name	Module Type	Notes
TRIPDTL.fmb	Form	Add new fields

References

Ref No	Document Title & ID	Version	Date
1	EST-291378 MS-8KNJ3E Debrief	1.0	20/09/11

Glossary

Term or Acronym	Meaning
C-TMS	Calidus TMS

Document History

Version	Date	Status	Reason	Initials
0.1	12/10/11	Draft	Initial version	CAK
0.2	12/10/11	Draft	Revised	MJC
1.0	12/10/11	Issued	Reviewed and Issued	MJC
1.1	21/10/11	Draft	Revised following client review	SEW
2.1	24/10/11	Draft	Revised following client review	CAK
3.0	24/10/11	Issue	Reviewed and Issued	MJC

AUTHORISED BY

Matt Crisford	Development Manager
Peter Greer	TMSCC MTS Product Manager