From WinLIMS
Jump to: navigation, search

The SAMPLEPARAM table is used to hold the details of parameters that have been assigned to SAMPLEs. This means that it holds the results and all of their associated information. Since the values in this table are associated with the recorded results it is one of the most frequesnt sources of data that are used within reports and it is quite beneficial to study the contents of this table to understand what it holds.


The fields that are provided within the OTS (Off-The-Shelf) database are listed in the following table. Please note that tools are available to allow you to modify existing fields or add more fields to the table and associated pages (manage Samples, browse Results, results Worklist, manage Worklist and manage Instruments) to accommodate local needs.


The SAMPLEPARAM table stores result-related information for the various tests that are performed each WinLIMS.NET sample. This table is one of the key tables within the core heirarchical structure of WinLIMS.NET. This core structure is as follows:


  • ORDERS
  • SAMPLE
  • SAMPMETH
  • SAMPLEPARAM


An ORDERS record represents a request for work that is submitted to the lab or can also represent a production lot (or batch) of product from which one or more samples are taken.


A SAMPLE record contains all of the information that describes the physical and Elecrronic Representative Samples that are managed within WinLIMS.NET. Multiple SAMPLE records can be associated with a single ORDERS record; hence, they are considered to be 'child' records of the 'parent' ORDERS record.


A SAMPMETH record contains the information that describes each test methpd that is assigned to each SAMPLE. Since multiple test methods can be assigned to a single SAMPLE record, SAMPMETH records are considered to be 'child' records of their 'parent' SAMPLE records.


The SAMPLEPARAM table contains the results information that is associated with individual test methods that are assigned to samples. Since multiple results can be associated with a single test method, the SAMPMETH table is the 'parent' of SAMPLEPARAM table.


