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.

view all data in this vocabulary
download this vocabulary (as MS Excel file)
back to the list of vocabularies

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