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 |