Mosaic queries the AddressBase database using views installed in the Mosaic database. There are two sets of views: PAF and LLPG. These views are provided with the AddressBase Epoch releases.
One known difference between the two view types is that the PAF views do not include the PO Box in addresses. This means that when searching an address, Mosaic may return only one result even though Royal Mail lists multiple.
Identify which views are installed
To determine which views have been installed, run the following SQL query. If the Easting and Northing columns return NULL, the PAF views are installed. If they contain numbers, the LLPG views are installed.
select * from paf_ex_la where pcd='LE11 3QF'
LLPG views
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 or city.
In some instances, the organisation name is not included.
PAF views
Benefits
Often faster, especially on Oracle.
Includes the village name and town or city.
Includes the organisation name.
Drawbacks
Does not include Eastings and Northings.
Does not include all flats, so returns fewer addresses when searching.
Does not include the PO Box in the address.