# LPI – (Type 24 Record)

An LPI is a structured entry that identifies a BLPU. It is a simple identifier or description for the object. The richness of the data structure within AddressBase Premium provides the facility to describe a [BLPU](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-premium/addressbase-premium-technical-specification/feature-types/blpu-type-21-record) by more than one LPI.

### Data type attributes <a href="#data-type-attributes" id="data-type-attributes"></a>

The following page provides details about the attributes included with this data type, their types in the different output formats, and other important metadata about them.

### fid

A non-persistent integer which is autogenerated and is required within the OGC GPKG format.

* **Attribute Name**: Not provided (GML), Not provided (CSV), fid (GPKG)
* **Data Type:** Integer
* **Multiplicity**: \[1]

### Record identifier

Identifies this Record as an LPI Record (type 24).

* **Attribute Name**: Not provided (GML), RECORD\_IDENTIFIER (CSV), Not provided (GPKG)
* **Data Type:** Integer
* **Size**: 2
* **Multiplicity**: \[1]

### Change type

Type of record change – please see [COU supply](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-premium-islands/supply-and-update#cou-supply) for more information.

* **Attribute Name**: Not provided (GML), CHANGE\_TYPE (CSV), change\_type (GPKG)
* **Code List Name:** [ChangeTypeCode](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-fundamentals/code-lists-and-enumerations/changetypecode)
* **Size**: 1
* **Multiplicity**: \[1]

### Pro order

The order in which the records were processed in to create the data supply.

* **Attribute Name**: Not provided (GML), PRO\_ORDER (CSV), Not provided (GPKG)
* **Data Type**: Integer
* **Size**: 16
* **Multiplicity**: \[1]

### UPRN

Unique Property Reference Number (UPRN) - foreign key used to reference the LPI to the corresponding BLPU.

* **Attribute Name**: Not provided (GML), UPRN (CSV), uprn (GPKG)
* **Data Type**: Integer
* **Size**: 12
* **Multiplicity**: \[1]

### LPI key

Unique key for the LPI and primary key for this table.

* **Attribute Name**: lpiKey (GML), LPI\_KEY (CSV), lpi\_key (GPKG)
* **Data Type**: CharacterString (GML), char (CSV), String (GPKG)
* **Size**: 14
* **Multiplicity**: \[1]

### Language

{% hint style="info" %}
For GML language qualifiers are provided in the parent element as ‘xml:lang’
{% endhint %}

A code that identifies the language used for the LPI record.

* **Attribute Name**: Not provided (GML), LANGUAGE (CSV), language (GPKG)
* **Code List Name**: [LanguageCode](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-fundamentals/code-lists-and-enumerations/languagecode)
* **Size**: 3
* **Multiplicity**: \[1]

### Logical status

Logical status of this record.

* **Attribute Name**: logicalStatus (GML), LOGICAL\_STATUS (CSV), logical\_status (GPKG)
* **Code List Name**: [LogicalStatusCode](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-fundamentals/code-lists-and-enumerations/logicalstatuscode)
* **Size**: 1
* **Multiplicity**: \[1]

### Start date

Date that this LPI record was first loaded into the database.

* **Attribute Name**: Provided in [EntityWithLifeCycle](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-premium-islands/addressbase-premium-islands-technical-specification/structured-data-types/entity-with-lifecycle) (GML), START\_DATE (CSV), start\_date (GPKG)
* **Data Type**: Date
* **Multiplicity**: \[1]

### End date

The date this record ceased to exist in the database.

* **Attribute Name**: Provided in [EntityWithLifeCycle](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-premium-islands/addressbase-premium-islands-technical-specification/structured-data-types/entity-with-lifecycle) (GML), END\_DATE (CSV), end\_date (GPKG)
* **Data Type**: Date
* **Multiplicity**: \[0..1]

### Last update date

The last date an attribute on this record was last changed in the product database.

* **Attribute Name**: Provided in [EntityWithLifeCycle](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-premium-islands/addressbase-premium-islands-technical-specification/structured-data-types/entity-with-lifecycle) (GML), LAST\_UPDATE\_DATE (CSV), last\_update\_date (GPKG)
* **Data Type**: Date
* **Multiplicity**: \[1]

### Entry date

The date on which the record was inserted into the Local Authority database.

* **Attribute Name**: Provided in [EntityWithLifeCycle](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-premium-islands/addressbase-premium-islands-technical-specification/structured-data-types/entity-with-lifecycle) (GML), ENTRY\_DATE (CSV), entry\_date (GPKG)
* **Data Type**: Date
* **Multiplicity**: \[1]

### SAO start number

The number of the secondary addressable object (SAO) or the start of the number range.

* **Attribute Name**: saoStartNumber (GML), SAO\_START\_NUMBER (CSV), sao\_start\_number (GPKG)
* **Condition**: If a SAO Start Number is present a PAO Start Number or PAO text must also be present.
* **Data Type**: Integer
* **Size**: 4
* **Multiplicity**: \[0..1]

### SAO start suffix

The suffix to the SAO\_START\_NUMBER, for example ‘A’ or ‘B’.

* **Attribute Name**: saoStartSuffix (GML), SAO\_START\_SUFFIX (CSV), sao\_start\_suffix (GPKG)
* **Condition**: If a SAO Start Suffix is present a SAO Start Number must also be present.
* **Data Type**: CharacterString (GML), char (CSV), String (GPKG)
* **Size**: 2
* **Multiplicity**: \[0..1]

### SAO end number

The end of the number range for the SAO, where the SAO\_START\_NUMBER contains the first number in the range.

* **Attribute Name**: saoEndNumber (GML), SAO\_END\_NUMBER (CSV), sao\_end\_number (GPKG)
* **Condition**: If SAO End Number is present, a SAO Start Number must also be present.
* **Data Type**: Integer
* **Size**: 4
* **Multiplicity**: \[0..1]

### SAO end suffix

The suffix to the SAO\_END\_NUMBER, for example, ‘A’ or ‘B’.

* **Attribute Name**: saoEndSuffix (GML), SAO\_END\_SUFFIX (CSV), sao\_end\_suffix (GPKG)
* **Condition**: If a SAO End Suffix is present, a SAO End Number must also be present.
* **Data Type**: CharacterString (GML), char (CSV), String (GPKG)
* **Size**: 2
* **Multiplicity**: \[0..1]

### SAO text

Describes the SAO, such as ‘Maisonette’ or ‘Flat 1’.

* **Attribute Name**: saoText (GML), SAO\_TEXT (CSV), sao\_text (GPKG)
* **Condition**: If SAO Text is present, a PAO Start Number or PAO Text must also be present.
* **Data Type**: LocalisedCharacterString (GML), char (CSV), String (GPKG)
* **Size**: 90
* **Multiplicity**: \[0..1]

### PAO start number

The number of the primary addressable object (PAO) or the start of the number range.

* **Attribute Name**: paoStartNumber (GML), PAO\_START\_NUMBER (CSV), pao\_start\_number (GPKG)
* **Condition**: PAO Start Number must be present if PAO Text is not present.
* **Data Type**: Integer
* **Size**: 4
* **Multiplicity**: \[0..1]

### PAO start suffix

The suffix to the PAO\_START\_NUMBER, for example, ‘A’ or ‘B’.

* **Attribute Name**: paoStartSuffix (GML), PAO\_START\_SUFFIX (CSV), pao\_start\_suffix (GPKG)
* **Condition**: If a PAO Start Suffix is present, a PAO Start Number must also be present.
* **Data Type**: CharacterString (GML), char (CSV), String (GPKG)
* **Size**: 2
* **Multiplicity**: \[0..1]

### PAO end number

The end of the number range for the PAO where the PAO\_START\_NUMBER contains the first number in the range.

* **Attribute Name**: paoEndNumber (GML), PAO\_END\_NUMBER (CSV), pao\_end\_number (GPKG)
* **Condition**: If a PAO End Number is present, a PAO Start Number must also be present.
* **Data Type**: Integer
* **Size**: 4
* **Multiplicity**: \[0..1]

### PAO end suffix

The suffix to the PAO\_END\_NUMBER, for example, ‘A’ or ‘B’.

* **Attribute Name**: paoEndSuffix (GML), PAO\_END\_SUFFIX (CSV), pao\_end\_suffix (GPKG)
* **Condition**: If a PAO End Suffix is present, a PAO End Number must also be present.
* **Data Type**: CharacterString (GML), char (CSV), String (GPKG)
* **Size**: 2
* **Multiplicity**: \[0..1]

### PAO text

Name describing the PAO, this is normally a building name such as ‘Harbour View’.

* **Attribute Name**: paoText (GML), PAO\_TEXT (CSV), pao\_text (GPKG)
* **Condition**: PAO Text must be present if PAO Start Number is not present.
* **Data Type**: LocalisedCharacterString (GML), char (CSV), String (GPKG)
* **Size**: 90
* **Multiplicity**: \[0..1]

### USRN

Unique Street Reference Number (USRN) - foreign key linking the Street record to the LPI record.

* **Attribute Name**: usrn (GML), USRN (CSV), usrn (GPKG)
* **Data Type**: Integer
* **Size**: 8
* **Multiplicity**: \[1]

### USRN match indicator

This field indicates how the item was matched to a Street. 1 is matched manually to the most accessible USRN and 2 is matched spatially to the nearest USRN, which may not be the nearest accessible street.

* **Attribute Name**: usrnMatchIndicator (GML), USRN\_MATCH\_INDICATOR (CSV), usrn\_match\_indicator (GPKG)
* **Code List Name**: [USRNMatchIndicatorCode](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-fundamentals/code-lists-and-enumerations/usrnmatchindicatorcode)
* **Size**: 1
* **Multiplicity**: \[1]

### Area name

Third level of geographic area name, for example, to record island names (Guernsey) or contain the TOWNLAND value for Northern Ireland records.

* **Attribute Name**: areaName (GML), AREA\_NAME (CSV), area\_name (GPKG)
* **Data Type**: CharacterString (GML), char (CSV), String (GPKG)
* **Size**: 40
* **Multiplicity**: \[0..1]

### Level

Detail on the vertical position of the property if known and provided by the Local Authority Custodian.

* **Attribute Name**: level (GML), LEVEL (CSV), level (GPKG)
* **Data Type**: CharacterString (GML), char (CSV), String (GPKG)
* **Size**: 30
* **Multiplicity**: \[0..1]

### Official flag

Status of the Address.

* **Attribute Name**: officialFlag (GML), OFFICIAL\_FLAG (CSV), official\_flag (GPKG)
* **Code List Name**: [OfficialFlagCode](https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-fundamentals/code-lists-and-enumerations/officialflagcode)
* **Size**: 1
* **Multiplicity**: \[0..1]