Vocabularies — details

DIC_ROCK_COMPOSITE

Dictionary table that holds the code (e.g. IBSDSS) and description (e.g. interbedded sandstones and siltstones with mudstone lenses in the sandstone) of the composite. Part of version 3 of the BGS Rock Classification Scheme.

No. Column name Data type Notes
1 COMPOSITE_CODE Varchar(6) Primary key
2 DESCRIPTION Varchar(500)  
3 TRANSLATION Varchar(500)  
4 STATUS Char(1)  
5 USER_ENTERED Varchar(10)  
6 DATE_ENTERED Date  
7 USER_UPDATED Varchar(10)  
8 DATE_UPDATED Date  
9 TRANSFER Char(1)  


Sample data (rows 1 to 20 of 646)

COMPOSITE_CODE DESCRIPTION TRANSLATION STATUS USER_ENTERED DATE_ENTERED USER_UPDATED DATE_UPDATED TRANSFER
ABAN  Andesite and basaltic andesite  Andesite and basaltic andesite  C  DJLO  03-FEB-04  TMCM  24-AUG-18   
ABFP  Feldspar-phyric andesite and feldspar-phyric basalt  Feldspar-phyric andesite and feldspar-phyric basalt  C  TMCM  11-JAN-12  TMCM  24-AUG-18  I 
ADOS  Argillaceous rock, dolostone and sandstone  Argillaceous rock, dolostone and sandstone  C  DJLO  03-FEB-04  TMCM  24-AUG-18   
AFUF  Foliated appinitic felsic rocks and foliated appinitic ultramafic rocks  Foliated appinitic felsic rocks and foliated appinitic ultramafic rocks  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I 
AGPI  Analcime-gabbro and picrite  Analcime-gabbro and picrite  C  DJLO  08-JUN-06  TMCM  24-AUG-18  I 
AGTB  Trachytic agglomerate and basaltic agglomerate  Trachytic agglomerate and basaltic agglomerate  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I 
AGTT  Agglomerate and tuffite  Agglomerate and tuffite  C  DJLO  03-FEB-04  TMCM  24-AUG-18   
AHMG  Amphibolite, hornblende-schist and metagabbro  Amphibolite, hornblende-schist and metagabbro  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I 
AHPS  Amphibolite, hornblende schist, pelite and semipelite  Amphibolite, hornblende schist, pelite and semipelite  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I 
ALCH  Argillaceous limestone with chert  Argillaceous limestone with chert  C  TMCM  17-AUG-09  TMCM  24-AUG-18  I 
ALRL  Andesite lava and rhyolite lava  Andesite lava and rhyolite lava  C  TMCM  18-JUN-12  TMCM  24-AUG-18  I 
AMHO  Amphibolite and hornblendite  Amphibolite and hornblendite  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I 
AMHS  Amphibolite and hornblende schist  Amphibolite and hornblende schist  C  DJLO  29-NOV-04  TMCM  24-AUG-18  I 
AMMO  Amphibolite and mafic orthogneiss  Amphibolite and mafic orthogneiss  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I 
AMPG  Amphibolite and pyroxene granofels  Amphibolite and pyroxene granofels  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I 
AMTA  Andesitic tuff, mafic tuff and agglomerate  Andesitic tuff, mafic tuff and agglomerate  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I 
ANBAI  Andesite and basaltic andesite [composite lava/intrusion]  Andesite and basaltic andesite [composite lava/intrusion]  C  TMCM  22-MAR-13  TMCM  24-AUG-18  I 
ANBF  Basaltic andesite and felsite  Basaltic andesite and felsite  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I 
ANBR  Basaltic andesite and rhyolite  Basaltic andesite and rhyolite  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I 
ANDB  Andesite and basalt  Andesite and basalt  C  DJLO  15-MAY-06  TMCM  24-AUG-18  I