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.