Southern California Bight 2008 Regional Monitoring Survey
|
|  Yüklə 3.16 Mb.
|
tblChemistryBatchDataPURPOSE: This table contains information about preparation methods and dates within each lab. A batch is defined as a group of samples with which the QA results are associated. For some labs, QA data is associated with the preparation batch while other labs associate the QA data with analytical batches. Samples prepared in the same batch may move through the lab in different analytical batches. To minimize redundant data entry, the preparation batch information has been broken off into a separate table and is related to the tblChemistryResults through the PreparationBatchID code. Each record in this table represents all information common to each preparation batch. TABLE GUIDELINES:
EXAMPLE DATA: Table Structure: tblChemistryBatchData
**************************************************************************************************** tblChemistryResultsPURPOSE: The purpose of the chemistry results table is to document the analysis results for sediment chemistry and sediment grain size (other sample types such as tissue or water chemistry may be added at a later time). Each record represents a result from a specific analysis for a particular parameter at a single station or a single QA sample. This table will also contain all supporting QA sample results. This table contains some information that will be derived from field data in order to facilitate data analysis. These fields are not required and may be loaded at a later time by the IMO. The fields include: DiscreteSampleDepth, DiscreteSampleDepthUnits, SampleTime, and SampleTimeUnits. SPECIAL CASES:
The reported result is the number gathered from the analytical instrument. The "True Value" is the concentration of the parameter in the reference sample. The purpose of the "True Value" is to facilitate the calculation of percent recovery. The True Value is only reported for matrix spikes and surrogates. A True Value of –99 will be reported for all other samples. The range values for the minimum and maximum for parameters in the certified reference material will be carried in an ancillary table within the analytical database and will not be described here.
The reported result is the number gathered from the instrument and is the net amount recovered from the sample after being corrected for the concentration from the non-spiked sample. For spiked samples the "True Value" is the concentration of the parameter added to the sample before analysis. Percent recovery will be calculated by dividing the result by the True Value times 100. The SampleType must be MS or MSD and the same LabSampleIDs must be used for both. Recovery corrected data: This is not reported because it can be calculated using the True Value of the reference material processed within the same batch. Lab Replicates: Lab replicates are defined as replicate samples taken from the same jar. The result for each replicate will be numbered starting at one, e.g. the result for the first replicate will have a LabReplicate of 1 and the result for the second duplicate will have a LabReplicate of 2, etc. Replicate samples taken in the field will have separate FieldDuplicate numbers and a LabReplicate of 1. Non-Detects: If the result is not reportable, a qualifier of “ND” should be used and the result reported as –99. In the case where the result is below method detection level or below the reporting level, but is being reported anyway, a qualifier of BMDL (below method detection limit) or BRL (below reporting level) should be used and the result reported. QA Samples:Sediment Chemistry: QA samples not performed on site collected sediment samples will be given a StationID of “0000”. All site collected sediment samples will retain the StationID relative to the origin of the sample. QA SampleTypes include one of the following values: CRM-016, CRM-540, FEB, LCM, MB, MS, MSD, SRM-1944 (see luList04_SampleTypes for definitions). All non-QA records should have a SampleType of “Result”. Grain Size Parameter Codes: The Gravel2m code is the percentage of the sediment sample retained on a 2-mm sieve. If no sediments are retained, the value will be zero. The other parameter codes refer to the percentage of sample in the size range. These data should not be adjusted for material retained on the sieve. Optional parameter codes to describe the statistical properties of the laser analyzer are included and may be reported. Default unit is percent under phi size. (check with infauna group microns vs phi) Units: Values expressed in parts per billion will carry the unit tag of UG/KG (organics). Values expressed in parts per million will carry the unit tag of MG/KG (metals). TABLE GUIDELINES:
EXAMPLE DATA: Table Structure: tblChemistryResults
**************************************************************************************************** |