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 10 of 18)

CODE DESCRIPTION TRANSLATION STATUS APPN_CODE DATE_ENTERED DATE_UPDATED
DGSM  DGSM Model or Dataset  DGSM Model or Dataset  C  DGSM  23-FEB-04  29-NOV-05 
BGS-GeoIDS  BGS Data Holding  BGS Data Holding  C  GEOIDS  23-FEB-04  29-NOV-05 
External  External Data Holding  External Data Holding  C    23-FEB-04   
Gazetteer  Place Name Gazetteer  Place Name Gazetteer  C    23-FEB-04   
Thesaurus  Subject Keyword Thesaurus  Subject Keyword Thesaurus  C    23-FEB-04   
OML  Ocean Margin Link Dataset  Ocean Margin Link Dataset  C  OML  09-AUG-04  29-NOV-05 
Map_NewSeries  Map New Series, New Meridian County (Sco  Map New Series, New Meridian County (Sco  C  MAPS  13-SEP-04  29-NOV-05 
Map_OldCtyBnd  Map Old County boundaries  Map Old County boundaries  C  MAPS  13-SEP-04  29-NOV-05 
Map_NewCtyBnd  Map New County boundaries  Map New County boundaries  C  MAPS  13-SEP-04  29-NOV-05 
Map_Cty  Map County  Map County  C  MAPS  13-SEP-04  29-NOV-05