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_NO2 | 0.001 | 300 | warning | since 1984 |
| N_NO2 | 0.0001 | 100000 | error | since 1984 |
| N_NO3 | 0.001 | 300 | warning | since 1984 |
| N_NO3 | 0.0001 | 100000 | error | since 1984 |
| N_NO3_plus_N_NO2 | 0.001 | 300 | warning | since 1984 |
| N_NO3_plus_N_NO2 | 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 |
| 20250032 | Message: Sum of N_NO3 and N_NO2 not in range SQL: where (N_NO2 IS NOT NULL AND N_NO3 IS NOT NULL AND N_NO3_plus_N_NO2 IS NOT NULL) AND NOT (N_NO3_plus_N_NO2 BETWEEN ((N_NO2 + N_NO3)*0.9) AND ((N_NO2 + N_NO3)*1.1) |
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 |