Middletong at 12:27, 13 October 2009

2009-10-13T12:27:45Z

← Older revision		Revision as of 14:27, 13 October 2009
Line 30:		Line 30:
	To make the maintenance of postal and planning regions easier, the country code will be held against the postal \ planning region combination in Static Data Maintenance.		To make the maintenance of postal and planning regions easier, the country code will be held against the postal \ planning region combination in Static Data Maintenance.

	~~IMAGE~~		[[Image:256287_1.png]]

	A new tab will be added to the Country Code screen to allow the maintenance of the postal regions. Each country can have a postcode format assigned and within this format the relevant characters can be chosen.		A new tab will be added to the Country Code screen to allow the maintenance of the postal regions. Each country can have a postcode format assigned and within this format the relevant characters can be chosen.

	~~IMAGE~~		[[Image:256287_2.png]]

	The maintenance table will contain the Country code, the post code type and the relevant character of the postcode.		The maintenance table will contain the Country code, the post code type and the relevant character of the postcode.
Line 56:		Line 56:
	This will be changed to be dynamic. The postal region will be populated based on the format held against the country code.		This will be changed to be dynamic. The postal region will be populated based on the format held against the country code.

	~~IMAGE~~		= References =

	~~References~~		Not Available
	~~IMAGE~~

	~~Glossary~~		= Document History =
	~~IMAGE~~

	~~Document History~~		{\| Border="1"
	~~IMAGE~~		\| <center>'''Version'''</center>
			\| <center>'''Date'''</center>
			\| <center>'''Status'''</center>
			\| <center>'''Reason'''</center>
			\| <center>'''Initials'''</center>

	~~Authorised By~~		\|-
			\| <center>1a</center>
			\| <center>01/12/08</center>
			\| <center>Draft</center>
			\| Initial version
			\| <center>DNG</center>

	~~IMAGE~~		\|-
			\| <center>1</center>
			\| <center>02/12/08</center>
			\| <center>Issue</center>
			\| Reviewed and Issued
			\| <center>MJC</center>
			\|}


			= Authorised By =



			{\| Border="1"
			\| '''''Matt Crisford'''''
			\| Development Manager
			\|

			\|-
			\| '''''Suk Sandhu'''''
			\| TMSCC MTS Product Manager
			\|

			\|}

Kingj: New page: = 256287-NW-7KGE7N Fixed Routes to Run with Zip codes = Copyright OBS Logistics © 2007 The information contained herein is the property of OBS Logistics and is supplied without liabilit...

2009-02-05T16:47:17Z

New page

= 256287-NW-7KGE7N Fixed Routes to Run with Zip codes =

Copyright OBS Logistics © 2007

The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied

= FUNCTIONAL OVERVIEW =

== Client Requirement ==
Fixed Routes currently utilises either locations or regions at stop level, the postal regions work based on the first sector of the UK post code, for example B or CV whereas the planning region can be defined against these i.e. MID for Midlands comprising both B and CV. There are now possibilities of deploying MTS in the likes of Portugal and Poland where ZIP Codes are defined differently and so within MTS there will be a requirement to define Fixed Routes by ZIP region and hence there may be different sectors of the ZIP code that need to be referenced dependent on the country. The same code or translation will also need to be applied when defining planning regions.

== Solution ==
The Fixed routes functionality should be able to handle any changes to the postal or planning regions. Providing the regions are set up correctly.
However, the postal and planning regions currently will not work for post (zip) codes that are numeric or that use digits other than the first two digits of the post code. The logic behind the postal and planning regions will be changed to allow the use of numeric postcodes.
Firstly the country code will be held against the postal \ planning region combinations on the table geo_plan_region.
A new table, and maintenance screen will be created that will store the details of a country’s postcode and define which parts of the post code are relevant when defining the postal region
The locations screen works out the postal region based on the post code entered. The new table will be used to determine which parts of the postcode should be used when working out the postal region. The postal region can then be used to determine the planning region based on the data in geo_plan_region.

== Scope ==
This change will be applied to system version 10.6.

= FUNCTIONAL DESCRIPTION =

To make the maintenance of postal and planning regions easier, the country code will be held against the postal \ planning region combination in Static Data Maintenance.

IMAGE

A new tab will be added to the Country Code screen to allow the maintenance of the postal regions. Each country can have a postcode format assigned and within this format the relevant characters can be chosen.

IMAGE

The maintenance table will contain the Country code, the post code type and the relevant character of the postcode.

If more than one character of the postcode is relevant multiple entries can be made.

So for GB we would store

GB CHAR 1
GB CHAR 2

For Poland

PL NUM 1

This would indicate that the first 2 characters are relevant for the UK, if they are Letters. While the first character is relevant for Poland.

Within the Locations screen the postal region is calculated based on the postcode entered. Currently it will only look at the first two characters of the postcode if the characters are letters (i.e. for UK postcodes).

This will be changed to be dynamic. The postal region will be populated based on the format held against the country code.

IMAGE

References
IMAGE

Glossary
IMAGE

Document History
IMAGE

Authorised By

IMAGE

256287 - Revision history

Middletong at 12:27, 13 October 2009

Kingj: New page: = 256287-NW-7KGE7N Fixed Routes to Run with Zip codes = Copyright OBS Logistics © 2007 The information contained herein is the property of OBS Logistics and is supplied without liabilit...