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 1978 to 1997 of 3677
| Row | CODE | SOURCE_CODE | DESCRIPTION | TRANSLATION | STATUS | USER_ENTERED | DATE_ENTERED | USER_UPDATED | DATE_UPDATED | TRANSFER | RCS_STATUS |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1978 | MLMON | RN | Meta-oncoid-limestone - Synonym: metalime-oncolite. | Meta-oncoid-limestone | C | AWEL | 31-JUL-02 | TMCM | 22-FEB-19 | N | |
| 1979 | MLMPBI | RN | Metalamprophyre, biotite | Biotite metalamprophyre | C | AWEL | 23-JAN-02 | TMCM | 31-AUG-18 | U | |
| 1980 | MLMPEL | RN | Metapeloid-limestone | Metapeloid-limestone | C | AWEL | 31-JUL-02 | TMCM | 30-AUG-18 | N | |
| 1981 | MLMPFB | RN | Metalamprophyre, foliated-biotite | Foliated-biotite metalamprophyre | C | AWEL | 23-JAN-02 | TMCM | 31-AUG-18 | U | |
| 1982 | MLMPHB | RN | Metalamprophyre, hornblende | Hornblende metalamprophyre | C | AWEL | 23-JAN-02 | TMCM | 31-AUG-18 | U | |
| 1983 | MLMPIS | RN | Metapisoid-limestone | Metapisoid-limestone | C | AWEL | 31-JUL-02 | TMCM | 30-AUG-18 | N | |
| 1984 | MLMPR | RN | Metalamproite | Metalamproite | C | GRBA | 08-MAY-00 | TMCM | 30-AUG-18 | N | |
| 1985 | MLMPST | RN | Metalime-packstone | Metalime-packstone | C | AWEL | 31-JUL-02 | TMCM | 30-AUG-18 | N | |
| 1986 | MLMPY | RN | Metalamprophyre | Metalamprophyre | C | GRBA | 24-FEB-00 | TMCM | 30-AUG-18 | N | |
| 1987 | MLMPYF | RN | Metalamprophyre, foliated | Foliated metalamprophyre | C | AWEL | 23-JAN-02 | TMCM | 31-AUG-18 | U | |
| 1988 | MLMSD | 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 | - | |
| 1989 | MLMSND | 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 | - | |
| 1990 | MLMSPT | RN | Metalime-sparstone | Metalime-sparstone | C | AWEL | 31-JUL-02 | TMCM | 30-AUG-18 | N | |
| 1991 | MLMST | RN | Metalimestone | Metalimestone | C | GRBA | 24-FEB-00 | TMCM | 30-AUG-18 | N | |
| 1992 | MLMSTN | RN | Metalimestone, nodular (cornstone) | Nodular metalimestone (cornstone) | C | AWEL | 31-JUL-02 | TMCM | 31-AUG-18 | U | |
| 1993 | MLMWST | RN | Metalime-wackestone | Metalime-wackestone | C | AWEL | 31-JUL-02 | TMCM | 30-AUG-18 | N | |
| 1994 | MLPASH | 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 | GRBA | 24-FEB-00 | TMCM | 27-MAY-20 | - | |
| 1995 | MLPD | RC | Melatroctolite, peridotite and dunite | Melatroctolite, peridotite and dunite | C | DJLO | 05-JUN-06 | TMCM | 24-AUG-18 | I | ? |
| 1996 | MLPE | RC | Metalimestone and pelite | Metalimestone and pelite | C | DJLO | 05-JUN-06 | TMCM | 24-AUG-18 | I | ? |
| 1997 | MLPSPS | RN | Metalime-pseudosparstone | Metalime-pseudosparstone | C | AWEL | 20-AUG-02 | TMCM | 30-AUG-18 | N |
Displaying rows 1978 to 1997 of 3677