This table provides a list of (full or partial) postcodes (or, more generally, any 8 character location code) known to the system. (It is needed to allow the user to be presented with a list of postcodes which have not been assigned to a region.)

Table Definition

Field	Type	Default	Nullable
postcode	varchar2(30)
region_no	number(9)
lat	number(18,9)
lon	number(18,9)
obsolete	integer
visible	number(1)
lat_long_option	number(2)

Keys

primary key (postcode)

foreign key (region_no) references sp057_regions (region_no)

Column Descriptions

Field	Description
postcode	A full or partial postcode, or other (customer defined) location code.
region_no	region to which this postcode is mapped
lat	lat/lon co-ordinates of postcode (coordinate system WGS84)
lon
obsolete	Marker used to indicate postcode no longer used
visible	Marker used to denote whether the point should be drawn on the map in Planner.
lat_long_option	reserved for future enhancements

Browser not supported