DIC_EPR
Dictionary of Economic Planning Regions (EPRs) for the Britpits database.
| No. |
Column name |
Data type |
Notes |
| 1 |
EPR_CODE |
Varchar(3) |
Primary key
|
| 2 |
EPR_NAME |
Varchar(100) |
|
| 3 |
STATUS |
Varchar(1) |
|
| 4 |
DATE_ENTERED |
Date |
|
| 5 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 14 of 14)
| EPR_CODE |
EPR_NAME |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| EMD |
East Midlands |
|
|
|
| EEN |
East of England |
|
|
13-DEC-07 |
| NEA |
North East |
|
|
|
| NWE |
North West |
|
|
|
| NIR |
Northern Ireland |
|
|
|
| SCT |
Scotland |
|
|
|
| SEA |
South East |
|
|
|
| SWE |
South West |
|
|
|
| WLS |
Wales |
|
|
|
| WMD |
West Midlands |
|
|
|
| YHU |
Yorkshire & the Humber |
|
|
|
| CHA |
Channel Islands |
|
|
18-JAN-08 |
| IOM |
Isle of Man |
|
|
|
| LON |
Greater London |
|
29-JAN-01 |
|