Vocabularies — details

DIC_ADD_COLLTITLE

A dictionary table of metadata collection titles. Provides values for ISO metadata element no. 371 collective title. This object is a copy of the dictionary in the DGSM schema and is now obsolete; the BGS table DIC_MET_COLLECTION should be used instead.

No. Column name Data type Notes
1 CODE Varchar(20) Primary key
2 DESCRIPTION Varchar(40)  
3 TRANSLATION Varchar(40)  
4 STATUS Char(1)  
5 APPN_CODE Varchar(6)  
6 DATE_ENTERED Date  
7 DATE_UPDATED Date  


Sample data (rows 1 to 18 of 18)

CODE DESCRIPTION TRANSLATION STATUS APPN_CODE DATE_ENTERED DATE_UPDATED
DGSM  DGSM Model or Dataset  DGSM Model or Dataset  DGSM  23-FEB-04  29-NOV-05 
BGS-GeoIDS  BGS Data Holding  BGS Data Holding  GEOIDS  23-FEB-04  29-NOV-05 
External  External Data Holding  External Data Holding    23-FEB-04   
Gazetteer  Place Name Gazetteer  Place Name Gazetteer    23-FEB-04   
Thesaurus  Subject Keyword Thesaurus  Subject Keyword Thesaurus    23-FEB-04   
OML  Ocean Margin Link Dataset  Ocean Margin Link Dataset  OML  09-AUG-04  29-NOV-05 
Map_NewSeries  Map New Series, New Meridian County (Sco  Map New Series, New Meridian County (Sco  MAPS  13-SEP-04  29-NOV-05 
Map_OldCtyBnd  Map Old County boundaries  Map Old County boundaries  MAPS  13-SEP-04  29-NOV-05 
Map_NewCtyBnd  Map New County boundaries  Map New County boundaries  MAPS  13-SEP-04  29-NOV-05 
Map_Cty  Map County  Map County  MAPS  13-SEP-04  29-NOV-05 
Map_NGR  Map National Grid  Map National Grid  MAPS  13-SEP-04  29-NOV-05 
FieldSlip_NewSeries  Field Slip New Series, New Meridian Coun  Field Slip New Series, New Meridian Coun  MAPS  13-SEP-04  29-NOV-05 
FieldSlip_OldCtyBnd  Field Slip Old County boundaries  Field Slip Old County boundaries  MAPS  13-SEP-04  29-NOV-05 
FieldSlip_NewCtyBnd  Field Slip New County boundaries  Field Slip New County boundaries  MAPS  13-SEP-04  29-NOV-05 
FieldSlip_Cty  Field Slip County  Field Slip County  MAPS  04-OCT-04  29-NOV-05 
FieldSlip_NGR  Field Slip National Grid  Field Slip National Grid  MAPS  04-OCT-04  29-NOV-05 
Map_Unknown  Map unknown series  Map unknown series  MAPS  04-OCT-04  29-NOV-05 
FieldSlip_Unknown  Field Slip unknown series  Field Slip unknown series  MAPS  04-OCT-04  29-NOV-05