Vocabularies — view dictionary terms


DIC_ROCK_ALL (3677 rows)
Dictionary table based on the entire version 3 of the BGS Rock Classification Scheme and is populated directly from the 3 supplying tables (BGS.ROCK_NAME_V3, BGS.ROCK_COMPOSITE and BGS.DIC_ROCK_DUMMY). It contains both the base rock names and addditional codes required for specific application, eg. composite names for use on digital geological maps. It is formally approved as the official source of ALL database codes to be used in BGS corporate databases and MUST be followed.


Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 1638 to 1657 of 3677 Displaying rows 1658 to 1677 of 3677 Go to the next page - rows 1678 to 1697 of 3677 Go to the end - rows 3658 to 3677 of 3677

Row CODE SOURCE_CODE DESCRIPTION TRANSLATION STATUS USER_ENTERED DATE_ENTERED USER_UPDATED DATE_UPDATED TRANSFER RCS_STATUS
1658 MDLGV  RN  This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future.  Dictionary entry deleted  AWEL  31-JUL-02  TMCM  27-MAY-20   
1659 MDLI  RC  Mudstone and (subequal/subordinate) lignite  Mudstone and (subequal/subordinate) lignite  DJLO  14-JAN-08  TMCM  24-AUG-18 
1660 MDLM  RC  Mudstone and limestone, interbedded  Mudstone and limestone, interbedded  DJLO  25-MAY-06  TMCM  24-AUG-18 
1661 MDLMCS  RN  Metadolomite-microstone  Metadolomite-microstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1662 MDLMON  RN  Metamicrooncoid-dolostone  Metamicrooncoid-dolostone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1663 MDLMSP  RN  Metadolomite-microsparstone  Metadolomite-microsparstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1664 MDLMST  RN  Metalimestone, dolomitic  Dolomitic metalimestone  AWEL  11-JUN-02  TMCM  31-AUG-18   
1665 MDLMUD  RN  This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future.  Dictionary entry deleted  AWEL  31-JUL-02  TMCM  27-MAY-20   
1666 MDLN  RC  Mudstone with limestone nodules  Mudstone with limestone nodules  DJLO  25-MAY-06  TMCM  24-AUG-18 
1667 MDLONC  RN  Metaoncoid-dolostone  Metaoncoid-dolostone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1668 MDLOOL  RN  Metaooid-dolostone  Metaooid-dolostone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1669 MDLPEL  RN  Metapeloid-dolostone  Metapeloid-dolostone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1670 MDLPIS  RN  Metapisoid-dolostone  Metapisoid-dolostone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1671 MDLPSP  RN  Metadolomite-pseudosparstone  Metadolomite-pseudosparstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1672 MDLPST  RN  Metadolomite-packstone  Metadolomite-packstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1673 MDLRHB  RN  Metadolerite, hypersthene-bearing  Hypersthene-bearing metadolerite  AWEL  16-FEB-01  TMCM  31-AUG-18   
1674 MDLSD  RN  This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future.  Dictionary entry deleted  AWEL  31-JUL-02  TMCM  27-MAY-20   
1675 MDLSPT  RN  Metadolomite-sparstone  Metadolomite-sparstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1676 MDLSSP  RC  Dolomitic metalimestone and semipelite  Dolomitic metalimestone and semipelite   DJLO  05-DEC-06  TMCM  24-AUG-18 
1677 MDLWST  RN  Metadolomite-wackestone  Metadolomite-wackestone  AWEL  31-JUL-02  TMCM  30-AUG-18   

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 1638 to 1657 of 3677 Displaying rows 1658 to 1677 of 3677 Go to the next page - rows 1678 to 1697 of 3677 Go to the end - rows 3658 to 3677 of 3677