Table-CLIENT_XREF
Created by: Lester Caine, Last modification: 20 Aug 2008 (11:12 UTC)
| Field | Type | NULL | Default | Description |
| UCRN | Numeric(18,0) | not null | Unique client reference number | |
| XREF_KEY | Varchar(14) | not null | Key value to uniquely identify record | |
| START_DATE | Date | not null | NOW | Date activity started |
| LAST_UPDATE_DATE | Date | not null | NOW | Date last updated |
| ENTRY_DATE | Date | not null | NOW | Date record was created |
| END_DATE | Date | Date activity ceased | ||
| CROSS_REFERENCE | Varchar(20) | not null | Primary key of record in associated data set | |
| SOURCE | Varchar(6) | not null | Identification of associated data set (see also NLPG Cross-reference Source Codes ) |
These fields mirror those provided in the NLPG data set and a sub set of the source records are duplicated.
Additional SOURCE identifiers are provided for client and address references and these local special cases are identified with a '#' prefix.
| Source | Description | Reference Type | Note | |
| #R | Residential Address | UPRN | Indicates an owner occupier | |
| #T | Tenant Address | UPRN | Indicates a tenant occupier | |
| #C | Correspondence Address | UPRN | Alternate address for correspondence | |
| #O | Owner Address | UPRN | Used to add additional properties a client owns | |
| #K | Keyholder | UCRN | Used with corporate entries to identify out of hours contact | |
| HBEN | Housing Benefit | |||
| CTAX | Council Tax | |||
| NNDR | National Non-domestic Rates | |||
| ER | Electoral Roll | |||