SAMPLEMATERIALID |
Identifer of the sample material |
ORIGINALSAMPLEID |
Identifier of the original or primary sample |
PARTIDENTIFICATION |
The original sample or sample no can consist of several smaller samples. PartIdentification identifies each of these samples and is typically a letter |
PARTNO |
Same as partidentification but an interger is used instead. Is typically set by the application |
SAMPLETYPE |
Code for the form in which the sample material is available |
AMOUNT |
Amount of material that is available |
UNIT |
Code for unit for amount of material |
MATERIALCOMMENT |
Comments |
PRESENTSTATUS |
Code for status of the sample material |
CREATE_USER_ID |
Id for the user who created this record. |
CREATE_DATE |
Date and time this record was created. |
UPDATE_USER_ID |
Id for the user who last updated this record. |
UPDATE_DATE |
Date and time this record was last updated. |
ROCKEVAL_TYPE |
data data in this field come from the column analysis_type in the table ana$core with pyrolysis data in the old Samba database. Three values exist: extended ! - nobody knows what it means (June 2011); extracted - the material it treated with a solvent to remove oil that is added to the drilling mud, raw - untreated samples. the S1 peak can be used. |
STORAGE_NO |
usualy the pkv no (pkv is the abbreviation for the former prækvartære afdeling) |
OWNER |
owner |
CATEGORY |
sample types. Free text not controlled by code list |