Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

ANALYSISTABLENAMEABOUT TEXT
BHASAMPLEExpExp: expedition number
BHASAMPLESiteSite: site number
BHASAMPLEHoleHole: hole number
BHASAMPLEtext_idText_ID: automatically generated database identifier for a sample, also carried on the printed labels. This identifier is guaranteed to be unique across all samples.
BHASAMPLEsample_numberSample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
BHASAMPLElabel_idLabel identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
BHASAMPLEsample_nameSample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
BHASAMPLEx_sample_stateSample state: Single-character identifier always set to "W" for samples; standards can vary.
BHASAMPLEx_projectProject: similar in scope to the expedition number, the difference being that the project is the current cruise, whereas expedition could refer to material/results obtained on previous cruises
BHASAMPLEx_capt_locCaptured location: "captured location," this field is usually null and is unnecessary because any sample captured on the JR has a sample_number ending in 1, and GCR ending in 2
BHASAMPLElocationLocation: location that sample was taken; this field is usually null and is unnecessary because any sample captured on the JR has a sample_number ending in 1, and GCR ending in 2
BHASAMPLEx_sampling_toolSampling tool: sampling tool used to take the sample (e.g., syringe, spatula)
BHASAMPLEchanged_byChanged by: username of account used to make a change to a sample record
BHASAMPLEchanged_onChanged on: date/time stamp for change made to a sample record
BHASAMPLEsample_typeSample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
BHASAMPLEx_offsetOffset (m): top offset of sample from top of parent sample, expressed in meters.
BHASAMPLEx_offset_cmOffset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm)
BHASAMPLEx_bottom_offset_cmBottom offset (cm): bottom offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset + length, converted to cm)
BHASAMPLEx_diameterDiameter (cm): diameter of sample, usually applied only to CORE, SECT, SHLF, and WRND samples; however this field is null on both Exp. 390 and 393, so it is no longer populated by Sample Master
BHASAMPLEdescriptionSAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments"
BHASAMPLEx_orig_lenOriginal length (m): field for the original length of a sample; not always (or reliably) populated
BHASAMPLEx_lengthLength (m): field for the length of a sample [as entered upon creation]
BHASAMPLEx_length_cmLength (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
BHASAMPLEstatusStatus: single-character code for the current status of a sample (e.g., active, canceled)
BHASAMPLEold_statusOld status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
BHASAMPLEoriginal_sampleOriginal sample: field tying a sample below the CORE level to its parent HOLE sample
BHASAMPLEparent_sampleParent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
BHASAMPLEstandardStandard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
BHASAMPLElogin_byLogin by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
BHASAMPLElogin_dateLogin date: creation date of the sample
BHASAMPLElegacyLegacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
BHATESTtest changed_onTEST changed on: date/time stamp for a change to a test record.
BHATESTtest statusTEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
BHATESTtest old_statusTEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
BHATESTtest test_numberTEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
BHATESTtest date_receivedTEST date received: date/time stamp for the creation of the test record.
BHATESTtest instrumentTEST instrument [instrument group]: field that describes the instrument group (most often this applies to loggers with multiple sensors); often obscure (e.g., user_input)
BHATESTtest analysisTEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
BHATESTtest x_projectTEST project: similar in scope to the expedition number, the difference being that the project is the current cruise, whereas expedition could refer to material/results obtained on previous cruises
BHATESTtest sample_numberTEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
BHARESULTlengthRESULT length (m): length of the bottom hole assembly
  • No labels