294633

DHL C-TMS

Modify Decodes to Map Location Details

FUNCTIONAL SPECIFICATION - 10.7

12/01/12 - 1.0
Reference: FS 294633 NW-8PNK44

FUNCTIONAL OVERVIEW

Client Requirement

Given that DHL Link are not mapping the multiple Unison client locations into single codes within C-TMS, this activity will need to be carried out via the ‘Decodes’ in C-TMS.

The intention is to use the existing decodes functionality to map circa 750,000 locations in Unison down to circa 75,000 locations within C-TMS. This data will potentially need to be loaded as part of this RIO due to the volume of data.

In addition to this the following process will be adopted operationally and needs to be supported by C-TMS:

• Order file sent from Unison to C-TMS via DHL Link and processed within C-TMS.
• Where a location map does not exist in the ‘Decode’ table and an identical location ID does not exist in C-TMS, the order record should fail and not create an order - note that if the file contains multiple records only the individual record should fail, not the whole file.
• A configurable alert should be generated to send a message via either e-mail, SMS or both that records have failed in the file (name and time to be specified).
• The failed record(s) can then be manually corrected and re-processed.

Solution

The ‘CN_LOCATION_MAPPING’ decode name will be used to store the mapping of the Unison locations as a source value and the C-TMS locations as a target value.

The ‘CN_LOCATION_MAPPING’ decodes will have their source and target values uploaded via a ‘DECODE’ import type from a comma-delimited ‘CSV’ file provided by Healthcare UK.

N.B. The number of records involved will require a separate process to be developed by OBS Logistics for use instead of the standard import process.

The process will be run as a data upload using temporary external tables that will then be used to replace the ‘IMP_DECODE_ENTRY’ database table. The existing data will be stored as a backup beforehand and then re-added afterwards.

The standard import process may still be setup for smaller files to be processed in future.

The processes to import transport orders into C-TMS using ‘CSV’ or ‘XML’ files will be changed to assess whether the ‘from’ and ‘to’ locations provided are valid locations in C-TMS or exist as decoded locations: if they are not valid or do not exist then new locations will not be created in C-TMS and the transport order will not be uploaded.

Should a transport order in the file fail to upload then a configurable alert message will be sent to the relevant user. This alert will be sent as an e-mail and/or an SMS message as setup in the ‘Messaging Maintenance’ screen with a new message type and a new event type.