PSS

range tests

no tests available

temporal tests

RULE_ID TEST ERROR
243 longitude = longitude_t-1 w
244 latitude = latitude_t-1 w
245 (layer = layer_t-1) WHERE ((sampler_id = sampler_id_t-1)) e
246 (sampler_type = sampler_type_t-1) WHERE ((sampler_id = sampler_id_t-1)) w
RULE_ID MSG MSG_CODE
243 longitude VALUE does not match with value VALUE from previous year TT_NOT_MATCH
244 latitude VALUE does not match with value VALUE from previous year TT_NOT_MATCH
245 layer VALUE must not change over time for each combination of country, plot, and sampler_ID TT_NOT_CHANGE_ID1
246 sampler_type VALUE must not change over time for each combination of country, plot, and sampler_ID TT_NOT_CHANGE_ID1

multiple tests

RULE_ID TEST ERROR
685 (period IN (periods)) AND NOT (periods = COUNT period) w
686 (period IN (periods)) AND NOT (periods >= COUNT period) e
687 (period IN (periods)) AND NOT (periods = COUNT period) w
688 (period IN (periods)) AND NOT (periods >= COUNT period) e
689 date_monitoring_first <= date_monitoring_last e
690 altitude = altitude w
691 latitude = latitude w
692 longitude = longitude w
780 EXIST(sampler_id) e
782 EXIST(sampler_id) w
3012 EXIST(plot) e
3249 LENGTH(latitude) = 7 AND latitude LIKE('+%') e
3250 LENGTH(longitude) = 7 AND (longitude LIKE('+%') OR longitude LIKE('-%')) e
RULE_ID MSG
685 number of periods/records for this sample_ID in data file (SSM) does not match with that in plot file
686 more periods/records for this sampler in data file SSM than specified in plot file
687 number of periods/records for this sample_ID in data file (SSO) does not match with that in plot file
688 more periods/records for this sampler in data file SSO than specified in plot file
689 specified date_monitoring_first VALUE must not smaller than specified date_monitoring_last VALUE
690 SS_altitude #SS_altitude# is not the same as in GENER.PLT
691 SS_latitude VALUE is not the same as in GENER.PLT (VALUE).
692 SS_longitude VALUE is not the same as in GENER.PLT (VALUE).
780 Sampler_ID VALUE not specified in SSM file
782 Sampler_ID VALUE not specified in SSO file
3012 plot VALUE is not registered in the system instalment
3249 latitude(VALUE) has to be submitted in a 7 digits format (+DDMMSS) with leading '+'
3250 longitude(VALUE) has to be submitted in a 7 digits format (+/-DDMMSS) with leading '+/-'


