Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This is a home for LIMS definitions for ANALYSIS codes that don't have another home. Included here are:

  • BHA
  • BIT
  • DRILLING
  • LATLONG
  • ORIGDEPTH

The tables show the LIMS table that the parameter comes from, its database name, and the "About" text that explains the meaning of the field.

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


ANALYSISTABLENAMEABOUT TEXT
BITSAMPLEExpExp: expedition number
BITSAMPLESiteSite: site number
BITSAMPLEHoleHole: hole number
BITSAMPLEtext_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.
BITSAMPLEsample_numberSample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
BITSAMPLElabel_idLabel identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
BITSAMPLEsample_nameSample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
BITSAMPLEx_sample_stateSample state: Single-character identifier always set to "W" for samples; standards can vary.
BITSAMPLEx_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
BITSAMPLEx_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
BITSAMPLElocationLocation: 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
BITSAMPLEx_sampling_toolSampling tool: sampling tool used to take the sample (e.g., syringe, spatula)
BITSAMPLEchanged_byChanged by: username of account used to make a change to a sample record
BITSAMPLEchanged_onChanged on: date/time stamp for change made to a sample record
BITSAMPLEsample_typeSample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
BITSAMPLEx_offsetOffset (m): top offset of sample from top of parent sample, expressed in meters.
BITSAMPLEx_offset_cmOffset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm)
BITSAMPLEx_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)
BITSAMPLEx_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
BITSAMPLEdescriptionSAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments"
BITSAMPLEx_orig_lenOriginal length (m): field for the original length of a sample; not always (or reliably) populated
BITSAMPLEx_lengthLength (m): field for the length of a sample [as entered upon creation]
BITSAMPLEx_length_cmLength (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
BITSAMPLEstatusStatus: single-character code for the current status of a sample (e.g., active, canceled)
BITSAMPLEold_statusOld status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
BITSAMPLEoriginal_sampleOriginal sample: field tying a sample below the CORE level to its parent HOLE sample
BITSAMPLEparent_sampleParent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
BITSAMPLEstandardStandard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
BITSAMPLElogin_byLogin by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
BITSAMPLElogin_dateLogin date: creation date of the sample
BITSAMPLElegacyLegacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
BITTESTtest changed_onTEST changed on: date/time stamp for a change to a test record.
BITTESTtest statusTEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
BITTESTtest old_statusTEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
BITTESTtest test_numberTEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
BITTESTtest date_receivedTEST date received: date/time stamp for the creation of the test record.
BITTESTtest 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)
BITTESTtest analysisTEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
BITTESTtest 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
BITTESTtest sample_numberTEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
BITRESULTjetsRESULT number of jets: number of jets on the specific bit being employed
BITRESULTmanufacturerRESULT manufacturer: name of the company that built the bit
BITRESULToperating_timeRESULT operating time (hours): total operating time of the bit in hours
BITRESULTserial_noRESULT serial number: serial number of the bit
BITRESULTsizeRESULT size (unit varies): size of the bit, typically in inches, but unit is included in the entry field
BITRESULTtypeRESULT bit type: type of bit (e.g., RCB, PDC M331, APC)


