PLD

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
periods 1984   1 366 e
sampler_height 1984   0.5 30 w
sampler_surface 1984   0.025 0.5 w

temporal tests

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

multiple tests

RULE_ID TEST ERROR
707 date_monitoring_first <= date_monitoring_last e
708 altitude = altitude w
709 latitude = latitude w
710 longitude = longitude w
711 (period IN (periods)) AND NOT (periods = COUNT period) w
712 (period IN (periods)) AND NOT (periods >= COUNT period) e
784 EXIST(sampler_id) e
3010 EXIST(plot) e
3207 LENGTH(latitude) = 7 AND latitude LIKE('+%') e
3208 LENGTH(longitude) = 7 AND (longitude LIKE('+%') OR longitude LIKE('-%')) e
RULE_ID MSG
707 specified date_monitoring_first VALUE must not smaller than specified date_monitoring_last VALUE
708 DP_altitude VALUE is not the same as in GENER.PLT
709 DP_latitude VALUE is not the same as in GENER.PLT (VALUE).
710 DP_longitude VALUE is not the same as in GENER.PLT (VALUE).
711 number of periods/records for this sample_ID in data file (DEM) does not match with that in plot file
712 more periods/records for this sampler in data file DEM than specified in plot file
784 Sampler_ID VALUE not specified in DEM file
3010 plot VALUE is not registered in the system instalment
3207 latitude(VALUE) has to be submitted in a 7 digits format (+DDMMSS) with leading '+'
3208 longitude(VALUE) has to be submitted in a 7 digits format (+/-DDMMSS) with leading '+/-'


DEM

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
Al 1984   0.001 8 w
Al 1984   0 10 e
alkalinity 1984   -50 10000 w
Ca 1984   0.001 275 w
Ca 1984   0.0001 100000 e
Cl 1984   0.002 800 w
Cl 1984   0.0001 100000 e
Co 1984   0.008 100 w
Co 1984   0.0001 10000 e
conductivity 1984   1 10000 w
cr 1984   0.008 100 w
cr 1984   0.0001 10000 e
Cu 1984   0.06 850 w
Cu 1984   0.0001 10000 e
DOC 1984   0.001 100 w
DOC 1984   0.0001 1000 e
don 1984   0.001 100 w
don 1984   0.0001 1000 e
Fe 1984   0 25 w
Fe 1984   0 100 e
hco3 1984   0 500 w
hco3 1984   0 10000 e
Hg 1984   0.02 100 w
Hg 1984   0.0001 10000 e
K 1984   0.002 250 w
K 1984   0.001 10000 e
Mg 1984   0.0025 100 w
Mg 1984   0.0001 100000 e
Mn 1984   0 15.5 w
Mn 1984   0 100 e
Mo 1984   0.008 100 w
Mo 1984   0.0001 10000 e
Na 1984   0.003 500 w
Na 1984   0.0001 100000 e
N_NH4 1984   0.002 175 w
N_NH4 1984   0.001 100000 e
N_NO3 1984   0.002 175 w
N_NO3 1984   0.0001 100000 e
no2_n 1984   0.002 175 w
no2_n 1984   0.0001 100000 e
N_total 1984   0.03 350 w
N_total 1984   0.0001 100000 e
Pb 1984   0.012 200 w
Pb 1984   0.0001 10000 e
period 1984   1 53 w
pH 1984   2.5 9.4 w
pH 1984   1 14 e
P_PO4 1984   0.0017 1000 w
P_PO4 1984   0.0001 10000 e
p_total 1984   0.0017 1000 w
p_total 1984   0.0001 10000 e
S_SO4 1984   0.01 500 w
S_SO4 1984   0.0001 100000 e
S_total 1984   0.17 500 w
S_total 1984   0.0001 10000 e
Zn 1984   0.005 4500 w
Zn 1984   0.0001 10000 e

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
715 (N_total * 1.05) >= (N_NH4 + N_NO3) w
716 (((Na IS NOT NULL) AND (Na <> -1) AND (Cl IS NOT NULL) AND (Cl <> -1)) ) AND NOT (((((Na / 22.99) / (Cl / 35.453)) > 0.4) AND (((Na / 22.99) / (Cl / 35.453)) < 4.0))) w
717 date_start <= date_end e
718 (quantity = 0) AND NOT (pH IS NULL) w
783 EXIST(sampler_id) e
830 (quantity IS NULL) AND NOT (V_sampling NOT IN (1,5,6,7,8,9 )) e
986 ((pH IS NOT NULL) AND (pH >= 0) AND (conductivity IS NOT NULL) AND (conductivity > 0) AND (K IS NOT NULL) AND (K > 0) AND (Ca IS NOT NULL) AND (Ca > 0)AND (Mg IS NOT NULL) AND (Mg > 0)AND (Na IS NOT NULL) AND (Na > 0) AND (N_NH4 IS NOT NULL) AND (N_NH4 > 0)AND (Cl IS NOT NULL) AND (Cl > 0) AND (N_NO3 IS NOT NULL) AND (N_NO3 > 0) AND (alkalinity IS NOT NULL) AND (S_SO4 IS NOT NULL) AND (S_SO4 > 0)AND (N_total IS NOT NULL) AND (N_total > 0)) AND NOT (ref.fm_test_conduct_dem(pH, conductivity, Ca, Mg, Na, K, N_NH4,S_SO4, N_NO3, Cl, alkalinity) = 0) w
RULE_ID MSG
715 sum of N_NH4 VALUE and N_NO3 VALUE greater than N_total VALUE
716 ratio between Na and Cl not between 0.4 and 4.0
717 specified date_start VALUE must not smaller than specified date_end VALUE
718 specified pH VALUE does not match with specified quantity VALUE
783 Sampler_ID VALUE not specified in PLD file
830 specified V_Sampling VALUE does not match with not specified value for Quantity (NULL value)
986 Submitted value for conductivity VALUE does not fit with calculated value VALUE


