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

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 (GKPG)

• 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 (GKPG)

• Data Type: Integer

• Size: 2

• Multiplicity: [1]

Change type

Type of record change – please see COU supply for more information.

• Attribute Name: Not provided (GML), CHANGE_TYPE (CSV), change_type (GKPG)

• Code List Name: 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 (GKPG)

• 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 (GKPG)

• 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 (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 14

• Multiplicity: [1]

Cross reference

Primary key of corresponding record in an external dataset.

• Attribute Name: crossReference (GML), CROSS_REFERENCE (CSV), cross_reference (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• 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 (GKPG)

• Data Type: Integer

• Size: 3

• Multiplicity: [0..1]

Source

External dataset identity.

• Attribute Name: source (GML), SOURCE (CSV), source (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• 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 (GML), START_DATE (CSV), start_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

End date

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

• Attribute Name: Provided in EntityWithLifeCycle (GML), END_DATE (CSV), end_date (GKPG)

• 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 (GML), LAST_UPDATE_DATE (CSV), last_update_date (GKPG)

• 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 (GML), ENTRY_DATE (CSV), entry_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

Values for the SOURCE (source) column

The values in this table are not a code list and may be amended or extended in the future.

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.

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.