LFM

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
area 2011   0.05 10 w
Arsenic 2011   5 1000 w
B 2011   0.001 1000 e
C 2011   45 58 w
C 2011   10 100 e
Ca 2011   0.001 1000 e
Cd 2011   25 750 w
Cd 2011   0.001 5000 e
Co 2011   0.03 20 w
Cr 2011   0.1 30 w
Cu 2011   0.001 10000 e
dry_mass 2011   2 50 w
dry_weight_70 2011   0.001 10 w
Fe 2011   0.001 10000 e
Hg 2011   5 500 w
K 2011   0.001 1000 e
Mg 2011   0.001 1000 e
Mn 2011   0.001 10000 e
N 2011   0.001 1000 e
Ni 2011   0.2 20 w
P 2011   0.001 1000 e
Pb 2011   0.5 25 w
Pb 2011   0.001 1000 e
S 2011   0.001 1000 e
Zn 2011   0.001 1000 e

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
752 date_start <= date_end e
753 (C*10+N+S+P+Ca+Mg+K) <= 1000 e
754 (sample IN (11, 11.1, 11.2)) AND NOT (dry_mass IS NOT NULL) w
755 (sample IN (11, 11.1, 11.2)) AND NOT (area IS NOT NULL) w
756 (sample IN (11, 11.1, 11.2)) AND NOT (N BETWEEN 5 AND 21) w
757 (sample IN (11, 11.1, 11.2)) AND NOT (S BETWEEN 0.6 AND 2.2) w
758 (sample IN (11, 11.1, 11.2)) AND NOT (P BETWEEN 0.2 AND 2.0) w
759 (sample IN (11, 11.1, 11.2)) AND NOT (Ca BETWEEN 2.0 AND 25) w
760 (sample IN (11, 11.1, 11.2)) AND NOT (Mg BETWEEN 0.5 AND 3.5) w
761 (sample IN (11, 11.1, 11.2)) AND NOT (K BETWEEN 0.2 AND 8.3) w
766 (sample IN (11, 11.1, 11.2)) AND NOT (Zn BETWEEN 15 AND 130) w
767 (sample IN (11, 11.1, 11.2)) AND NOT (Mn BETWEEN 180 AND 2500) w
768 (sample IN (11, 11.1, 11.2)) AND NOT (Fe BETWEEN 35 AND 300) w
769 (sample IN (11, 11.1, 11.2)) AND NOT (Cu BETWEEN 1 AND 10) w
770 (sample IN (11, 11.1, 11.2)) AND NOT (B BETWEEN 2 AND 45) w
771 (sample NOT IN (11, 11.1, 11.2)) AND NOT (Zn BETWEEN 4 AND 500) w
772 (sample NOT IN (11, 11.1, 11.2)) AND NOT (Mn BETWEEN 5 AND 5000) w
773 (sample NOT IN (11, 11.1, 11.2)) AND NOT (Fe BETWEEN 45 AND 450) w
774 (sample NOT IN (11, 11.1, 11.2)) AND NOT (B BETWEEN 4 AND 60) w
775 (sample NOT IN (11, 11.1, 11.2)) AND NOT (Cu BETWEEN 2 AND 21) w
980 (sample NOT IN (11, 11.1, 11.2)) AND NOT (Ca BETWEEN 1.5 AND 22) w
981 (sample NOT IN (11, 11.1, 11.2)) AND NOT (K BETWEEN 0.4 AND 5.5) w
982 (sample NOT IN (11, 11.1, 11.2)) AND NOT (Mg BETWEEN 0.45 AND 2) w
983 (sample NOT IN (11, 11.1, 11.2)) AND NOT (N BETWEEN 5 AND 21) w
984 (sample NOT IN (11, 11.1, 11.2)) AND NOT (P BETWEEN 0.2 AND 1.8) w
985 (sample NOT IN (11, 11.1, 11.2)) AND NOT (S BETWEEN 0.6 AND 2.2) w
RULE_ID MSG
752 specified date_start VALUE must not smaller than specified date_end VALUE
753 sum of C, N, S, P, Ca, Mg and K is too high
754 dry_mass is Null, which is not expected for sample VALUE
755 area is Null, which is not expected for sample VALUE
756 N VALUE not in range between 5 and 21
757 S VALUE not in range between 0.6 and 2.2
758 P VALUE not in range between 0.2 and 2
759 Ca VALUE not in range between 2.0 and 25
760 Mg VALUE not in range between 0.5 and 3.5
761 K VALUE not in range between 0.2 and 8.3
766 Zn VALUE not in range between 15 and 150
767 Mn VALUE not in range between 180 and 2500
768 Fe VALUE not in range between 35 and 300
769 Cu VALUE not in range between 1 and 10
770 B VALUE not in range between 2 and 45
771 Zn VALUE not in range between 4 and 500
772 Mn VALUE not in range between 5 and 5000
773 Fe VALUE not in range between 45 and 450
774 B VALUE not in range between 40 and 60
775 Cu VALUE not in range between 2 and 21
980 Ca VALUE not in range between 1.5 and 22
981 K VALUE not in range between 0.4 and 5.5
982 Mg VALUE not in range between 0.45 and 2
983 N VALUE not in range between 5 and 21
984 P VALUE not in range between 0.2 and 1.8
985 S VALUE not in range between 0.6 and 2.2


