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.