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