SSM

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
Al 2011   0.001 500 w
Al 2011   0.0001 100000 e
alkalinity 2011   0 27500 w
Ca 2011   0.005 75 w
Ca 2011   0.0001 100000 e
Cl 2011   0.01 400 w
Cl 2011   0.0001 100000 e
conductivity 2011   1 10000 w
DOC 2011   0.001 600 w
DOC 2011   0.0001 100000 e
Fe 2011   0.0003 500 w
Fe 2011   0.0001 100000 e
K 2011   0.001 30 w
K 2011   0.0001 100000 e
Mg 2011   0.01 15 w
Mg 2011   0.0001 100000 e
Mn 2011   0.001 300 w
Mn 2011   0.0001 100000 e
Na 2011   0.02 22.5 w
Na 2011   0.0001 100000 e
N_NH4 2011   0.0008 75 w
N_NH4 2011   0.0001 100000 e
N_NO3 2011   0.001 300 w
N_NO3 2011   0.0001 100000 e
pH 2011   3.5 8.5 w
pH 2011   1 14 e
S_SO4 2011   0.01 1250 w
S_SO4 2011   0.0001 100000 e
total_nitrogen 2011   0.001 400 w
total_nitrogen 2011   0.0001 100000 e

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
693 date_start <= date_end e
779 EXIST(sampler_id) e
979 (total_nitrogen * 1.05) >= (N_NH4 + N_NO3) w
987 ((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 NOT (ref.fm_test_conduct_ssm_sso(pH, conductivity, Ca, Mg, Na, K, N_NH4,S_SO4, N_NO3, Cl, alkalinity) = 0) w
RULE_ID MSG
693 specified date_start VALUE must not smaller than specified date_end VALUE
779 Sampler_ID VALUE not specified in PSS file
979 sum of N_NH4 VALUE and N_NO3 VALUE greater than N_total VALUE
987 Submitted value for conductivity VALUE does not fit with calculated value VALUE


SSO

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
Al_labile 2011   0.001 300 w
Al_labile 2011   0.0001 100000 e
Cr 2011   0.04 100 w
Cr 2011   0.0001 100000 e
Cu 2011   0.05 1000 w
Cu 2011   0.001 10000 e
Ni 2011   0.001 1500 w
Ni 2011   0.0001 100000 e
P 2011   0.001 12.5 w
P 2011   0.0001 100000 e
Pb 2011   0.02 5000 w
Pb 2011   0.001 10000 e
Si 2011   0.005 200 w
Si 2011   0.0001 100000 e
Zn 2011   0.01 1000 w
Zn 2011   0.001 10000 e

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
694 date_start <= date_end e
781 EXIST(sampler_id) e
RULE_ID MSG
694 specified date_start VALUE must not smaller than specified date_end VALUE
781 Sampler_ID VALUE not specified in PSS file


LQA

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
control_chart_std 2009   0 100 e

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
160 date_start <= date_end e
551 (parameter NOT IN ('pH', 'Alkalin', 'DOC', 'Cond')) AND NOT (control_chart_mean IS NOT NULL) w
552 (parameter IN ('pH', 'Alkalin', 'DOC', 'Cond')) AND NOT (control_chart_mean IS NOT NULL) w
553 (parameter NOT IN ('pH', 'Alkalin', 'DOC', 'Cond')) AND NOT (control_chart_std IS NOT NULL) w
554 (parameter IN ('pH', 'Alkalin', 'DOC', 'Cond')) AND NOT (control_chart_std IS NOT NULL) w
555 (parameter NOT IN ('pH', 'Alkalin', 'Cond')) AND NOT (quantification_limit IS NOT NULL) e
911 quantification_limit > 0 e
917 control_chart_mean > 0 e
941 control_chart_std between 0.5 and 10 w
947 control_chart_std > 0 e
1019 (parameter='Alkalin') AND NOT (quantification_limit between 0.1 and 10) w
1020 (parameter='N_NH4') AND NOT (quantification_limit between 0.0008 and 0.08) w
1021 (parameter='Ca') AND NOT (quantification_limit between 0.002 and 0.2) w
1022 (parameter='Cl') AND NOT (quantification_limit between 0.002 and 0.2) w
1023 (parameter='Cond') AND NOT (quantification_limit between 0.05 and 5) w
1024 (parameter='DOC') AND NOT (quantification_limit between 0.01 and 1) w
1025 (parameter='Mg') AND NOT (quantification_limit between 0.001 and 0.1) w
1026 (parameter='N_NO3') AND NOT (quantification_limit between 0.0008 and 0.08) w
1027 (parameter='P') AND NOT (quantification_limit between 0.001 and 0.1) w
1028 (parameter='P_PO4') AND NOT (quantification_limit between 0.001 and 0.1) w
1029 (parameter='K') AND NOT (quantification_limit between 0.004 and 0.4) w
1030 (parameter='Na') AND NOT (quantification_limit between 0.001 and 0.1) w
1031 (parameter='S_SO4') AND NOT (quantification_limit between 0.001 and 0.1) w
1032 (parameter='N_total') AND NOT (quantification_limit between 0.005 and 0.5) w
1033 (parameter='Al') AND NOT (quantification_limit between 0.0025 and 0.05) w
1034 (parameter='Fe') AND NOT (quantification_limit between 0.0025 and 0.05) w
1035 (parameter='Mn') AND NOT (quantification_limit between 0.0025 and 0.05) w
1108 (parameter='Alkalin') AND NOT (control_chart_mean between 25 and 200) w
1109 (parameter='N_NH4') AND NOT (control_chart_mean between 0.2 and 5) w
1110 (parameter='Ca') AND NOT (control_chart_mean between 0.2 and 10) w
1111 (parameter='Cl') AND NOT (control_chart_mean between 0.2 and 20) w
1112 (parameter='Cond') AND NOT (control_chart_mean between 25 and 200) w
1113 (parameter='DOC') AND NOT (control_chart_mean between 2 and 30) w
1114 (parameter='Mg') AND NOT (control_chart_mean between 0.2 and 20) w
1115 (parameter='N_NO3') AND NOT (control_chart_mean between 0.2 and 20) w
1116 (parameter='pH') AND NOT (control_chart_mean between 4 and 9) w
1117 (parameter='P') AND NOT (control_chart_mean between 0.2 and 5) w
1118 (parameter='P_PO4') AND NOT (control_chart_mean between 0.2 and 5) w
1119 (parameter='K') AND NOT (control_chart_mean between 1 and 20) w
1120 (parameter='Na') AND NOT (control_chart_mean between 0.2 and 20) w
1121 (parameter='S_SO4') AND NOT (control_chart_mean between 0.2 and 25) w
1122 (parameter='N_total') AND NOT (control_chart_mean between 1 and 20) w
1123 (parameter='Al') AND NOT (control_chart_mean between 0.2 and 20) w
1124 (parameter='Fe') AND NOT (control_chart_mean between 0.2 and 20) w
1125 (parameter='Mn') AND NOT (control_chart_mean between 0.2 and 20) w
1171 (parameter NOT IN ('pH')) AND NOT (quantification_limit IS NOT NULL) w
1177 control_chart_mean IS NOT NULL w
1183 control_chart_std IS NOT NULL w
1189 Laboratory_ID IS NOT NULL w
RULE_ID MSG
160 specified date_start VALUE must not smaller than specified date_end VALUE
551 control_chart_mean is Null, which is not expected for parameter VALUE
552 control_chart_mean is Null, which is not expected for parameter VALUE
553 control_chart_std is Null, which is not expected for parameter VALUE
554 control_chart_std is Null, which is not expected for parameter VALUE
555 quantification_limit is Null, which is not expected for parameter VALUE
911 Quantification limit must not be <= 0 where parameter is VALUE
917 Control chart mean must not be <= 0 where parameter is VALUE
941 Control chart std VALUE not in range between 0.5 and 10 for VALUE
947 Control chart std must not be <= 0 where parameter is VALUE
1019 Quantification limit VALUE not in range between 0.1 and 10 for Parameter Alkalin
1020 Quantification limit VALUE not in range between 0.0008 and 0.08 for Parameter N_NH4
1021 Quantification limit VALUE not in range between 0.002 and 0.2 for Parameter Ca
1022 Quantification limit VALUE not in range between 0.002 and 0.2 for Parameter Cl
1023 Quantification limit VALUE not in range between 0.05 and 5 for Parameter Cond
1024 Quantification limit VALUE not in range between 0.01 and 1 for Parameter DOC
1025 Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter Mg
1026 Quantification limit VALUE not in range between 0.0008 and 0.08 for Parameter N_NO3
1027 Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter P
1028 Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter P_PO4
1029 Quantification limit VALUE not in range between 0.004 and 0.4 for Parameter K
1030 Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter Na
1031 Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter S_SO4
1032 Quantification limit VALUE not in range between 0.005 and 0.5 for Parameter N_total
1033 Quantification limit VALUE not in range between 0.0025 and 0.05 for Parameter Al
1034 Quantification limit VALUE not in range between 0.0025 and 0.05 for Parameter Fe
1035 Quantification limit VALUE not in range between 0.0025 and 0.05 for Parameter Mn
1108 Control chart mean VALUE not in range between 25 and 200 for Parameter Alkalin
1109 Control chart mean VALUE not in range between 0.2 and 5 for Parameter N_NH4
1110 Control chart mean VALUE not in range between 0.2 and 10 for Parameter Ca
1111 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Cl
1112 Control chart mean VALUE not in range between 25 and 200 for Parameter Cond
1113 Control chart mean VALUE not in range between 2 and 30 for Parameter DOC
1114 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Mg
1115 Control chart mean VALUE not in range between 0.2 and 20 for Parameter N_NO3
1116 Control chart mean VALUE not in range between 4 and 9 for Parameter pH
1117 Control chart mean VALUE not in range between 0.2 and 5 for Parameter P
1118 Control chart mean VALUE not in range between 0.2 and 5 for Parameter P_PO4
1119 Control chart mean VALUE not in range between 1 and 20 for Parameter K
1120 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Na
1121 Control chart mean VALUE not in range between 0.2 and 25 for Parameter S_SO4
1122 Control chart mean VALUE not in range between 1 and 20 for Parameter N_total
1123 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Al
1124 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Fe
1125 Control chart mean VALUE not in range between 0.2 and 20 for Parameter Mn
1171 Value of Quantification limit is missing
1177 Value of Control chart mean is missing
1183 Value of Control chart std is missing
1189 Value of Laboratory ID is missing