Table-NLPG_LPI

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.