SO - Sampling and Analysis of Soil - Level II
Form: LQA - Soil analysis - Laboratory QA/QC information
Form introduced: 2009
Last change: 2009
!Sequence; country; plot; date_start; date_end; parameter; pretreatment; sample_preparation; determination; quantification_limit; control_chart_mean; control_chart_std; Laboratory_ID; other_observations
| POSITION | FIELD | DESCRIPTION |
|---|---|---|
| 1 | Sequence |
Description: Continuous number to identify the line of the submitted file Format: I |
| 2 | country M |
DB Column: code_country Description: ID of the country Format: I Dictionary: d_country |
| 3 | plot M |
DB Column: code_plot Description: Observation plot number Remarks: A unique number (per country) given to the permanent plot during the selection or installation Format: I |
| 4 | date_start (DDMMYY) M K |
Description: Start date Remarks: E.g. ‘9th October 2012’ = ‘091012’ Format: Date Explanatory Item: 190 |
| 5 | date_end (DDMMYY) M |
Description: End date Remarks: E.g. ‘9th October 2012’ = ‘091012’ Format: Date Explanatory Item: 190 |
| 6 | parameter M K |
DB Column: code_parameter Description: Parameter code Format: C Dictionary: d_parameter_so |
| 7 | pretreatment |
DB Column: code_pretreatment Description: Pretreatment method Format: C Dictionary: d_pretreatment_so |
| 8 | sample_preparation |
DB Column: code_sample_prep Description: Sample preparation method Format: C Dictionary: d_sample_prep_so |
| 9 | determination M K |
DB Column: code_determination Description: Determination method Format: C Dictionary: d_determination_so |
| 10 | quantification_limit (unit of parameter) |
Description: Quantification limit Format: F Explanatory Item: 182 |
| 11 | control_chart_mean |
Description: Mean of control chart Missing value (NULL): -9 Format: F Explanatory Item: 182 |
| 12 | control_chart_std (%) |
Description: Standard deviation Missing value (NULL): -9 Remarks: [% of mean] => coefficient of variation Format: F Explanatory Item: 182 |
| 13 | Laboratory_ID |
Description: Laboratory ID Remarks: E.g. ‘H45’ or ‘B78’ Format: C Explanatory Item: 183 |
| 14 | other_observations (FREE TEXT) |
DB Column: other_obs Description: Supplementary comments Format: C |