LFP

range tests

no tests available

temporal tests

RULE_ID TEST ERROR
37 longitude = longitude_t-1 w
70 latitude = latitude_t-1 w
RULE_ID MSG MSG_CODE
37 longitude VALUE does not match with value VALUE from previous year TT_NOT_MATCH
70 latitude VALUE does not match with value VALUE from previous year TT_NOT_MATCH

multiple tests

RULE_ID TEST ERROR
275 date_monitoring_first < date_monitoring_last e
375 altitude = altitude w
437 latitude = latitude w
438 longitude = longitude w
3001 EXIST(plot) e
3229 LENGTH(latitude) = 7 AND latitude LIKE('+%') e
3230 LENGTH(longitude) = 7 AND (longitude LIKE('+%') OR longitude LIKE('-%')) e
RULE_ID MSG
275 specified date_monitoring_first VALUE must not smaller than specified date_monitoring_last VALUE
375 LF_altitude VALUE is not the same as in GENER.PLT
437 LF_latitude VALUE is not the same as in GENER.PLT (VALUE).
438 LF_longitude VALUE is not the same as in GENER.PLT (VALUE).
3001 plot VALUE is not registered in the system instalment
3229 latitude(VALUE) has to be submitted in a 7 digits format (+DDMMSS) with leading '+'
3230 longitude(VALUE) has to be submitted in a 7 digits format (+/-DDMMSS) with leading '+/-'


