Table-NLPG_BLPU

Created by: Lester Caine, Last modification: Wed 20 of Aug, 2008 (10:03 UTC)
Field Type NULL Default Description
UPRN Numeric(18,0) Primary    
LOGICAL_STATUS Smallint NOT NULL    
BLPU_STATE Smallint      
BLPU_STATE DATE Date      
BLPU_CLASS Varchar(4) NOT NULL    
PARENT_UPRN Numeric(18,0)      
X_COORDINATE Double precision NOT NULL    
Y_COORDINATE Double precision NOT NULL    
RPA Smallint NOT NULL    
LOCAL_CUSTODIAN_CODE Smallint NOT NULL    
START_DATE Date NOT NULL NOW  
END_DATE Date      
LAST_UPDATE_DATE Date NOT NULL NOW  
ENTRY_DATE Date NOT NULL NOW  
ORGANISATION Varchar(100)      
WARD_CODE Varchar(6)      
PARISH_CODE Varchar(7)      
CUSTODIAN_ONE Smallint      
CUSTODIAN_TWO Smallint      
CAN_KEY Varchar(14)      


BLPU_CLASS lookup in NLPG_BLPU_CLASS
WARD_CODE lookup in NLPG_ONS_WARD
PARISH_CODE lookup in NLPG_ONS_PARISH

Links to
NLPG_BLPU_PROVENANCE
NLPG_BLPU_XREF
NLPG_LPI
NLPG_EXTENT