LIMS Tables for Miscellaneous ANALYSIS Codes

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.

ANALYSIS	TABLE	NAME	ABOUT TEXT
BHA	SAMPLE	Exp	Exp: expedition number
BHA	SAMPLE	Site	Site: site number
BHA	SAMPLE	Hole	Hole: hole number
BHA	SAMPLE	text_id	Text_ID: automatically generated database identifier for a sample, also carried on the printed labels. This identifier is guaranteed to be unique across all samples.
BHA	SAMPLE	sample_number	Sample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
BHA	SAMPLE	label_id	Label identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
BHA	SAMPLE	sample_name	Sample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
BHA	SAMPLE	x_sample_state	Sample state: Single-character identifier always set to "W" for samples; standards can vary.
BHA	SAMPLE	x_project	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
BHA	SAMPLE	x_capt_loc	Captured 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
BHA	SAMPLE	location	Location: 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
BHA	SAMPLE	x_sampling_tool	Sampling tool: sampling tool used to take the sample (e.g., syringe, spatula)
BHA	SAMPLE	changed_by	Changed by: username of account used to make a change to a sample record
BHA	SAMPLE	changed_on	Changed on: date/time stamp for change made to a sample record
BHA	SAMPLE	sample_type	Sample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
BHA	SAMPLE	x_offset	Offset (m): top offset of sample from top of parent sample, expressed in meters.
BHA	SAMPLE	x_offset_cm	Offset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm)
BHA	SAMPLE	x_bottom_offset_cm	Bottom offset (cm): bottom offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset + length, converted to cm)
BHA	SAMPLE	x_diameter	Diameter (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
BHA	SAMPLE	description	SAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments"
BHA	SAMPLE	x_orig_len	Original length (m): field for the original length of a sample; not always (or reliably) populated
BHA	SAMPLE	x_length	Length (m): field for the length of a sample [as entered upon creation]
BHA	SAMPLE	x_length_cm	Length (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
BHA	SAMPLE	status	Status: single-character code for the current status of a sample (e.g., active, canceled)
BHA	SAMPLE	old_status	Old status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
BHA	SAMPLE	original_sample	Original sample: field tying a sample below the CORE level to its parent HOLE sample
BHA	SAMPLE	parent_sample	Parent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
BHA	SAMPLE	standard	Standard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
BHA	SAMPLE	login_by	Login by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
BHA	SAMPLE	login_date	Login date: creation date of the sample
BHA	SAMPLE	legacy	Legacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
BHA	TEST	test changed_on	TEST changed on: date/time stamp for a change to a test record.
BHA	TEST	test status	TEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
BHA	TEST	test old_status	TEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
BHA	TEST	test test_number	TEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
BHA	TEST	test date_received	TEST date received: date/time stamp for the creation of the test record.
BHA	TEST	test instrument	TEST instrument [instrument group]: field that describes the instrument group (most often this applies to loggers with multiple sensors); often obscure (e.g., user_input)
BHA	TEST	test analysis	TEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
BHA	TEST	test x_project	TEST 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
BHA	TEST	test sample_number	TEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
BHA	RESULT	length	RESULT length (m): length of the bottom hole assembly

ANALYSIS	TABLE	NAME	ABOUT TEXT
BIT	SAMPLE	Exp	Exp: expedition number
BIT	SAMPLE	Site	Site: site number
BIT	SAMPLE	Hole	Hole: hole number
BIT	SAMPLE	text_id	Text_ID: automatically generated database identifier for a sample, also carried on the printed labels. This identifier is guaranteed to be unique across all samples.
BIT	SAMPLE	sample_number	Sample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
BIT	SAMPLE	label_id	Label identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
BIT	SAMPLE	sample_name	Sample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
BIT	SAMPLE	x_sample_state	Sample state: Single-character identifier always set to "W" for samples; standards can vary.
BIT	SAMPLE	x_project	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
BIT	SAMPLE	x_capt_loc	Captured 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
BIT	SAMPLE	location	Location: 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
BIT	SAMPLE	x_sampling_tool	Sampling tool: sampling tool used to take the sample (e.g., syringe, spatula)
BIT	SAMPLE	changed_by	Changed by: username of account used to make a change to a sample record
BIT	SAMPLE	changed_on	Changed on: date/time stamp for change made to a sample record
BIT	SAMPLE	sample_type	Sample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
BIT	SAMPLE	x_offset	Offset (m): top offset of sample from top of parent sample, expressed in meters.
BIT	SAMPLE	x_offset_cm	Offset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm)
BIT	SAMPLE	x_bottom_offset_cm	Bottom offset (cm): bottom offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset + length, converted to cm)
BIT	SAMPLE	x_diameter	Diameter (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
BIT	SAMPLE	description	SAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments"
BIT	SAMPLE	x_orig_len	Original length (m): field for the original length of a sample; not always (or reliably) populated
BIT	SAMPLE	x_length	Length (m): field for the length of a sample [as entered upon creation]
BIT	SAMPLE	x_length_cm	Length (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
BIT	SAMPLE	status	Status: single-character code for the current status of a sample (e.g., active, canceled)
BIT	SAMPLE	old_status	Old status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
BIT	SAMPLE	original_sample	Original sample: field tying a sample below the CORE level to its parent HOLE sample
BIT	SAMPLE	parent_sample	Parent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
BIT	SAMPLE	standard	Standard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
BIT	SAMPLE	login_by	Login by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
BIT	SAMPLE	login_date	Login date: creation date of the sample
BIT	SAMPLE	legacy	Legacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
BIT	TEST	test changed_on	TEST changed on: date/time stamp for a change to a test record.
BIT	TEST	test status	TEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
BIT	TEST	test old_status	TEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
BIT	TEST	test test_number	TEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
BIT	TEST	test date_received	TEST date received: date/time stamp for the creation of the test record.
BIT	TEST	test instrument	TEST instrument [instrument group]: field that describes the instrument group (most often this applies to loggers with multiple sensors); often obscure (e.g., user_input)
BIT	TEST	test analysis	TEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
BIT	TEST	test x_project	TEST 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
BIT	TEST	test sample_number	TEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
BIT	RESULT	jets	RESULT number of jets: number of jets on the specific bit being employed
BIT	RESULT	manufacturer	RESULT manufacturer: name of the company that built the bit
BIT	RESULT	operating_time	RESULT operating time (hours): total operating time of the bit in hours
BIT	RESULT	serial_no	RESULT serial number: serial number of the bit
BIT	RESULT	size	RESULT size (unit varies): size of the bit, typically in inches, but unit is included in the entry field
BIT	RESULT	type	RESULT bit type: type of bit (e.g., RCB, PDC M331, APC)

ANALYSIS	TABLE	NAME	ABOUT TEXT
DRILLING	SAMPLE	Exp	Exp: expedition number
DRILLING	SAMPLE	Site	Site: site number
DRILLING	SAMPLE	Hole	Hole: hole number
DRILLING	SAMPLE	Core	Core: core number
DRILLING	SAMPLE	Type	Type: type indicates the coring tool used to recover the core (typical types are F, H, R, X).
DRILLING	SAMPLE	text_id	Text_ID: automatically generated database identifier for a sample, also carried on the printed labels. This identifier is guaranteed to be unique across all samples.
DRILLING	SAMPLE	sample_number	Sample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
DRILLING	SAMPLE	label_id	Label identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
DRILLING	SAMPLE	sample_name	Sample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
DRILLING	SAMPLE	x_sample_state	Sample state: Single-character identifier always set to "W" for samples; standards can vary.
DRILLING	SAMPLE	x_project	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
DRILLING	SAMPLE	x_capt_loc	Captured 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
DRILLING	SAMPLE	location	Location: 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
DRILLING	SAMPLE	x_sampling_tool	Sampling tool: sampling tool used to take the sample (e.g., syringe, spatula)
DRILLING	SAMPLE	changed_by	Changed by: username of account used to make a change to a sample record
DRILLING	SAMPLE	changed_on	Changed on: date/time stamp for change made to a sample record
DRILLING	SAMPLE	sample_type	Sample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
DRILLING	SAMPLE	x_offset	Offset (m): top offset of sample from top of parent sample, expressed in meters.
DRILLING	SAMPLE	x_offset_cm	Offset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm)
DRILLING	SAMPLE	x_bottom_offset_cm	Bottom offset (cm): bottom offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset + length, converted to cm)
DRILLING	SAMPLE	x_diameter	Diameter (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
DRILLING	SAMPLE	description	SAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments"
DRILLING	SAMPLE	x_orig_len	Original length (m): field for the original length of a sample; not always (or reliably) populated
DRILLING	SAMPLE	x_length	Length (m): field for the length of a sample [as entered upon creation]
DRILLING	SAMPLE	x_length_cm	Length (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
DRILLING	SAMPLE	status	Status: single-character code for the current status of a sample (e.g., active, canceled)
DRILLING	SAMPLE	old_status	Old status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
DRILLING	SAMPLE	original_sample	Original sample: field tying a sample below the CORE level to its parent HOLE sample
DRILLING	SAMPLE	parent_sample	Parent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
DRILLING	SAMPLE	standard	Standard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
DRILLING	SAMPLE	login_by	Login by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
DRILLING	SAMPLE	login_date	Login date: creation date of the sample
DRILLING	SAMPLE	legacy	Legacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
DRILLING	TEST	test changed_on	TEST changed on: date/time stamp for a change to a test record.
DRILLING	TEST	test status	TEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
DRILLING	TEST	test old_status	TEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
DRILLING	TEST	test test_number	TEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
DRILLING	TEST	test date_received	TEST date received: date/time stamp for the creation of the test record.
DRILLING	TEST	test instrument	TEST instrument [instrument group]: field that describes the instrument group (most often this applies to loggers with multiple sensors); often obscure (e.g., user_input)
DRILLING	TEST	test analysis	TEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
DRILLING	TEST	test x_project	TEST 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
DRILLING	TEST	test sample_number	TEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
DRILLING	CALCULATED	Top depth CSF-A (m)	Top depth CSF-A (m): position of observation expressed relative to the top of the hole.
DRILLING	CALCULATED	Bottom depth CSF-A (m)	Bottom depth CSF-A (m): position of observation expressed relative to the top of the hole.
DRILLING	CALCULATED	Top 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.
DRILLING	CALCULATED	Bottom 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.
DRILLING	RESULT	barrels_of_mud_pumped	RESULT mud volume pumped (bbl): barrels of drilling mud pumped
DRILLING	RESULT	bit	RESULT bit: type of bit used (e.g., TRICONE)
DRILLING	RESULT	comments	RESULT comments: comments about the measurement; there are no SAMPLE or TEST comments on this report
DRILLING	RESULT	core_barrel_type	RESULT core barrel type: field to record the core barrel type used (e.g., NON_MAG)
DRILLING	RESULT	core_catcher	RESULT core catcher type: field to record the type of core catcher used (e.g., CBH,8FH)
DRILLING	RESULT	core_jam	RESULT core jammed: field used to indicate whether there was a jammed core
DRILLING	RESULT	drillover	RESULT drillover: field used to indicate whether the interval was drilled over
DRILLING	RESULT	end_drilling_time	RESULT drilling end time: does not appear to be used
DRILLING	RESULT	gross_rop (m/h)	RESULT gross rate of penetration (m/h): gross rate of penetration that also takes into account wireline time
DRILLING	RESULT	hole_diameter (in)	RESULT hole diameter (in): hole diameter based on bottom hole assembly diameter
DRILLING	RESULT	hole_end_time	RESULT hole end time: does not appear to be used
DRILLING	RESULT	hole_start_time	RESULT hole start time: does not appear to be used
DRILLING	RESULT	microspheres	RESULT microspheres: field used to indicate whether fluorescent microsphere contamination tracers were used
DRILLING	RESULT	minutes_to_cut_or_drill	RESULT time to cut or drill (min): time taken to cut the core or to drill the interval
DRILLING	RESULT	no_liner	RESULT no liner: field used to indicate when no liner is used (e.g., high temperature coring)
DRILLING	RESULT	orientation	RESULT orientation tool used: field used to indicate when the core orientation tool is deployed and orientation time is taken
DRILLING	RESULT	overpull	RESULT overpull (k-lbs.): field for recording pounds of overpull
DRILLING	RESULT	partial_stroke	RESULT partial stroke: field used to indicate when a partial stroke has occurred
DRILLING	RESULT	pft_used	RESULT perfluorocarbon tracer used: field used to indicate when perfluorocarbon tracers (PFTs) were used
DRILLING	RESULT	pressure (psi)	RESULT pressure (psi): rotary pressure
DRILLING	RESULT	prospectus_site_name	RESULT prospectus site name: does not appear to be used
DRILLING	RESULT	pump	RESULT pump used: which pump was used (1, 2, or both)
DRILLING	RESULT	real_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
DRILLING	RESULT	reason_for_drilling	RESULT reason for drilling: explanation of why the hole was drilled (e.g., CASING_10)
DRILLING	RESULT	rpm	RESULT revolutions per minute: bit rate of rotation
DRILLING	RESULT	shear_pin	RESULT shear pin: number and type of shear pin used
DRILLING	RESULT	shear_pressure	RESULT shear pressure (psi): shear pin pressure
DRILLING	RESULT	shoe_type	RESULT shoe type: shoe type used (e.g., APCT-3, N-Mag, R-HF)
DRILLING	RESULT	speed_holes	RESULT speed holes: number of holes open for fluid flow
DRILLING	RESULT	spm	RESULT strokes per minute: strokes of the mud pump per minute
DRILLING	RESULT	start_drilling_time	RESULT drilling start time: does not appear to be used
DRILLING	RESULT	temperature_measurement	RESULT temperature: whether or not formation temperature measurements were taken
DRILLING	RESULT	torque (AMPS)	RESULT torque (amps): top drive torque
DRILLING	RESULT	winch	RESULT winch: aft (A) or forward (F) winch used
DRILLING	RESULT	wireline_runs	RESULT wireline runs: number of wireline runs
DRILLING	RESULT	wob (KLBS)	RESULT weight on bit (k-lbs.): weight on bit

ANALYSIS	TABLE	NAME	ABOUT TEXT
LATLONG	SAMPLE	Exp	Exp: expedition number
LATLONG	SAMPLE	Site	Site: site number
LATLONG	SAMPLE	Hole	Hole: hole number
LATLONG	SAMPLE	text_id	Text_ID: automatically generated database identifier for a sample, also carried on the printed labels. This identifier is guaranteed to be unique across all samples.
LATLONG	SAMPLE	sample_number	Sample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
LATLONG	SAMPLE	label_id	Label identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
LATLONG	SAMPLE	sample_name	Sample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
LATLONG	SAMPLE	x_sample_state	Sample state: Single-character identifier always set to "W" for samples; standards can vary.
LATLONG	SAMPLE	x_project	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
LATLONG	SAMPLE	x_capt_loc	Captured 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
LATLONG	SAMPLE	location	Location: 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
LATLONG	SAMPLE	x_sampling_tool	Sampling tool: sampling tool used to take the sample (e.g., syringe, spatula)
LATLONG	SAMPLE	changed_by	Changed by: username of account used to make a change to a sample record
LATLONG	SAMPLE	changed_on	Changed on: date/time stamp for change made to a sample record
LATLONG	SAMPLE	sample_type	Sample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
LATLONG	SAMPLE	x_offset	Offset (m): top offset of sample from top of parent sample, expressed in meters.
LATLONG	SAMPLE	x_offset_cm	Offset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm)
LATLONG	SAMPLE	x_bottom_offset_cm	Bottom offset (cm): bottom offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset + length, converted to cm)
LATLONG	SAMPLE	x_diameter	Diameter (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
LATLONG	SAMPLE	description	SAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments"
LATLONG	SAMPLE	x_orig_len	Original length (m): field for the original length of a sample; not always (or reliably) populated
LATLONG	SAMPLE	x_length	Length (m): field for the length of a sample [as entered upon creation]
LATLONG	SAMPLE	x_length_cm	Length (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
LATLONG	SAMPLE	status	Status: single-character code for the current status of a sample (e.g., active, canceled)
LATLONG	SAMPLE	old_status	Old status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
LATLONG	SAMPLE	original_sample	Original sample: field tying a sample below the CORE level to its parent HOLE sample
LATLONG	SAMPLE	parent_sample	Parent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
LATLONG	SAMPLE	standard	Standard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
LATLONG	SAMPLE	login_by	Login by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
LATLONG	SAMPLE	login_date	Login date: creation date of the sample
LATLONG	SAMPLE	legacy	Legacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
LATLONG	TEST	test changed_on	TEST changed on: date/time stamp for a change to a test record.
LATLONG	TEST	test status	TEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
LATLONG	TEST	test old_status	TEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
LATLONG	TEST	test test_number	TEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
LATLONG	TEST	test date_received	TEST date received: date/time stamp for the creation of the test record.
LATLONG	TEST	test instrument	TEST instrument [instrument group]: field that describes the instrument group (most often this applies to loggers with multiple sensors); often obscure (e.g., user_input)
LATLONG	TEST	test analysis	TEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
LATLONG	TEST	test x_project	TEST 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
LATLONG	TEST	test sample_number	TEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
LATLONG	RESULT	latitude	RESULT latitude (deg.): the latitude of the hole
LATLONG	RESULT	longitude	RESULT longitude (deg.): the longitude of the hole

ANALYSIS	TABLE	NAME	ABOUT TEXT
ORIGDEPTH	SAMPLE	Exp	Exp: expedition number
ORIGDEPTH	SAMPLE	Site	Site: site number
ORIGDEPTH	SAMPLE	Hole	Hole: hole number
ORIGDEPTH	SAMPLE	text_id	Text_ID: automatically generated database identifier for a sample, also carried on the printed labels. This identifier is guaranteed to be unique across all samples.
ORIGDEPTH	SAMPLE	sample_number	Sample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
ORIGDEPTH	SAMPLE	label_id	Label identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
ORIGDEPTH	SAMPLE	sample_name	Sample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
ORIGDEPTH	SAMPLE	x_sample_state	Sample state: Single-character identifier always set to "W" for samples; standards can vary.
ORIGDEPTH	SAMPLE	x_project	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
ORIGDEPTH	SAMPLE	x_capt_loc	Captured 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
ORIGDEPTH	SAMPLE	location	Location: 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
ORIGDEPTH	SAMPLE	changed_by	Changed by: username of account used to make a change to a sample record
ORIGDEPTH	SAMPLE	changed_on	Changed on: date/time stamp for change made to a sample record
ORIGDEPTH	SAMPLE	sample_type	Sample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
ORIGDEPTH	SAMPLE	description	SAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments"
ORIGDEPTH	SAMPLE	x_orig_len	Original length (m): field for the original length of a sample; not always (or reliably) populated
ORIGDEPTH	SAMPLE	x_length	Length (m): field for the length of a sample [as entered upon creation]
ORIGDEPTH	SAMPLE	x_length_cm	Length (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
ORIGDEPTH	SAMPLE	status	Status: single-character code for the current status of a sample (e.g., active, canceled)
ORIGDEPTH	SAMPLE	old_status	Old status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
ORIGDEPTH	SAMPLE	original_sample	Original sample: field tying a sample below the CORE level to its parent HOLE sample
ORIGDEPTH	SAMPLE	parent_sample	Parent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
ORIGDEPTH	SAMPLE	standard	Standard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
ORIGDEPTH	SAMPLE	login_by	Login by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
ORIGDEPTH	SAMPLE	login_date	Login date: creation date of the sample
ORIGDEPTH	SAMPLE	legacy	Legacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
ORIGDEPTH	TEST	test changed_on	TEST changed on: date/time stamp for a change to a test record.
ORIGDEPTH	TEST	test status	TEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
ORIGDEPTH	TEST	test old_status	TEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
ORIGDEPTH	TEST	test test_number	TEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
ORIGDEPTH	TEST	test date_received	TEST date received: date/time stamp for the creation of the test record.
ORIGDEPTH	TEST	test instrument	TEST instrument [instrument group]: field that describes the instrument group (most often this applies to loggers with multiple sensors); often obscure (e.g., user_input)
ORIGDEPTH	TEST	test analysis	TEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
ORIGDEPTH	TEST	test x_project	TEST 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
ORIGDEPTH	TEST	test sample_number	TEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
ORIGDEPTH	CALCULATED	Top depth CSF-A (m)	Top depth CSF-A (m): position of observation expressed relative to the top of the hole.
ORIGDEPTH	CALCULATED	Bottom depth CSF-A (m)	Bottom depth CSF-A (m): position of observation expressed relative to the top of the hole.
ORIGDEPTH	CALCULATED	Top 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.
ORIGDEPTH	CALCULATED	Bottom 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.
ORIGDEPTH	RESULT	depth_meas_method	RESULT depth measurement method: method that the original depth was determined (e.g., tagged seafloor, offset, APC calculation)
ORIGDEPTH	RESULT	mean_vessel_draft (m)	RESULT mean vessel draft (m): average vessel draft during the coring period for this hole
ORIGDEPTH	RESULT	pdr (m)	RESULD pdr reading (m): average PDR 3.5 kHz echosounder reading of the ocean depth for the coring period for this hole
ORIGDEPTH	RESULT	prospectus_site_name	RESULT prospectus site name: site name from the prospectus (pre-expedition designation) (e.g., SATL-56B)
ORIGDEPTH	RESULT	ref_point	RESULT reference point: point of reference for the hole (e.g., seafloor). This component is not usually used
ORIGDEPTH	RESULT	seafloor_drf (m)	RESULT seafloor distance from rigfloor (m): distance from the rigfloor to the seafloor, calculated from water depth and draft
ORIGDEPTH	RESULT	unparented_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.