...
All improvements to the Quick Start Guides and User Guides are a communal effort, with honorable mention to the group of LOs, ALOs, and technicians who have helped.
VI. LIMS Component Table
| ANALYSIS | TABLE | NAME | ABOUT TEXT |
| TCON | SAMPLE | Exp | Exp: expedition number |
| TCON | SAMPLE | Site | Site: site number |
| TCON | SAMPLE | Hole | Hole: hole number |
| TCON | SAMPLE | Core | Core: core number |
| TCON | SAMPLE | Type | Type: type indicates the coring tool used to recover the core (typical types are F, H, R, X). |
| TCON | SAMPLE | Sect | Sect: section number |
| TCON | SAMPLE | A/W | A/W: archive (A) or working (W) section half. |
| TCON | 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. |
| TCON | SAMPLE | sample_number | Sample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table. |
| TCON | 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. |
| TCON | 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. |
| TCON | SAMPLE | x_sample_state | Sample state: Single-character identifier always set to "W" for samples; standards can vary. |
| TCON | 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 |
| TCON | 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 |
| TCON | 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 |
| TCON | SAMPLE | x_sampling_tool | Sampling tool: sampling tool used to take the sample (e.g., syringe, spatula) |
| TCON | SAMPLE | changed_by | Changed by: username of account used to make a change to a sample record |
| TCON | SAMPLE | changed_on | Changed on: date/time stamp for change made to a sample record |
| TCON | SAMPLE | sample_type | Sample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ) |
| TCON | SAMPLE | x_offset | Offset (m): top offset of sample from top of parent sample, expressed in meters. |
| TCON | 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) |
| TCON | 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) |
| TCON | 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 |
| TCON | SAMPLE | x_orig_len | Original length (m): field for the original length of a sample; not always (or reliably) populated |
| TCON | SAMPLE | x_length | Length (m): field for the length of a sample [as entered upon creation] |
| TCON | SAMPLE | x_length_cm | Length (cm): field for the length of a sample. This is a calculated field (length, converted to cm). |
| TCON | SAMPLE | status | Status: single-character code for the current status of a sample (e.g., active, canceled) |
| TCON | 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 |
| TCON | SAMPLE | original_sample | Original sample: field tying a sample below the CORE level to its parent HOLE sample |
| TCON | 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) |
| TCON | SAMPLE | standard | Standard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T) |
| TCON | 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]) |
| TCON | SAMPLE | login_date | Login date: creation date of the sample |
| TCON | SAMPLE | legacy | Legacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition |
| TCON | TEST | test changed_on | TEST changed on: date/time stamp for a change to a test record. |
| TCON | TEST | test status | TEST status: single-character code for the current status of a test (e.g., active, in process, canceled) |
| TCON | 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 |
| TCON | TEST | test test_number | TEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table. |
| TCON | TEST | test date_received | TEST date received: date/time stamp for the creation of the test record. |
| TCON | 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) |
| TCON | TEST | test analysis | TEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table) |
| TCON | 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 |
| TCON | 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 |
| TCON | CALCULATED | Depth CSF-A (m) | Depth CSF-A (m): position of observation expressed relative to the top of the hole. |
| TCON | CALCULATED | Depth CSF-B (m) | 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. |
| TCON | RESULT | contact_value | RESULT contact value (unitless): unitless measure of contact quality between probe and sample |
| TCON | RESULT | dat_asman_id | RESULT DAT file ASMAN_ID: serial number of the ASMAN link for the .DAT file |
| TCON | RESULT | dat_filename | RESULT DAT filename: file name of the .DAT file |
| TCON | RESULT | dwl_asman_id | RESULT DWL file ASMAN_ID: serial number of the ASMAN link for the .DWL file |
| TCON | RESULT | dwl_filename | RESULT DWL filename: file name of the .DWL file |
| TCON | RESULT | end_time (s) | RESULT end time (s): the ending time of the experiment in seconds from initialization |
| TCON | RESULT | erg_asman_id | RESULT ERG file ASMAN_ID: serial number of the ASMAN link for the .ERG file |
| TCON | RESULT | erg_filename | RESULT ERG filename: file name of the .ERG file |
| TCON | RESULT | heating_power (W/m) | RESULT heating power (W/m): heating power applied to the sample (it can be useful to reduce this if it is challenging to get a good result) |
| TCON | RESULT | length_of_time (s) | RESULT length of time (s): duration of the linear portion of the heating experiment, determined by subtracting start time from end time |
| TCON | RESULT | mdb_asman_id | RESULT MDB file ASMAN_ID: serial number of the ASMAN link for the .MDB file |
| TCON | RESULT | mdb_filename | RESULT MDB filename: file name of the .MDB file |
| TCON | RESULT | method | RESULT method: indicates whether the TeKa Berlin SAM method or the linear-calculation TCON method was used |
| TCON | RESULT | instrument | RESULT instrument: name of the instrument used |
| TCON | RESULT | needle_name | RESULT needle name: serial number of the needle used (H#### for half-space; V#### for full-space) |
| TCON | RESULT | number_of_solutions | RESULT number of solutions: number of independent valid solutions the SAM method found; the higher this number, the better (and <100 should be carefully checked) |
| TCON | RESULT | offset (cm) | RESULT offset (cm): position of the measurement relative to the top of a section |
| TCON | RESULT | ssup_asman_id | RESULT spreadsheet uploader ASMAN_ID: serial number of the ASMAN link for the spreadsheet uploader file |
| TCON | RESULT | ssup_filename | RESULT spreadsheet uploader filename: file name of the spreadsheet uploader file |
| TCON | RESULT | start_time (s) | RESULT start time (s): the starting time of the experiment in seconds from initialization |
| TCON | RESULT | therm_con_average (W/(m*K)) | RESULT average thermal conductivity (W/(m*K), SAM): mean result of successive thermal conductivity observations using the SAM method |
| TCON | RESULT | therm_con_number | RESULT number of measurements (SAM): the number of measurements performed to produce the mean result for the SAM method |
| TCON | RESULT | therm_con_result (W/(m*K)) | RESULT individual thermal conductivity (W/(m*K), SAM): individual thermal conductivity measurement using the SAM method |
| TCON | RESULT | therm_con_stdev (W/(m*K)) | RESULT standard deviation (W/(m*K), SAM): standard deviation of the averaged results from the SAM method |
| TCON | RESULT | therm_con_average_calc | RESULT average thermal conductivity (W/(m*K), TCON): mean result of successive thermal conductivity observations using the TCON method |
| TCON | RESULT | therm_con_number_calc | RESULT number of measurements (TCON): the number of measurements performed to produce the mean result for the TCON method |
| TCON | RESULT | therm_con_result_calc | RESULT individual thermal conductivity (W/(m*K), TCON): individual thermal conductivity measurement using the TCON method |
| TCON | RESULT | therm_con_stdev_calc | RESULT standard deviation (W/(m*K), TCON): standard deviation of the averaged results from the TCON method |
| TCON | SAMPLE | sample description | SAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments" |
| TCON | TEST | test test_comment | TEST comment: contents of the TEST.comment field, usually shown on reports as "Test comments" |
| TCON | RESULT | result comments | RESULT comment: contents of a result parameter with name = "comment," usually shown on reports as "Result comments" |