Table-NLPG_BLPU
Created by: Lester Caine, Last modification: 20 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 Table-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