Vocabularies — details

DIC_PAL_FOSSIL_COMMENT

This table 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 10 of 27)

CODE DESCRIPTION STATUS TRANSLATION ORDER_CTRL DATE_ENTERED DATE_UPDATED
STRINGER  FOSSIL STRINGER  Fossil Stringer  04-JUN-03   
PAVEMENT  FOSSIL PAVEMENT  Fossil Pavement  10  04-JUN-03   
LENS  FOSSIL LENS  Fossil Lens  15  04-JUN-03   
POD  FOSSIL POD  Fossil Pod  20  04-JUN-03   
WEDGE  FOSSIL WEDGE  Fossil Wedge  25  04-JUN-03   
CLUMP  FOSSIL CLUMP  Fossil Clump  30  04-JUN-03   
BED  FOSSIL BED  Fossil Bed  35  04-JUN-03   
FILL  FOSSIL FISSURE FILL  Fossil Fissure Fill  40  04-JUN-03   
CONCORDANT  FOSSILS CONCORDANT WITH BEDDING  Fossils Concordant with Bedding  45  04-JUN-03   
OBLIQUE  FOSSILS OBLIQUE TO BEDDING (IMBRICATION)  Fossils Oblique to Bedding (Imbrication)  50  04-JUN-03