LQA

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
control_chart_std 2009   0.5 10 w
control_chart_std 2009   0 100 e

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
281 date_start <= date_end e
915 control_chart_mean > 0 e
923 (parameter='B') AND NOT (quantification_limit between 0.01 and 1) w
924 (parameter='Cd') AND NOT (quantification_limit between 0.5 and 50) w
925 (parameter='Ca') AND NOT (quantification_limit between 0.005 and 0.5) w
926 (parameter='C') AND NOT (quantification_limit between 0.1 and 10) w
927 (parameter='Cu') AND NOT (quantification_limit between 0.01 and 1) w
928 (parameter='Fe') AND NOT (quantification_limit between 0.05 and 5) w
929 (parameter='Pb') AND NOT (quantification_limit between 0.005 and 0.5) w
930 (parameter='Mg') AND NOT (quantification_limit between 0.003 and 0.3) w
931 (parameter='Mn') AND NOT (quantification_limit between 0.05 and 5) w
932 (parameter='N') AND NOT (quantification_limit between 0.02 and 2) w
933 (parameter='P') AND NOT (quantification_limit between 0.003 and 0.3) w
934 (parameter='K') AND NOT (quantification_limit between 0.005 and 0.5) w
935 (parameter='S') AND NOT (quantification_limit between 0.003 and 0.3) w
936 (parameter='Zn') AND NOT (quantification_limit between 0.05 and 5) w
937 quantification_limit > 0 e
939 control_chart_std between 0.5 and 10 w
945 control_chart_std > 0 e
965 (parameter='B') AND NOT (control_chart_mean between 5 and 50) w
966 (parameter='Cd') AND NOT (control_chart_mean between 25 and 400) w
967 (parameter='Ca') AND NOT (control_chart_mean between 1 and 15) w
968 (parameter='C') AND NOT (control_chart_mean between 45 and 57) w
969 (parameter='Cu') AND NOT (control_chart_mean between 1 and 15) w
970 (parameter='Fe') AND NOT (control_chart_mean between 20 and 300) w
971 (parameter='Pb') AND NOT (control_chart_mean between 0.15 and 15) w
972 (parameter='Mg') AND NOT (control_chart_mean between 0.4 and 3) w
973 (parameter='Mn') AND NOT (control_chart_mean between 30 and 4000) w
974 (parameter='N') AND NOT (control_chart_mean between 6 and 30) w
975 (parameter='P') AND NOT (control_chart_mean between 0.4 and 2.5) w
976 (parameter='K') AND NOT (control_chart_mean between 2 and 13) w
977 (parameter='S') AND NOT (control_chart_mean between 0.5 and 2.4) w
978 (parameter='Zn') AND NOT (control_chart_mean between 10 and 100) w
1169 quantification_limit IS NOT NULL w
1175 control_chart_mean IS NOT NULL w
1181 control_chart_std IS NOT NULL w
1187 Laboratory_ID IS NOT NULL w
RULE_ID MSG
281 specified date_start VALUE must not smaller than specified date_end VALUE
915 Control chart mean must not be <= 0 where parameter is VALUE
923 Quantification limit VALUE not in range between 0.01 and 1 for Parameter B
924 Quantification limit VALUE not in range between 0.5 and 50 for Parameter Cd
925 Quantification limit VALUE not in range between 0.005 and 0.5 for Parameter Ca
926 Quantification limit VALUE not in range between 0.1 and 10 for Parameter C
927 Quantification limit VALUE not in range between 0.01 and 1 for Parameter Cu
928 Quantification limit VALUE not in range between 0.05 and 5 for Parameter Fe
929 Quantification limit VALUE not in range between 0.005 and 0.5 for Parameter Pb
930 Quantification limit VALUE not in range between 0.003 and 0.3 for Parameter Mg
931 Quantification limit VALUE not in range between 0.05 and 5 for Parameter Mn
932 Quantification limit VALUE not in range between 0.02 and 2 for Parameter N
933 Quantification limit VALUE not in range between 0.003 and 0.3 for Parameter P
934 Quantification limit VALUE not in range between 0.005 and 0.5 for Parameter K
935 Quantification limit VALUE not in range between 0.003 and 0.3 for Parameter S
936 Quantification limit VALUE not in range between 0.05 and 5 for Parameter Zn
937 Quantification limit must not be <= 0 where parameter is VALUE
939 Control chart std VALUE not in range between 0.5 and 10 for VALUE
945 Control chart std must not be <= 0 where parameter is VALUE
965 Control chart mean VALUE not in range between 5 and 50 for Parameter B
966 Control chart mean VALUE not in range between 25 and 400 for Parameter Cd
967 Control chart mean VALUE not in range between 1 and 15 for Parameter Ca
968 Control chart mean VALUE not in range between 45 and 57 for Parameter C
969 Control chart mean VALUE not in range between 1 and 15 for Parameter Cu
970 Control chart mean VALUE not in range between 20 and 300 for Parameter Fe
971 Control chart mean VALUE not in range between 0.15 and 15 for Parameter Pb
972 Control chart mean VALUE not in range between 0.4 and 3 for Parameter Mg
973 Control chart mean VALUE not in range between 30 and 4000 for Parameter Mn
974 Control chart mean VALUE not in range between 6 and 30 for Parameter N
975 Control chart mean VALUE not in range between 0.4 and 2.5 for Parameter P
976 Control chart mean VALUE not in range between 2 and 13 for Parameter K
977 Control chart mean VALUE not in range between 0.5 and 2.4 for Parameter S
978 Control chart mean VALUE not in range between 10 and 100 for Parameter Zn
1169 Value of Quantification limit is missing
1175 Value of Control chart mean is missing
1181 Value of Control chart std is missing
1187 Value of Laboratory ID is missing