LQA

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
control_chart_std 1984   0 100 e

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
215 date_start <= date_end e
556 (parameter NOT IN ('pH', 'Alkalin', 'DOC', 'Cond')) AND NOT (control_chart_mean IS NOT NULL) w
557 (parameter IN ('pH', 'DOC', 'Cond')) AND NOT (control_chart_mean IS NOT NULL) w
558 (parameter NOT IN ('pH', 'Alkalin', 'DOC', 'Cond')) AND NOT (control_chart_std IS NOT NULL) w
559 (parameter IN ('pH', 'DOC', 'Cond')) AND NOT (control_chart_std IS NOT NULL) w
560 (parameter NOT IN ('pH', 'Alkalin', 'Cond')) AND NOT (quantification_limit IS NOT NULL) e
912 quantification_limit > 0 e
918 control_chart_mean > 0 e
942 (parameter NOT IN ('pH')) AND NOT (control_chart_std between 0.5 and 10) w
948 control_chart_std > 0 e
1002 (parameter='Alkalin') AND NOT (quantification_limit between 0.1 and 10) w
1003 (parameter='N_NH4') AND NOT (quantification_limit between 0.0008 and 0.08) w
1004 (parameter='Ca') AND NOT (quantification_limit between 0.002 and 0.2) w
1005 (parameter='Cl') AND NOT (quantification_limit between 0.002 and 0.2) w
1006 (parameter='Cond') AND NOT (quantification_limit between 0.05 and 5) w
1007 (parameter='DOC') AND NOT (quantification_limit between 0.01 and 1) w
1008 (parameter='Mg') AND NOT (quantification_limit between 0.001 and 0.1) w
1009 (parameter='N_NO3') AND NOT (quantification_limit between 0.0008 and 0.08) w
1010 (parameter='P') AND NOT (quantification_limit between 0.001 and 0.1) w
1011 (parameter='P_PO4') AND NOT (quantification_limit between 0.001 and 0.1) w
1012 (parameter='K') AND NOT (quantification_limit between 0.004 and 0.4) w
1013 (parameter='Na') AND NOT (quantification_limit between 0.001 and 0.1) w
1014 (parameter='S_SO4') AND NOT (quantification_limit between 0.001 and 0.1) w
1015 (parameter='N_total') AND NOT (quantification_limit between 0.005 and 0.5) w
1016 (parameter='Al') AND NOT (quantification_limit between 0.001 and 10000) e
1017 (parameter='Fe') AND NOT (quantification_limit between 0.0001 and 100000) e
1018 (parameter='Mn') AND NOT (quantification_limit between 0 and 100000) e
1090 (parameter='Alkalin') AND NOT (control_chart_mean between 25 and 200) w
1091 (parameter='N_NH4') AND NOT (control_chart_mean between 0.2 and 5) w
1092 (parameter='Ca') AND NOT (control_chart_mean between 0.2 and 10) w
1093 (parameter='Cl') AND NOT (control_chart_mean between 0.2 and 20) w
1094 (parameter='Cond') AND NOT (control_chart_mean between 25 and 200) w
1095 (parameter='DOC') AND NOT (control_chart_mean between 2 and 30) w
1096 (parameter='Mg') AND NOT (control_chart_mean between 0.2 and 20) w
1097 (parameter='N_NO3') AND NOT (control_chart_mean between 0.2 and 20) w
1098 (parameter='pH') AND NOT (control_chart_mean between 4 and 9) w
1099 (parameter='P') AND NOT (control_chart_mean between 0.2 and 5) w
1100 (parameter='P_PO4') AND NOT (control_chart_mean between 0.2 and 5) w
1101 (parameter='K') AND NOT (control_chart_mean between 1 and 20) w
1102 (parameter='Na') AND NOT (control_chart_mean between 0.2 and 20) w
1103 (parameter='S_SO4') AND NOT (control_chart_mean between 0.2 and 25) w
1104 (parameter='N_total') AND NOT (control_chart_mean between 1 and 20) w
1105 (parameter='Al') AND NOT (control_chart_mean between 0.2 and 20) w
1106 (parameter='Fe') AND NOT (control_chart_mean between 0.2 and 20) w
1107 (parameter='Mn') AND NOT (control_chart_mean between 0.2 and 20) w
1172 (parameter NOT IN ('pH')) AND NOT (quantification_limit IS NOT NULL) w
1178 control_chart_mean IS NOT NULL w
1184 control_chart_std IS NOT NULL w
1190 Laboratory_ID IS NOT NULL w
1193 (parameter IN ('pH')) AND NOT (control_chart_std between 0.1 and 10) w
RULE_ID MSG
215 specified date_start VALUE must not smaller than specified date_end VALUE
556 control_chart_mean is Null, which is not expected for parameter VALUE
557 control_chart_mean is Null, which is not expected for parameter VALUE
558 control_chart_std is Null, which is not expected for parameter VALUE
559 control_chart_std is Null, which is not expected for parameter VALUE
560 quantification_limit is Null, which is not expected for parameter VALUE
912 Quantification limit must not be <= 0 where parameter is VALUE
918 Control chart mean must not be <= 0 where parameter is VALUE
942 Control chart std VALUE not in range between 0.5 and 10 for VALUE
948 Control chart std must not be <= 0 where parameter is VALUE
1002 Quantification limit VALUE not in range between 0.1 and 10 for Parameter Alkalin
1003 Quantification limit VALUE not in range between 0.0008 and 0.08 for Parameter N_NH4
1004 Quantification limit VALUE not in range between 0.002 and 0.2 for Parameter Ca
1005 Quantification limit VALUE not in range between 0.002 and 0.2 for Parameter Cl
1006 Quantification limit VALUE not in range between 0.05 and 5 for Parameter Cond
1007 Quantification limit VALUE not in range between 0.01 and 1 for Parameter DOC
1008 Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter Mg
1009 Quantification limit VALUE not in range between 0.0008 and 0.08 for Parameter N_NO3
1010 Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter P
1011 Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter P_PO4
1012 Quantification limit VALUE not in range between 0.004 and 0.4 for Parameter K
1013 Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter Na
1014 Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter S_SO4
1015 Quantification limit VALUE not in range between 0.005 and 0.5 for Parameter N_total
1016 Quantification limit VALUE not in range between 0.001 and 10000 for Parameter Al
1017 Quantification limit VALUE not in range between 0.0001 and 100000 for Parameter Fe
1018 Quantification limit VALUE not in range between 0 and 100000 for Parameter Mn
1090 Control chart mean VALUE not in range between 25 and 200 for Parameter Alkalin
1091 Control chart mean VALUE not in range between 0.2 and 5 for Parameter N_NH4
1092 Control chart mean VALUE not in range between 0.2 and 10 for Parameter Ca
1093 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Cl
1094 Control chart mean VALUE not in range between 25 and 200 for Parameter Cond
1095 Control chart mean VALUE not in range between 2 and 30 for Parameter DOC
1096 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Mg
1097 Control chart mean VALUE not in range between 0.2 and 20 for Parameter N_NO3
1098 Control chart mean VALUE not in range between 4 and 9 for Parameter pH
1099 Control chart mean VALUE not in range between 0.2 and 5 for Parameter P
1100 Control chart mean VALUE not in range between 0.2 and 5 for Parameter P_PO4
1101 Control chart mean VALUE not in range between 1 and 20 for Parameter K
1102 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Na
1103 Control chart mean VALUE not in range between 0.2 and 25 for Parameter S_SO4
1104 Control chart mean VALUE not in range between 1 and 20 for Parameter N_total
1105 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Al
1106 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Fe
1107 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Mn
1172 Value of Quantification limit is missing
1178 Value of Control chart mean is missing
1184 Value of Control chart std is missing
1190 Value of Laboratory ID is missing
1193 Control chart std VALUE not in range between 0.1 and 10 for Parameter pH