For hosted customers please raise a new case online and reference the title of this article.
Mosaic queries the AddressBase database using views which are installed in the Mosaic database. There are two sets of views which we refer to as PAF or LLPG. These views are provided with the AddressBase Epoch releases.
To determine which views have been installed run the following SQL. If the Easting and Northing columns are NULL, then the PAF views have been installed. If the LLPG views have been installed the Easting and Northing columns will contain numbers.
select * from paf_ex_la where pcd='LE11 3QF'
The difference between the two sets of views is best described by comparing the benefits and drawbacks of each, please see below:
LLPG view
Benefits
Includes Eastings and Northings.
Includes more Flats (therefore returns more addresses).
Includes the PO box in the address.
Drawbacks
In some instances, returns the village name instead of the town/city.
In some instances, the Organisation name is not included.
PAF view
Benefits
Often faster (especially Oracle).
Includes the village name and town/city.
Includes Organisation name.
Drawbacks
Does not include Eastings and Northing.
Does not include all Flats so returns fewer addresses when searching.
Does not include the PO box in the address.