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 1898 to 1917 of 3677
| Row | CODE | SOURCE_CODE | DESCRIPTION | TRANSLATION | STATUS | USER_ENTERED | DATE_ENTERED | USER_UPDATED | DATE_UPDATED | TRANSFER | RCS_STATUS |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1898 | MGYPS | 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 | 30-JUL-02 | TMCM | 27-MAY-20 | - | |
| 1899 | MGYPSD | 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 | 30-JUL-02 | TMCM | 27-MAY-20 | - | |
| 1900 | MGYPST | RN | Metagypsum-packstone | Metagypsum-packstone | C | AWEL | 30-JUL-02 | TMCM | 31-AUG-18 | N | |
| 1901 | MGYSD | 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 | 30-JUL-02 | TMCM | 27-MAY-20 | - | |
| 1902 | MGYST | RN | Gypsum-metastone | Gypsum-metastone | C | AWEL | 30-JUL-02 | TMCM | 31-AUG-18 | N | |
| 1903 | MGYWST | RN | Metagypsum-wackestone | Metagypsum-wackestone | C | AWEL | 30-JUL-02 | TMCM | 31-AUG-18 | N | |
| 1904 | MH | RN | Mud, shelly [Unlithified Deposits Coding Scheme - Extended] | Shelly mud [UDCS-X] | C | TMCM | 02-OCT-20 | I | U | ||
| 1905 | MHALI | 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 | - | |
| 1906 | MHALST | RN | Metahalite-stone | Metahalite-stone | C | AWEL | 31-JUL-02 | TMCM | 31-AUG-18 | N | |
| 1907 | MHAW | RN | Metahawaiite | Metahawaiite | C | AWEL | 23-JAN-02 | TMCM | 30-AUG-18 | N | |
| 1908 | MHAWFP | RN | Metahawaiite, feldspar-phyric | Feldspar-phyric metahawaiite | C | AWEL | 05-MAY-04 | TMCM | 31-AUG-18 | N | |
| 1909 | MHBGB | RN | Metahornblende-gabbro | Metahornblende-gabbro | C | AWEL | 24-JAN-02 | TMCM | 30-AUG-18 | N | |
| 1910 | MHBT | RN | Metahornblendite | Metahornblendite | C | AWEL | 18-JUL-02 | TMCM | 30-AUG-18 | N | |
| 1911 | MHLM | RC | Mudstone and laminated hemipelagic mudstone, interbedded | Mudstone and laminated hemipelagic mudstone, interbedded | C | DJLO | 02-JUN-06 | TMCM | 24-AUG-18 | I | ? |
| 1912 | MHWOP | RN | Metahawaiite, olivine-phyric | Olivine-phyric metahawaiite | C | AWEL | 23-JAN-02 | TMCM | 31-AUG-18 | U | |
| 1913 | MHY | RN | Metahyaloclastite | Metahyaloclastite | C | GRBA | 24-FEB-00 | TMCM | 30-AUG-18 | N | |
| 1914 | MHYBSD | 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 | - | |
| 1915 | MHYBSR | RN | Hybrid metasedimentary rocks | Hybrid metasedimentary rocks | C | AWEL | 31-JUL-02 | TMCM | 31-AUG-18 | N | |
| 1916 | MHYIA | RN | Metahydroxides and oxides of alumina and iron | Metahydroxides and oxides of alumina and iron | C | AWEL | 31-JUL-02 | TMCM | 30-AUG-18 | N | |
| 1917 | MHYOA | RN | Metahydroxides and oxides of alumina | Metahydroxides and oxides of alumina | C | AWEL | 31-JUL-02 | TMCM | 30-AUG-18 | N |
Displaying rows 1898 to 1917 of 3677