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)