DIC_BGS_SITE
Dictionary table listing Names and Codes of all BGS sites (and Swindon). Used by staff movements diary
| No. |
Column name |
Data type |
Notes |
| 1 |
BGS_SITE_CODE |
Varchar(6) |
Primary key
|
| 2 |
BGS_SITE_NAME |
Varchar(68) |
|
| 3 |
DATE_ENTERED |
Date |
|
| 4 |
DATE_UPDATED |
Date |
|
| 5 |
DESCRIPTION |
Varchar(80) |
|
| 6 |
TRANSLATION |
Varchar(50) |
|
| 7 |
STATUS |
Char(1) |
|
Sample data (rows 1 to 20 of 23)
| BGS_SITE_CODE |
BGS_SITE_NAME |
DATE_ENTERED |
DATE_UPDATED |
DESCRIPTION |
TRANSLATION |
STATUS |
| KW |
KEYWORTH |
25-MAR-94 |
24-MAY-05 |
Keyworth |
Keyworth |
C |
| LH |
LOANHEAD |
25-MAR-94 |
24-MAY-05 |
Loanhead |
Loanhead |
C |
| MH |
MURCHISON HOUSE |
25-MAR-94 |
24-MAY-05 |
Murchison House |
Murchison House |
C |
| WD |
WALLINGFORD |
25-MAR-94 |
07-OCT-05 |
Wallingford |
Wallingford |
C |
| LO |
EXHIBITION ROAD, LONDON |
25-MAR-94 |
07-OCT-05 |
London |
London |
C |
| EX |
EXETER |
25-MAR-94 |
07-OCT-05 |
Exeter |
Exeter |
C |
| BE |
BELFAST |
25-MAR-94 |
07-OCT-05 |
Belfast |
Belfast |
C |
| AB |
ABERYSTWYTH |
18-DEC-00 |
24-MAY-05 |
Aberystwyth |
Aberystwyth |
O |
| GI |
GILMERTON |
18-DEC-00 |
07-OCT-05 |
Gilmerton |
Gilmerton |
C |
| HA |
HARTLAND |
18-DEC-00 |
24-MAY-05 |
Hartland |
Hartland |
C |
| ES |
ESKDALEMUIR |
18-DEC-00 |
24-MAY-05 |
Eskdalemuir |
Eskdalemuir |
C |
| OS |
OVERSEAS |
21-DEC-00 |
24-MAY-05 |
Overseas |
Overseas |
C |
| CA |
CARDIFF |
04-FEB-03 |
24-MAY-05 |
Cardiff |
Cardiff |
C |
| SW |
SWINDON |
04-FEB-03 |
24-MAY-05 |
Swindon |
Swindon |
C |
| WL |
WALLINGFORD |
11-OCT-05 |
|
Wallingford |
Wallingford |
O |
| GL |
GILMERTON |
11-OCT-05 |
|
Gilmerton |
Gilmerton |
O |
| XT |
EXETER |
11-OCT-05 |
|
Exeter |
Exeter |
O |
| ER |
EXHIBITION ROAD, LONDON |
11-OCT-05 |
12-JUN-07 |
London |
London |
O |
| BL |
BELFAST |
11-OCT-05 |
|
Belfast |
Belfast |
O |
| ! |
Not Available |
23-AUG-06 |
|
Not Available - Applicable but try as we might,we can't find a value. |
Not Available |
C |
