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 1618 to 1637 of 3677 Displaying rows 1638 to 1657 of 3677 Go to the next page - rows 1658 to 1677 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
1638 MDIAOZ  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   
1639 MDIATM  RN  Metadiatomite  Metadiatomite  AWEL  31-JUL-02  TMCM  31-AUG-18   
1640 MDIAUG  RN  Metadiorite, augite  Augite metadiorite  AWEL  22-JAN-02  TMCM  31-AUG-18   
1641 MDIFO  RN  Metadiorite, foliated  Foliated metadiorite  AWEL  14-MAY-02  TMCM  31-AUG-18   
1642 MDIGN  RN  Metadiorite, gneissose  Gneissose metadiorite  GRBA  24-FEB-00  TMCM  31-AUG-18   
1643 MDIHB  RN  Metadiorite, hornblende  Hornblende metadiorite  AWEL  22-JAN-02  TMCM  31-AUG-18   
1644 MDIML  RN  Metameladiorite  Metameladiorite  AWEL  22-JAN-02  TMCM  31-AUG-18   
1645 MDIMLH  RN  Metameladiorite, hornblende  Hornblende metameladiorite  AWEL  22-JAN-02  TMCM  31-AUG-18   
1646 MDIOL  RN  Metadiorite, olivine  Olivine metadiorite  AWEL  22-JAN-02  TMCM  31-AUG-18   
1647 MDIPX  RN  Metadiorite, pyroxene  Pyroxene metadiorite  AWEL  22-JAN-02  TMCM  31-AUG-18   
1648 MDIPXB  RN  Metadiorite, pyroxene-biotite  Pyroxene-biotite metadiorite  AWEL  07-OCT-03  TMCM  31-AUG-18   
1649 MDIPXM  RN  Metadiorite, pyroxene-mica  Pyroxene-mica metadiorite  AWEL  22-JAN-02  TMCM  31-AUG-18   
1650 MDIR  RN  Metadioritic-rock  Metadioritic-rock  GRBA  24-FEB-00  TMCM  30-AUG-18   
1651 MDIRG  RN  Metadioritic-rock, gneissose  Gneissose metadioritic-rock  AWEL  22-MAR-01  TMCM  31-AUG-18   
1652 MDISH  RN  Metadiorite, sheared  Sheared metadiorite  AWEL  14-FEB-01  TMCM  31-AUG-18   
1653 MDIT  RC  Metadiorite and metatonalite  Metadiorite and metatonalite  DJLO  25-MAY-06  TMCM  24-AUG-18 
1654 MDLBST  RN  Metadolomite-boundstone  Metadolomite-boundstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1655 MDLCBT  RN  Metadolomite-carbonatite  Metadolomite-carbonatite  AWEL  31-JUL-02  TMCM  30-AUG-18   
1656 MDLFST  RN  Metadolomite-framestone  Metadolomite-framestone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1657 MDLGST  RN  Metadolomite-grainstone  Metadolomite-grainstone  AWEL  31-JUL-02  TMCM  30-AUG-18   

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