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 |