Field Name Data Type Description/Use
SAMPLEPARAM_ID Integer The database-generated number that uniquely identifies records in the table (the identity column).
SAMPLE_ID varchar(20) A reference to unique identification field in the 'parent' SAMPLE table. This field is also used as a reference to the SAMPMETH table which is another of its 'parent' tables.
INDX integer The order in which the parameter' 'parent' test (SAMPMETH record) was assigned to the SAMPLE. This value can be used to order the output of records within reports or to distinguish replicates when the same test method is assigned to the sample multiple times.
ST_N integer This value is a reference to the record in the WinLIMS.NET SAMPLETYPE Table that was assigned to the associated SAMPLE record. A second reference field (the ST_VERS) is required to complete the reference to the version-controlled SAMPLETYPE record. This is helpful in referencing the product or test suite with which the result is associated.
ST_VERS integer This value is a reference to the record in the WinLIMS.NET SAMPLETYPE Table that was assigned to the associated SAMPLE record. This field represents the 'version' of the SAMPLETYPE record. A second reference field (the ST_N) is required to complete the reference to the version-controlled SAMPLETYPE record. This is helpful in referencing the product or test suite with which the result is associated.
ME_N integer A reference to the test method in the WinLIMS.NET METHOD Table that is associated with the parameter (result). A second field (the ME_VERS field) is required to locate the specific version-controlled METHOD record.
ME_VERS integer A reference to the version of the test method in the WinLIMS.NET METHOD Table that is associated with the parameter (result). A second field (the ME_N field) is required to locate the specific version-controlled METHOD record.
PA_NAME varchar(30) The name of the parameter (analyte, characteristic, etc.) for which the result is recorded.
PARAM_UNITS varchar(10) The units of measure that is used to qualify the recorded result(s).
SRESULT varchar(20) The string representation of the result that has been rounded and formatted to accommodate detection limits, decimal place formatting, significant figures or text formatting. This is the field into results are entered and then automatically formatted..
ORESULT varchar(20) This value stores the originally entered result 'as is' (prior to applying formatting rules) whether entered manually or by instrument interface.
NRESULT decimal(28,8) The numeric representation of the result after the assigned formatting rules. The rounding is done according to the record's formatting rules.
RES_PRECISION integer When set to a positive value, it identifies the number of decimal places to which the entered result will be rounded and formatted within the SRESULT and NRESULT fields. When set to a negative value, it identified the number of significant figures to which the SRESULT and NRESULT values will be presented.
LIMIT1LO decimal(28,8) The lower value of the primary limit range. The matching upper limit is the LIMIT1HI value. When a result is lower than this value a 1 is assigned to the STATUS field.
LIMIT1HI decimal(28,8) The upper value of the primary limit range. The matching lower limit is LIMIT1LO. When a result is greater than this value a 1 is appended to the STATUS field.
LIMIT2LO decimal(28,8) The lower value of the secondary limit range. The matching upper limit is the LIMIT2HI value. When a result is lower than this value a 2 is assigned to the STATUS field.
LIMIT2HI decimal(28,8) The upper value of the secondary limit range. The matching lower limit is LIMIT2LO. When a result is greater than this value a 2 is appended to the STATUS field.
LIMIT3LO decimal(28,8) The lower value of the tertiarylimit range. The matching upper limit is the LIMIT3HI value. When a result is lower than this value a 3 is assigned to the STATUS field.
LIMIT3HI decimal(28,8) The upper value of the tertiary limit range. The matching lower limit is LIMIT3LO. When a result is greater than this value a 3 is appended to the STATUS field.
STATUS varchar(10) The status of the result is a combination of 3 classifications; entry status, conformance to limits, validation (or review) status
LDL decimal(28,8) The lower detection limit of the result. This is the limit below which results cannot be measured. When a result is entered that is below this value, the SRESULT value will be converted to '< LDL' (e.g. '<0.01', '<0.5', etc.).
UDL decimal(28,8) The lower detection limit of the result. This is the limit above which results cannot be reliably measured. When a result is entered that is above this value, the SRESULT value will be converted to '> UDL' (e.g. '>100.0', '>500', etc.).
PQL decimal(28,8) The practical quantitation limit of the result. This is the limit below which results cannot be 'reliably' measured. When a result is entered that is below this value, the SRESULT value will be converted to '< LDL' (e.g. '<0.01', '<0.5', etc.).
TRESULT varchar(254) A free text field into which and results-related comments and notes can be entered.
PRINT_FLAG integer This field is generally used to indicate printable vs. non-printable results. When designing Crystal Reports a logical if/then/else statement is used within a formula that outputs the record when the PRINT_FLAG is set to 1 and suppresses it when set to 0 or is null.
PA_N iteger This value identifies the logical order in which the parameter (analyte, characteristic, etc.) is presented within results entry pages. The value can also be used when sorting records in reports. The value is defined during the creation of test methods within the Method Manager.
SQC_N integer The maximum number of data points that will be used to perform on-line SQC (statistical quality control) calculations. The last 'n' number of data points represents the current PA_NAME and SAMPLETYPE (using the ST_N and ST_VERS to define a unique SAMPLETYPE record) where the results are valid (STATUS like '%v%').
SQC_AVG decimal(28,8( The city (or town) that is associated with the secondary physical location or mailing address.
ST_STATE varchar(8) The state (or province) that is associated with the secondary physical location or mailing address.
ST_ZIP varchar(10) The ZIP (or Postal) code tha tis associated with the secondary physical location or mailing address.
ST_TELEPHONE varchar(10) The secondary telephone number.
ST_FAX varchar(10) The secondary FAX number.
ST_TITLE varchar(50) The secondary contact's job title.
ST_ADDRESS_AS varchar(20) The formal precursor to the secondary contact's name (e.g. Mr., Ms., Dr., etc.).
ST_EMAIL varchar(70) The secondary contact's email address.



WinLIMS.NET Tables Page | Companies Manager Page | Return to Main Help Page File:Pushbutton-Wiki-Help.jpg