# AdminBoundaryLookup

```{image} ../_static/table-icons/technical_table.png
:alt: AdminBoundaryLookup
:align: right
:width: 200px
```

```{contents}
:local:
:depth: 2
```

## 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