Versions Compared

Key

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

...

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


ROUTING. Deprecated. Occasional evidence of this analysis still showing up in some types of record creation.

SCALINPUTS. Deprecated. Mechanism for recording all the necessary inputs required for the implementation of (multiple) depth models. Superseded by reworking of depth modelling that culminated in a distinct X_SAMPLE_DEPTH table, and dedicated systems for modelling depth--X_SPLICE, X_AFFINE.