Table-NLPG_LPI

Created by: Lester Caine, Last modification: 20 Aug 2008 (10:17 UTC)
Field Type NULL Default Description
UPRN Numeric(18,0) NOT NULL
Unique property reference number
XREF_KEY Varchar(14) Primary
Unique key for xref entries
LANGUAGE Varchar(4) Primary
Language for this record
LOGICAL_STATUS Smallint


START_DATE Date NOT NULL

END_DATE Date


ENTRY_DATE Date NOT NULL

LAST_UPDATE_DATE Date NOT NULL

SAO_START_NUMBER Smallint


SAO_START_SUFFIX Varchar(1)


SAO_END_NUMBER Smallint


SAO_END_SUFFIX Varchar(1)


SAO_TEXT Varchar(90)


PAO_START_NUMBER Smallint


PAO_START_SUFFIX Varchar(1)


PAO_END_NUMBER Smallint


PAO_END_SUFFIX Varchar(1)


PAO_TEXT Varchar(90)


USRN Numeric(18,0) NOT NULL

V_LEVEL Varchar(30)


POSTALLY_ADDRESSABLE Varchar(1) NOT NULL

POSTCODE Varchar(8)


POST_TOWN Varchar(30)


OFFICIAL_FLAG Varchar(1)


CUSTODIAN_ONE Smallint


CUSTODIAN_TWO Smallint


CAN_KEY Varchar(14)


SAO Varchar(110)

Constructed copy of the SAO fields combined to a string
PAO Varchar(110)

Constructed copy of the PAO fields combined to a string

These records have been split from the main street record in order to allow different language versions of the information to be recorded. Currently the system is being developed hard coded to use 'ENG' as there is no other language information available for testing, but adding a switch to select a different language in the display fields will be relatively easy to add later.
SAO and PAO fields are combined to provide fast access to a single text string. The Start and End SUFFIX is only used if available. If there is an END_NUMBER, then a start number is assumed to exist, and a '-' is created between the two. To simplify generation, a comma is not included after the number element, and if no numbers are present, then the text is simply a copy of the _TEXT element. The combined SAO and PAO elements would be joined by a comma if the SAO element has text in it.