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 |
|