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)

• Condition: Version must be present if Source value is one of the following: 7666MT, 7666MA or 7666MI.

• 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	Multiplicity
7666MT	OS MasterMap Topography Layer TOID.	[0..1]
7666MA	OS MasterMap Address Layer 2 TOID.	[0..1]
7666MI	OS MasterMap Highways TOID.	[0..1]
7666VC	Centrally created Council Tax.	[0..1]
7666VN	Centrally created non domestic rates.	[0..1]
7666OW	ONS Ward Code.	[0..1]
7666OP	ONS Parish Code.	[0..1]