ANALYSISTABLENAMEABOUT TEXT
DRILLINGSAMPLEExpExp: expedition number
DRILLINGSAMPLESiteSite: site number
DRILLINGSAMPLEHoleHole: hole number
DRILLINGSAMPLECoreCore: core number
DRILLINGSAMPLETypeType: type indicates the coring tool used to recover the core (typical types are F, H, R, X).
DRILLINGSAMPLEtext_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.
DRILLINGSAMPLEsample_numberSample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
DRILLINGSAMPLElabel_idLabel identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
DRILLINGSAMPLEsample_nameSample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
DRILLINGSAMPLEx_sample_stateSample state: Single-character identifier always set to "W" for samples; standards can vary.
DRILLINGSAMPLEx_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
DRILLINGSAMPLEx_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
DRILLINGSAMPLElocationLocation: 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
DRILLINGSAMPLEx_sampling_toolSampling tool: sampling tool used to take the sample (e.g., syringe, spatula)
DRILLINGSAMPLEchanged_byChanged by: username of account used to make a change to a sample record
DRILLINGSAMPLEchanged_onChanged on: date/time stamp for change made to a sample record
DRILLINGSAMPLEsample_typeSample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
DRILLINGSAMPLEx_offsetOffset (m): top offset of sample from top of parent sample, expressed in meters.
DRILLINGSAMPLEx_offset_cmOffset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm)
DRILLINGSAMPLEx_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)
DRILLINGSAMPLEx_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
DRILLINGSAMPLEdescriptionSAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments"
DRILLINGSAMPLEx_orig_lenOriginal length (m): field for the original length of a sample; not always (or reliably) populated
DRILLINGSAMPLEx_lengthLength (m): field for the length of a sample [as entered upon creation]
DRILLINGSAMPLEx_length_cmLength (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
DRILLINGSAMPLEstatusStatus: single-character code for the current status of a sample (e.g., active, canceled)
DRILLINGSAMPLEold_statusOld status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
DRILLINGSAMPLEoriginal_sampleOriginal sample: field tying a sample below the CORE level to its parent HOLE sample
DRILLINGSAMPLEparent_sampleParent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
DRILLINGSAMPLEstandardStandard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
DRILLINGSAMPLElogin_byLogin by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
DRILLINGSAMPLElogin_dateLogin date: creation date of the sample
DRILLINGSAMPLElegacyLegacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
DRILLINGTESTtest changed_onTEST changed on: date/time stamp for a change to a test record.
DRILLINGTESTtest statusTEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
DRILLINGTESTtest old_statusTEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
DRILLINGTESTtest test_numberTEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
DRILLINGTESTtest date_receivedTEST date received: date/time stamp for the creation of the test record.
DRILLINGTESTtest 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)
DRILLINGTESTtest analysisTEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
DRILLINGTESTtest 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
DRILLINGTESTtest sample_numberTEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
DRILLINGCALCULATEDTop depth CSF-A (m)Top depth CSF-A (m): position of observation expressed relative to the top of the hole.
DRILLINGCALCULATEDBottom depth CSF-A (m)Bottom depth CSF-A (m): position of observation expressed relative to the top of the hole.
DRILLINGCALCULATEDTop depth CSF-B (m)Top depth [other] (m): position of observation expressed relative to the top of the hole. The location is presented in a scale selected by the science party or the report user.
DRILLINGCALCULATEDBottom depth CSF-B (m)Bottom depth [other] (m): position of observation expressed relative to the top of the hole. The location is presented in a scale selected by the science party or the report user.
DRILLINGRESULTbarrels_of_mud_pumpedRESULT mud volume pumped (bbl): barrels of drilling mud pumped
DRILLINGRESULTbitRESULT bit: type of bit used (e.g., TRICONE)
DRILLINGRESULTcommentsRESULT comments: comments about the measurement; there are no SAMPLE or TEST comments on this report
DRILLINGRESULTcore_barrel_typeRESULT core barrel type: field to record the core barrel type used (e.g., NON_MAG)
DRILLINGRESULTcore_catcherRESULT core catcher type: field to record the type of core catcher used (e.g., CBH,8FH)
DRILLINGRESULTcore_jamRESULT core jammed: field used to indicate whether there was a jammed core
DRILLINGRESULTdrilloverRESULT drillover: field used to indicate whether the interval was drilled over
DRILLINGRESULTend_drilling_timeRESULT drilling end time: does not appear to be used
DRILLINGRESULTgross_rop (m/h)RESULT gross rate of penetration (m/h): gross rate of penetration that also takes into account wireline time
DRILLINGRESULThole_diameter (in)RESULT hole diameter (in): hole diameter based on bottom hole assembly diameter
DRILLINGRESULThole_end_timeRESULT hole end time: does not appear to be used
DRILLINGRESULThole_start_timeRESULT hole start time: does not appear to be used
DRILLINGRESULTmicrospheresRESULT microspheres: field used to indicate whether fluorescent microsphere contamination tracers were used
DRILLINGRESULTminutes_to_cut_or_drillRESULT time to cut or drill (min): time taken to cut the core or to drill the interval
DRILLINGRESULTno_linerRESULT no liner: field used to indicate when no liner is used (e.g., high temperature coring)
DRILLINGRESULTorientationRESULT orientation tool used: field used to indicate when the core orientation tool is deployed and orientation time is taken
DRILLINGRESULToverpullRESULT overpull (k-lbs.): field for recording pounds of overpull
DRILLINGRESULTpartial_strokeRESULT partial stroke: field used to indicate when a partial stroke has occurred
DRILLINGRESULTpft_usedRESULT perfluorocarbon tracer used: field used to indicate when perfluorocarbon tracers (PFTs) were used
DRILLINGRESULTpressure (psi)RESULT pressure (psi): rotary pressure
DRILLINGRESULTprospectus_site_nameRESULT prospectus site name: does not appear to be used
DRILLINGRESULTpumpRESULT pump used: which pump was used (1, 2, or both)
DRILLINGRESULTreal_rop (m/h)RESULT real rate of penetration (m/h): real rate of penetration that only takes into account the time it takes to cut a core
DRILLINGRESULTreason_for_drillingRESULT reason for drilling: explanation of why the hole was drilled (e.g., CASING_10)
DRILLINGRESULTrpmRESULT revolutions per minute: bit rate of rotation
DRILLINGRESULTshear_pinRESULT shear pin: number and type of shear pin used
DRILLINGRESULTshear_pressureRESULT shear pressure (psi): shear pin pressure
DRILLINGRESULTshoe_typeRESULT shoe type: shoe type used (e.g., APCT-3, N-Mag, R-HF)
DRILLINGRESULTspeed_holesRESULT speed holes: number of holes open for fluid flow
DRILLINGRESULTspmRESULT strokes per minute: strokes of the mud pump per minute
DRILLINGRESULTstart_drilling_timeRESULT drilling start time: does not appear to be used
DRILLINGRESULTtemperature_measurementRESULT temperature: whether or not formation temperature measurements were taken
DRILLINGRESULTtorque (AMPS)RESULT torque (amps): top drive torque
DRILLINGRESULTwinchRESULT winch: aft (A) or forward (F) winch used
DRILLINGRESULTwireline_runsRESULT wireline runs: number of wireline runs
DRILLINGRESULTwob (KLBS)RESULT weight on bit (k-lbs.): weight on bit


