# Application Cross Reference – (Type 23 Record)

Application cross reference links to third-party identifiers.

AddressBase Premium application cross references contain a lookup between the AddressBase Premium UPRN and the unique identifiers of other relevant datasets.

### 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 Application Cross Reference Record (type 23).

* **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 application cross reference record to the corresponding BLPU.

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

### Xref key

Unique key for the application cross reference record and primary key for this table.

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

### Cross reference

Primary key of corresponding record in an external dataset.

* **Attribute Name**: crossReference (GML), CROSS\_REFERENCE (CSV), cross\_reference (GPKG)
* **Data Type**: CharacterString (GML), char (CSV), String (GPKG)
* **Size**: 50
* **Multiplicity**: \[1]

### Version

Certain data sources may reference objects with lifecycles. This field enables users to reference specific versions of an object, for example, OS MasterMap Topographic Layer TOID and Version.

* **Attribute Name**: version (GML), VERSION (CSV), version (GPKG)
* **Data Type**: Integer
* **Size**: 3
* **Multiplicity**: \[0..1]

### Source

External dataset identity.

* **Attribute Name**: source (GML), SOURCE (CSV), source (GPKG)
* **Data Type**: CharacterString (GML), char (CSV), String (GPKG)
* **Size**: 6
* **Multiplicity**: \[1]

### Start date

Date the feature was matched to the cross reference dataset for the first time.

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

### End date

The date on which the external cross reference was no longer valid.

* **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 date on which any attribute on this record was last changed.

* **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 Local Authority record matched to the cross reference 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]

## **Values for the SOURCE (source) column**

{% hint style="info" %}
The values in this table are not a code list and may be amended or extended in the future.
{% endhint %}

| Dataset ID | Data source                           |
| ---------- | ------------------------------------- |
| 7666VC     | Centrally created Council Tax.        |
| 7666VN     | Centrally created non-domestic rates. |
| 7666OW     | ONS Ward Code.                        |
| 7666OP     | ONS Parish Code.                      |
| 7666CU     | Channel Islands unique identifier.    |
| 7666CS     | Channel Islands Street identifier.    |
| 7666NS     | Northern Ireland Street identifier.   |
| 7666IS     | Isle of Man Street identifier.        |

{% hint style="info" %}
*The values in the table above are not a code list and may be amended or extended in the future. 7666CU, 7666CS, 7666NS and 7666IS are all specific to AddressBase Premium Islands.*
{% endhint %}