PSS

range tests

no tests available

temporal tests

RULE_ID TEST ERROR_TYPE ACTIVE
243 Message: longitude VALUE does not match with value VALUE from previous year
SQL: where NOT (longitude = longitude_t-1)
warning since 1984
244 Message: latitude VALUE does not match with value VALUE from previous year
SQL: where NOT (latitude = latitude_t-1)
warning since 1984
245 Message: layer VALUE must not change over time for each combination of country, plot, and sampler_ID
SQL: where ((sampler_id = sampler_id_t-1)) AND NOT (layer = layer_t-1)
error since 1984
246 Message: sampler_type VALUE must not change over time for each combination of country, plot, and sampler_ID
SQL: where ((sampler_id = sampler_id_t-1)) AND NOT (sampler_type = sampler_type_t-1)
warning since 1984

multiple tests

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

SSM

range tests

FIELD MIN MAX ERROR_TYPE ACTIVE
Al 0.001 500 warning since 1984
Al 0.0001 100000 error since 1984
alkalinity 0 27500 warning since 1984
Al_labile 0.001 300 warning since 1984
Al_labile 0.0001 100000 error since 1984
Ca 0.005 75 warning since 1984
Ca 0.0001 100000 error since 1984
Cl 0.01 400 warning since 1984
Cl 0.0001 100000 error since 1984
conductivity 1 10000 warning since 1984
Cr 0.04 100 warning since 1984
Cr 0.0001 100000 error since 1984
Cu 0.05 1000 warning since 1984
Cu 0.001 10000 error since 1984
DOC 0.001 600 warning since 1984
DOC 0.0001 100000 error since 1984
Fe 0.0003 500 warning since 1984
Fe 0.0001 100000 error since 1984
K 0.001 30 warning since 1984
K 0.0001 100000 error since 1984
Mg 0.01 15 warning since 1984
Mg 0.0001 100000 error since 1984
Mn 0.001 300 warning since 1984
Mn 0.0001 100000 error since 1984
Na 0.02 22.5 warning since 1984
Na 0.0001 100000 error since 1984
Ni 0.001 1500 warning since 1984
Ni 0.0001 100000 error since 1984
N_NH4 0.0008 75 warning since 1984
N_NH4 0.0001 100000 error since 1984
N_NO3 0.001 300 warning since 1984
N_NO3 0.0001 100000 error since 1984
P 0.001 12.5 warning since 1984
P 0.0001 100000 error since 1984
Pb 0.02 5000 warning since 1984
Pb 0.001 10000 error since 1984
pH 3.5 8.5 warning since 1984
pH 1 14 error since 1984
Si 0.005 200 warning since 1984
Si 0.0001 100000 error since 1984
S_SO4 0.01 1250 warning since 1984
S_SO4 0.0001 100000 error since 1984
total_nitrogen 0.001 400 warning since 1984
total_nitrogen 0.0001 100000 error since 1984
Zn 0.01 1000 warning since 1984
Zn 0.001 10000 error since 1984

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR_TYPE ACTIVE
693 Message: specified date_start VALUE must not smaller than specified date_end VALUE
SQL: where NOT (date_start <= date_end)
error since 1984
779 Message: Sampler_ID VALUE not specified in PSS file
SQL: where NOT (EXIST(sampler_id))
error since 1984
979 Message: sum of N_NH4 VALUE and N_NO3 VALUE greater than N_total VALUE
SQL: where NOT ((total_nitrogen * 1.05) >= (N_NH4 + N_NO3))
warning since 1984
987 Message: Submitted value for conductivity VALUE does not fit with calculated value
SQL: where ((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)
warning since 1984

LQA

range tests

FIELD MIN MAX ERROR_TYPE ACTIVE
control_chart_std 0 100 error since 1984

temporal tests

no tests available

multiple tests

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