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 |