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.
Displaying rows 1678 to 1697 of 3677
| Row | CODE | SOURCE_CODE | DESCRIPTION | TRANSLATION | STATUS | USER_ENTERED | DATE_ENTERED | USER_UPDATED | DATE_UPDATED | TRANSFER | RCS_STATUS |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1678 | MDLY | RC | Microdiorite and lamprophyre | Microdiorite and lamprophyre | C | DJLO | 25-MAY-06 | TMCM | 24-AUG-18 | I | ? |
| 1679 | MDMDST | RN | Metadolomite-mudstone | Metadolomite-mudstone | C | AWEL | 31-JUL-02 | TMCM | 30-AUG-18 | N | |
| 1680 | MDMP | RC | Microdiorite and porphyritic microdiorite | Microdiorite and porphyritic microdiorite | C | DJLO | 25-MAY-06 | TMCM | 24-AUG-18 | I | ? |
| 1681 | MDMS | RC | Meladiorite, melamonzonite and melasyenite | Meladiorite, melamonzonite and melasyenite | C | DJLO | 25-MAY-06 | TMCM | 24-AUG-18 | I | ? |
| 1682 | MDMTN | RN | This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future. | Dictionary entry deleted | O | AWEL | 31-JUL-02 | TMCM | 27-MAY-20 | - | |
| 1683 | MDOLFO | RN | Metadolerite, foliated | Foliated metadolerite | C | GRBA | 24-FEB-00 | TMCM | 31-AUG-18 | U | |
| 1684 | MDOLFS | RN | Metadolerite, feldspar-phyric | Feldspar-phyric metadolerite | C | GRBA | 24-FEB-00 | TMCM | 31-AUG-18 | U | |
| 1685 | MDOLO | RN | Metadolostone | Metadolostone | C | GRBA | 24-FEB-00 | TMCM | 30-AUG-18 | N | |
| 1686 | MDOLR | RN | Metadolerite | Metadolerite | C | GRBA | 24-FEB-00 | TMCM | 31-AUG-18 | N | |
| 1687 | MDOMDL | RC | Metadolomite and/or dolomitic metalimestone | Metadolomite and/or dolomitic metalimestone | C | DJLO | 08-DEC-06 | TMCM | 24-AUG-18 | I | ? |
| 1688 | MDPF | RC | Foliated microdiorite and foliated porphyritic microdiorite | Foliated microdiorite and foliated porphyritic microdiorite | C | DJLO | 25-MAY-06 | TMCM | 24-AUG-18 | I | ? |
| 1689 | MDPHM | RC | Mudstone with phosphate-mudstone | Mudstone with phosphate-mudstone | C | DJLO | 25-JUL-08 | TMCM | 24-AUG-18 | I | ? |
| 1690 | MDROM | RN | Mudstone rich in organic matter | Mudstone rich in organic matter | C | AWEL | 09-MAR-00 | TMCM | 31-AUG-18 | N | |
| 1691 | MDSA | RC | Mudstone and sandstone, interbedded | Interbedded mudstone and sandstone | C | DJLO | 25-MAY-06 | TMCM | 24-AUG-18 | I | ? |
| 1692 | MDSC | RC | Mudstone, sandstone and conglomerate | Mudstone, sandstone and conglomerate | C | DJLO | 25-MAY-06 | TMCM | 24-AUG-18 | I | ? |
| 1693 | MDSD | RC | Mudstone and sandstone | Mudstone and sandstone | C | DJLO | 25-MAY-06 | TMCM | 24-AUG-18 | I | ? |
| 1694 | MDSDAN | RC | Mudstone and sandstone with anhydrite-stone | Mudstone and sandstone with anhydrite-stone | C | DJLO | 12-JUN-08 | TMCM | 24-AUG-18 | I | ? |
| 1695 | MDSDHA | RC | Mudstone and sandstone with halite-stone | Mudstone and sandstone with halite-stone | C | DJLO | 12-JUN-08 | TMCM | 24-AUG-18 | I | ? |
| 1696 | MDSDLI | RC | Mudstone, sandstone and lignite | Mudstone, sandstone and lignite | C | DJLO | 13-JUN-08 | TMCM | 24-AUG-18 | I | ? |
| 1697 | MDSHL | RN | Mud, shell [Obsolete code: use MH] | Shell mud | O | AWEL | 15-DEC-04 | TMCM | 02-OCT-20 | I | U |
Displaying rows 1678 to 1697 of 3677