DIC_RCS_AMOUNT
Dictionary table which holds codes for the amount of single lithologies that make up a composite lithology. Part of version 3 of the BGS Rock Classification Scheme.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(6) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(500) |
|
| 3 |
TRANSLATION |
Varchar(80) |
|
| 4 |
STATUS |
Char(1) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 3 of 3)
| CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| M |
Main |
Main |
C |
06-JAN-04 |
25-JAN-08 |
| S |
Subsidiary |
Subsidiary |
C |
06-JAN-04 |
25-JAN-08 |
| T |
Trace |
Trace |
C |
06-JAN-04 |
25-JAN-08 |
