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