ANALYSISTABLENAMEABOUT TEXT
LATLONGSAMPLEExpExp: expedition number
LATLONGSAMPLESiteSite: site number
LATLONGSAMPLEHoleHole: hole number
LATLONGSAMPLEtext_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.
LATLONGSAMPLEsample_numberSample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
LATLONGSAMPLElabel_idLabel identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
LATLONGSAMPLEsample_nameSample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
LATLONGSAMPLEx_sample_stateSample state: Single-character identifier always set to "W" for samples; standards can vary.
LATLONGSAMPLEx_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
LATLONGSAMPLEx_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
LATLONGSAMPLElocationLocation: 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
LATLONGSAMPLEx_sampling_toolSampling tool: sampling tool used to take the sample (e.g., syringe, spatula)
LATLONGSAMPLEchanged_byChanged by: username of account used to make a change to a sample record
LATLONGSAMPLEchanged_onChanged on: date/time stamp for change made to a sample record
LATLONGSAMPLEsample_typeSample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
LATLONGSAMPLEx_offsetOffset (m): top offset of sample from top of parent sample, expressed in meters.
LATLONGSAMPLEx_offset_cmOffset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm)
LATLONGSAMPLEx_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)
LATLONGSAMPLEx_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
LATLONGSAMPLEdescriptionSAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments"
LATLONGSAMPLEx_orig_lenOriginal length (m): field for the original length of a sample; not always (or reliably) populated
LATLONGSAMPLEx_lengthLength (m): field for the length of a sample [as entered upon creation]
LATLONGSAMPLEx_length_cmLength (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
LATLONGSAMPLEstatusStatus: single-character code for the current status of a sample (e.g., active, canceled)
LATLONGSAMPLEold_statusOld status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
LATLONGSAMPLEoriginal_sampleOriginal sample: field tying a sample below the CORE level to its parent HOLE sample
LATLONGSAMPLEparent_sampleParent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
LATLONGSAMPLEstandardStandard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
LATLONGSAMPLElogin_byLogin by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
LATLONGSAMPLElogin_dateLogin date: creation date of the sample
LATLONGSAMPLElegacyLegacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
LATLONGTESTtest changed_onTEST changed on: date/time stamp for a change to a test record.
LATLONGTESTtest statusTEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
LATLONGTESTtest old_statusTEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
LATLONGTESTtest test_numberTEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
LATLONGTESTtest date_receivedTEST date received: date/time stamp for the creation of the test record.
LATLONGTESTtest 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)
LATLONGTESTtest analysisTEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
LATLONGTESTtest 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
LATLONGTESTtest sample_numberTEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
LATLONGRESULTlatitudeRESULT latitude (deg.): the latitude of the hole
LATLONGRESULTlongitudeRESULT longitude (deg.): the longitude of the hole


