DIC_BMD_MATERIAL_TYPE_DIC
Dictionary of corebox material types.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(6) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(250) |
|
| 3 |
STATUS |
Char(1) |
|
| 4 |
TRANSLATION |
Varchar(50) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 10 of 22)
| CODE |
DESCRIPTION |
STATUS |
TRANSLATION |
DATE_ENTERED |
DATE_UPDATED |
| BULK |
BULK SAMPLE |
U |
1 |
10-FEB-02 |
14-APR-05 |
| CRSM |
CORE SAMPLE |
U |
8 |
10-FEB-02 |
15-APR-05 |
| CUTT |
CUTTINGS |
U |
3 |
10-FEB-02 |
14-APR-05 |
| DLCR |
DRILLCORE |
U |
15 |
10-FEB-02 |
15-APR-05 |
| PWDR |
POWDER |
U |
11 |
10-FEB-02 |
14-APR-05 |
| RGSP |
REGISTERED SPECIMEN |
U |
12 |
10-FEB-02 |
14-APR-05 |
| RMDC |
RESIN MOUNTED DRILLCORE |
U |
13 |
10-FEB-02 |
14-APR-05 |
| SWCR |
SIDEWALL CORE |
U |
5 |
10-FEB-02 |
15-APR-05 |
| TBSM |
TUBE SAMPLE |
U |
16 |
10-FEB-02 |
14-APR-05 |
| UWCT |
UNWASHED CUTTINGS |
U |
19 |
10-FEB-02 |
14-APR-05 |