SO - Sampling and Analysis of Soil - Level II

Form: LQA - Soil analysis - Laboratory QA/QC information

Form introduced: 2009

Last change: 2009

Tests

Changes

!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