Vocabularies — details

DIC_BGS_SITE

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 10 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 
LH  LOANHEAD  25-MAR-94  24-MAY-05  Loanhead  Loanhead 
MH  MURCHISON HOUSE  25-MAR-94  24-MAY-05  Murchison House  Murchison House 
WD  WALLINGFORD  25-MAR-94  07-OCT-05  Wallingford  Wallingford 
LO  EXHIBITION ROAD, LONDON  25-MAR-94  07-OCT-05  London  London 
EX  EXETER  25-MAR-94  07-OCT-05  Exeter  Exeter 
BE  BELFAST  25-MAR-94  07-OCT-05  Belfast  Belfast 
AB  ABERYSTWYTH  18-DEC-00  24-MAY-05  Aberystwyth  Aberystwyth 
GI  GILMERTON  18-DEC-00  07-OCT-05  Gilmerton  Gilmerton 
HA  HARTLAND  18-DEC-00  24-MAY-05  Hartland  Hartland