DIC_PAL_FOSSIL_COMMENT
Dictionary table which defines comments on fossil occurrences that can be used in the Borehole Geology properties table BH_GEOLOGY_PROPERTY. It is used (along with other dictionaries) in the Oracle view DIC_PROPERTY_TYPE_V1 which assembles the list of property types and values offered to the user by the GeoEntry borehole log coding application.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(15) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(50) |
|
| 3 |
STATUS |
Char(1) |
|
| 4 |
TRANSLATION |
Varchar(50) |
|
| 5 |
ORDER_CTRL |
Numeric(22) |
|
| 6 |
DATE_ENTERED |
Date |
|
| 7 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 20 of 27)
| CODE |
DESCRIPTION |
STATUS |
TRANSLATION |
ORDER_CTRL |
DATE_ENTERED |
DATE_UPDATED |
| STRINGER |
FOSSIL STRINGER |
C |
Fossil Stringer |
5 |
04-JUN-03 |
|
| PAVEMENT |
FOSSIL PAVEMENT |
C |
Fossil Pavement |
10 |
04-JUN-03 |
|
| LENS |
FOSSIL LENS |
C |
Fossil Lens |
15 |
04-JUN-03 |
|
| POD |
FOSSIL POD |
C |
Fossil Pod |
20 |
04-JUN-03 |
|
| WEDGE |
FOSSIL WEDGE |
C |
Fossil Wedge |
25 |
04-JUN-03 |
|
| CLUMP |
FOSSIL CLUMP |
C |
Fossil Clump |
30 |
04-JUN-03 |
|
| BED |
FOSSIL BED |
C |
Fossil Bed |
35 |
04-JUN-03 |
|
| FILL |
FOSSIL FISSURE FILL |
C |
Fossil Fissure Fill |
40 |
04-JUN-03 |
|
| CONCORDANT |
FOSSILS CONCORDANT WITH BEDDING |
C |
Fossils Concordant with Bedding |
45 |
04-JUN-03 |
|
| OBLIQUE |
FOSSILS OBLIQUE TO BEDDING (IMBRICATION) |
C |
Fossils Oblique to Bedding (Imbrication) |
50 |
04-JUN-03 |
|
| PERPENDICULAR |
FOSSILS PERPENDICULAR TO BEDDING |
C |
Fossils Perpendicular to Bedding |
55 |
04-JUN-03 |
|
| STACKED |
FOSSILS STACKED |
C |
Fossils Stacked |
60 |
04-JUN-03 |
|
| TELESCOPED |
FOSSILS TELESCOPED (ESPECIALLY BELEMNITES) |
C |
Fossils Telescoped (especially belemnites) |
65 |
04-JUN-03 |
|
| NEST |
FOSSILS NESTED (ESPECIALLY BIVALVES, BRACHIOPODS) |
C |
Fossils Nested (especially bivalves, brachiopods) |
70 |
04-JUN-03 |
|
| LIFEPOS |
FOSSILS IN LIFE POSITION |
C |
Fossils in Life Position |
75 |
04-JUN-03 |
|
| ARTICULATED |
FOSSILS ARTICULATED |
C |
Fossils Articulated |
80 |
04-JUN-03 |
|
| DISARTICULATED |
FOSSILS DISARTICULATED |
C |
Fossils Disarticulated |
85 |
04-JUN-03 |
|
| BROKEN |
FOSSILS BROKEN |
C |
Fossils Broken |
90 |
04-JUN-03 |
|
| UNIORIENT |
UNIMODAL PREFERRED ORIENTATION |
C |
Unimodal Preferred Orientation |
95 |
04-JUN-03 |
|
| BIORIENT |
BIMODAL PREFERRED ORIENTATION |
C |
Bimodal Preferred Orientation |
100 |
04-JUN-03 |
|