ANALYSISTABLENAMEABOUT TEXT
ORIGDEPTHSAMPLEExpExp: expedition number
ORIGDEPTHSAMPLESiteSite: site number
ORIGDEPTHSAMPLEHoleHole: hole number
ORIGDEPTHSAMPLEtext_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.
ORIGDEPTHSAMPLEsample_numberSample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
ORIGDEPTHSAMPLElabel_idLabel identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
ORIGDEPTHSAMPLEsample_nameSample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
ORIGDEPTHSAMPLEx_sample_stateSample state: Single-character identifier always set to "W" for samples; standards can vary.
ORIGDEPTHSAMPLEx_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
ORIGDEPTHSAMPLEx_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
ORIGDEPTHSAMPLElocationLocation: 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
ORIGDEPTHSAMPLEchanged_byChanged by: username of account used to make a change to a sample record
ORIGDEPTHSAMPLEchanged_onChanged on: date/time stamp for change made to a sample record
ORIGDEPTHSAMPLEsample_typeSample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
ORIGDEPTHSAMPLEdescriptionSAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments"
ORIGDEPTHSAMPLEx_orig_lenOriginal length (m): field for the original length of a sample; not always (or reliably) populated
ORIGDEPTHSAMPLEx_lengthLength (m): field for the length of a sample [as entered upon creation]
ORIGDEPTHSAMPLEx_length_cmLength (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
ORIGDEPTHSAMPLEstatusStatus: single-character code for the current status of a sample (e.g., active, canceled)
ORIGDEPTHSAMPLEold_statusOld status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
ORIGDEPTHSAMPLEoriginal_sampleOriginal sample: field tying a sample below the CORE level to its parent HOLE sample
ORIGDEPTHSAMPLEparent_sampleParent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
ORIGDEPTHSAMPLEstandardStandard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
ORIGDEPTHSAMPLElogin_byLogin by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
ORIGDEPTHSAMPLElogin_dateLogin date: creation date of the sample
ORIGDEPTHSAMPLElegacyLegacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
ORIGDEPTHTESTtest changed_onTEST changed on: date/time stamp for a change to a test record.
ORIGDEPTHTESTtest statusTEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
ORIGDEPTHTESTtest old_statusTEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
ORIGDEPTHTESTtest test_numberTEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
ORIGDEPTHTESTtest date_receivedTEST date received: date/time stamp for the creation of the test record.
ORIGDEPTHTESTtest 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)
ORIGDEPTHTESTtest analysisTEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
ORIGDEPTHTESTtest 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
ORIGDEPTHTESTtest sample_numberTEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
ORIGDEPTHCALCULATEDTop depth CSF-A (m)Top depth CSF-A (m): position of observation expressed relative to the top of the hole.
ORIGDEPTHCALCULATEDBottom depth CSF-A (m)Bottom depth CSF-A (m): position of observation expressed relative to the top of the hole.
ORIGDEPTHCALCULATEDTop depth CSF-B (m)Top depth [other] (m): position of observation expressed relative to the top of the hole. The location is presented in a scale selected by the science party or the report user.
ORIGDEPTHCALCULATEDBottom depth CSF-B (m)Bottom depth [other] (m): position of observation expressed relative to the top of the hole. The location is presented in a scale selected by the science party or the report user.
ORIGDEPTHRESULTdepth_meas_methodRESULT depth measurement method: method that the original depth was determined (e.g., tagged seafloor, offset, APC calculation)
ORIGDEPTHRESULTmean_vessel_draft (m)RESULT mean vessel draft (m): average vessel draft during the coring period for this hole
ORIGDEPTHRESULTpdr (m)RESULD pdr reading (m): average PDR 3.5 kHz echosounder reading of the ocean depth for the coring period for this hole
ORIGDEPTHRESULTprospectus_site_nameRESULT prospectus site name: site name from the prospectus (pre-expedition designation) (e.g., SATL-56B)
ORIGDEPTHRESULTref_pointRESULT reference point: point of reference for the hole (e.g., seafloor). This component is not usually used
ORIGDEPTHRESULTseafloor_drf (m)RESULT seafloor distance from rigfloor (m): distance from the rigfloor to the seafloor, calculated from water depth and draft
ORIGDEPTHRESULTunparented_depth (m)RESULT unparented depth (m): a calculated hole depth field no longer used after Exp. 360, but legacy data may include it