FS 325465 SCR-HEW-006 Last 3 Loads Retrieval
Hewicks Haulage
Last 3 Loads Retrieval
CALIDUS EPOD
27th March 2015 - 1.0
Reference: FS 325465 SCR-HEW-006
Contents
Functional Overview
Client Requirement
As part of the Drivers POC document the last 3 loads the trailer has taken must be shown on the POC note. The EPOD system needs to be able to link back to the last 3 loads that have been on the trailer. These will then be displayed on the POC note. The information required here is the Product description. Note this is only required on the POC note not on any POD notes
Solution Overview
Note: This development is a requirement for completion of 325463 SCR-HEW-005. It is dependent on the changes specified in 325462 SCR-HEW-2.5. Both changes are referenced in Appendix A.
The driver will identify the trailer used when starting a load on the CALIDUS EPOD mobile device application.
This will be passed back to and stored on the CALIDUS EPOD server, in the Job Trailer ID and the Load Trailer ID.
The CALIDUS EPOD system will be modified to:
- Add a new procedure to select the last 3 collection jobs before this job was collected for the trailer, load and job provided and return the Job and Product Details.
- Add a call to this procedure in the new Hewicks POC note format, which will use the returned values to get the jobs and retrieve the first product on these jobs.
Scope
The changes will be made to the latest version of the CALIDUS EPOD system.
Set-up
Pre-requisites
A valid CALIDUS EPOD system is required.
Menu Structure
None
Data
None
Functional Description
Database Changes
A new database procedure will be written to select the last 3 collection jobs before this job was collected for the trailer, load and job provided and return the Job and Product Details.
The procedure will be called with the Site ID and Job ID as a parameter.
The procedure will get all the jobs as follows:
- Select only jobs for this site.
- Select on Collection jobs.
- Select only jobs that use the trailer of the passed-in Job ID, which are not the passed-in Job ID.
- Sort by Actual Start Date and Time in ascending sequence.
- Select only the top 3 jobs from the sorted result.
- Sort the result in Actual Start Date and Time in descending sequence
Note: How this procedure will be used to populate the section on the Hewicks Collection note will be covered in the technical specification of that change, namely 325463 SCR-HEW-005.
Example:
The following loads and jobs have been processed in the system for trailer TR1:
Load LOAD1:
- Collection Job 1, for customer order CO1
- Collection Job 2, for customer order CO2
- Delivery Job 3, for customer order CO1
- Delivery Job 4, for customer order CO2
- Collection Job 5, for customer order CO3
- Delivery Job 6, for customer order CO3
Load LOAD2:
- Collection Job 7, for customer order CO4
- Delivery Job 8, for customer order CO4
- Collection Job 9, for customer order CO5
- Delivery Job 10, for customer order CO5
- Collection Job 11, for customer order CO6
- Delivery Job 12, for customer order CO6
All jobs have been processed in this order, with actual start date and times 15 minutes later than the previous job.
The following jobs will be selected when printing the collection notes for the collection jobs:
- Collection Job 1 will display the products from no jobs, as there are no previous loads
- Collection Job 2 will display the products from the following jobs, in this sequence:
- Collection Job 1.
- Collection Job 5 will display the products from the following jobs, in this sequence:
- Collection Job 2.
- Collection Job 1.
- Collection Job 7 will display the products from the following jobs, in this sequence:
- Collection Job 5.
- Collection Job 2.
- Collection Job 1.
- Collection Job 9 will display the products from the following jobs, in this sequence:
- Collection Job 7.
- Collection Job 5.
- Collection Job 2.
- Collection Job 11 will display the products from the following jobs, in this sequence:
- Collection Job 9.
- Collection Job 7.
- Collection Job 5.
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 | 750 | £0.00 |
| Change Request Evaluation | 0.00 | 0.00 | 750 | £0.00 |
| Functional Specification | 0.50 | 0.50 | 750 | £375.00 |
| Technical Specification | 0.50 | 0.50 | 750 | £375.00 |
| Development | 2.00 | 1.75 | 750 | £1,312.50 |
| Testing and Release | 0.50 | 0.50 | 750 | £375.00 |
| Implementation | 0.00 | 0.00 | 750 | £0.00 |
| Project Management | 0.00 | 0.00 | 750 | £0.00 |
| TOTAL | 3.50 | 3.25 | £2,437.50 | |
| Estimate excludes training, release to live and go live support. |
A.1 References
| Ref No | Document Title & ID | Version | Date |
| 1 | 322793 - REQ-Hewicks Haulage | 3.0 | 12/03/2015 |
| 2 | FS 325462 SCR-HEW-2.5 PDA Trailer Selection | 1.0 | 27/03/2015 |
| 3 | FS 325463 SCR-HEW-005 5 New POD Formats | 0.1 | 27/03/2015 |
A.2 Glossary
| Term | Definition |
|---|---|
| EPOD | Electronic Proof of Delivery. The OBS EPOD system is CALIDUS ePOD. |
| CALIDUS eSERV | The OBS mobile system to complete Service functionality in the field. This is part of the CALIDUS ePOD system. |
| PDA | The mobile device on which the C-ePOD system will run in the field. This can be a Phone, EDA or industrial PDA, running Android. |
| DAL | Data Access Layer. A mechanism for accessing data by the system that is removed from the application, allowing for simplified access and providing protection to the data, as only approved DAL methods can be used to modify it. |
| GPS | Global Positioning System. A mechanism of retrieving accurate positioning information in the form of Latitude and Longitude (Lat-Long) co-ordinates from a device. |
| GPRS, 3G, HSDPA, Data Service | All terms referring to mobile device network connectivity, and the speed at which the device connects to the internet. |
A.3 Authorised By
Matt Tipping | OBS Logistics Representative | _____________________________ |
Christopher Hewick | Hewicks Haulage Representative | _____________________________ |
Carl Brinkley | Hewicks Haulage Representative | _____________________________ |
