CAPS

ORGANISATION

Organisation Name

UPRN

Unique Property Reference Number

USRN

Unique Street Reference Number

MAP_EAST

Coordinate

MAP_NORTH

Coordinate

POSTCODE

Postcode

SAO_START_NO

Secondary Addressable Object Start Number

SAO_START_SFX

Secondary Addressable Object Start Suffix

SAO_END_NO

Secondary Addressable Object End Number

SAO_END_SFX

Secondary Addressable Object End Suffix

SAO_DESC

Secondary Addressable Object Text

PAO_START_NO

Primary Addressable Object Start Number

PAO_START_SFX

Primary Addressable Object Start Suffix

PAO_END_NO

Primary Addressable Object End Number

PAO_END_SFX

Primary Addressable Object End Suffix

PAO_DESC

Primary Addressable Object Text

STREET_NAME

Street text

POST_TOWN

Post own

TOWN_NAME

Town

LOCALITY_NAME

Locality

DISTRICT_NAME

District

COUNTY_NAME

County

PR_BLPU

SELECT * FROM PR_BLPU or

SELECT * FROM UNI7LIVE.PR_BLPU where UNI7LIVE is the Oracle schema name.

PR_LPI

SELECT * FROM PR_LPI or

SELECT * FROM UNI7LIVE.PR_LPI

PR_ST_DESC

SELECT * FROM PR_ST_DESC or

SELECT * FROM UNI7LIVE.PR_ST_DESC

PR_STREET

SELECT * FROM PR_STREET or

SELECT * FROM UNI7LIVE.PR_STREET