AdminBoundaryLookup

AdminBoundaryLookup

Attributes

Attribute Code

Attribute Name

SQL DB Data Type

ReportNet3 Data Type

Properties

Code list

Related table(s)

In Reporting

ABL_01

adm_id

smallint

PK

ABL_02

ICC

nvarchar(50)

ABL_03

adm_country

nvarchar(50)

ABL_04

level3_name

nvarchar(100)

ABL_05

level2_name

nvarchar(100)

ABL_06

level1_name

nvarchar(100)

ABL_07

level0_name

nvarchar(50)

ABL_08

level3_code

nvarchar(50)

ABL_09

level2_code

nvarchar(50)

ABL_10

level1_code

nvarchar(50)

ABL_11

level0_code

nvarchar(50)

ABL_12

EEA32_2020

bit

ABL_13

EEA38_2020

bit

ABL_14

EEA39

bit

ABL_15

EEA33

bit

ABL_16

eea32

bit

ABL_17

eu27_nouk

bit

ABL_18

EU28

bit

ABL_19

eu27

bit

ABL_20

EU25

bit

ABL_21

EU15

bit

ABL_22

EU12

bit

ABL_23

EU10

bit

ABL_24

EFTA4

tinyint

ABL_25

NUTS_EU

nvarchar(50)

ABL_26

TAA

nvarchar(50)

ABL_27

NUTSYear

int

PK

Attribute details

ABL_01 - adm_id

ABL_02 - ICC

ABL_03 - adm_country

ABL_04 - level3_name

ABL_05 - level2_name

ABL_06 - level1_name

ABL_07 - level0_name

ABL_08 - level3_code

ABL_09 - level2_code

ABL_10 - level1_code

ABL_11 - level0_code

ABL_12 - EEA32_2020

ABL_13 - EEA38_2020

ABL_14 - EEA39

ABL_15 - EEA33

ABL_16 - eea32

ABL_17 - eu27_nouk

ABL_18 - EU28

ABL_19 - eu27

ABL_20 - EU25

ABL_21 - EU15

ABL_22 - EU12

ABL_23 - EU10

ABL_24 - EFTA4

ABL_25 - NUTS_EU

ABL_26 - TAA

ABL_27 - NUTSYear