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 2138 to 2157 of 3677 Displaying rows 2158 to 2177 of 3677 Go to the next page - rows 2178 to 2197 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
2158 MPHGBN  RN  Metapyroxene-hornblende-gabbronorite  Metapyroxene-hornblende-gabbronorite  C  AWEL  25-JAN-02  TMCM  30-AUG-18    N 
2159 MPHGST  RN  Metaphosphate-grainstone  Metaphosphate-grainstone  C  AWEL  31-JUL-02  TMCM  31-AUG-18    N 
2160 MPHGV  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    - 
2161 MPHMON  RN  Metamicrooncoid-phosphorite  Metamicrooncoid-phosphorite  C  AWEL  31-JUL-02  TMCM  31-AUG-18    N 
2162 MPHMST  RN  Metaphosphate-mudstone  Metaphosphate-mudstone  C  AWEL  31-JUL-02  TMCM  31-AUG-18    N 
2163 MPHMUD  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    - 
2164 MPHNMD  RN  Metamudstone, phosphate-nodular  Phosphate-nodular metamudstone  C  AWEL  31-JUL-02  TMCM  31-AUG-18    U 
2165 MPHNOD  RN  Metaphosphorite, nodular  Nodular metaphosphorite  C  AWEL  31-JUL-02  TMCM  31-AUG-18    U 
2166 MPHONC  RN  Metaoncoid-phosphorite  Metaoncoid-phosphorite  C  AWEL  31-JUL-02  TMCM  31-AUG-18    N 
2167 MPHOOL  RN  Metaooid-phosphorite  Metaooid-phosphorite  C  AWEL  31-JUL-02  TMCM  31-AUG-18    N 
2168 MPHOST  RN  Metaphosphorite  Metaphosphorite  C  GRBA  24-FEB-00  TMCM  30-AUG-18    N 
2169 MPHPEL  RN  Metapeloid-phosphorite  Metapeloid-phosphorite  C  AWEL  31-JUL-02  TMCM  31-AUG-18    N 
2170 MPHPIS  RN  Metapisoid-phosphorite  Metapisoid-phosphorite  C  AWEL  31-JUL-02  TMCM  31-AUG-18    N 
2171 MPHPMD  RN  Metamudstone, phospha-pebbly  Phospha-pebbly metamudstone  C  AWEL  31-JUL-02  TMCM  31-AUG-18    U 
2172 MPHPST  RN  Metaphosphate-packstone  Metaphosphate-packstone  C  AWEL  31-JUL-02  TMCM  31-AUG-18    N 
2173 MPHSD  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    - 
2174 MPHSDT  RN  Metasandstone, phosphate-nodular  Phosphate-nodular metasandstone  C  AWEL  31-JUL-02  TMCM  31-AUG-18    U 
2175 MPHSLT  RN  Metasiltstone, phosphate-nodular  Phosphate-nodular metasiltstone  C  AWEL  31-JUL-02  TMCM  31-AUG-18    U 
2176 MPHSND  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    - 
2177 MPHWST  RN  Metaphosphate-wackestone  Metaphosphate-wackestone  C  AWEL  31-JUL-02  TMCM  31-AUG-18    N 

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 2138 to 2157 of 3677 Displaying rows 2158 to 2177 of 3677 Go to the next page - rows 2178 to 2197 of 3677 Go to the end - rows 3658 to 3677 of 3677