PGB
range tests
no tests available
temporal tests
RULE_ID | TEST | ERROR_TYPE | ACTIVE |
---|---|---|---|
18 | Message: longitude VALUE does not match with value VALUE from previous year SQL: where NOT (longitude = longitude_t-1) |
warning | since 1984 |
51 | Message: latitude VALUE does not match with value VALUE from previous year SQL: where NOT (latitude = latitude_t-1) |
warning | since 1984 |
multiple tests
RULE_ID | TEST | ERROR_TYPE | ACTIVE |
---|---|---|---|
376 | Message: GB_altitude VALUE is not the same as in GENER.PLT SQL: where NOT (altitude = altitude) |
warning | since 1984 |
439 | Message: GB_latitude VALUE is not the same as in GENER.PLT (VALUE). SQL: where NOT (latitude = latitude) |
warning | since 1984 |
440 | Message: GB_longitude VALUE is not the same as in GENER.PLT (VALUE). SQL: where NOT (longitude = longitude) |
warning | since 1984 |
617 | Message: frame_area VALUE not in range between 0.25 and 2 SQL: where (frame_area <> -9) AND NOT (frame_area BETWEEN 0.25 AND 2) |
warning | since 1984 |
618 | Message: sampled_area VALUE not in range between 0.25 and 20 SQL: where (sampled_area <> -9) AND NOT (sampled_area BETWEEN 0.25 AND 20) |
warning | since 1984 |
3006 | Message: plot VALUE is not registered in the system installation SQL: where NOT (EXIST(plot)) |
error | since 1984 |
3211 | 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 |
3212 | 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 |
GBM
range tests
FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
---|---|---|---|---|
C | 0 | 100 | error | since 1984 |
temporal tests
no tests available
multiple tests
no tests available
GBH
range tests
FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
---|---|---|---|---|
height | 2 | 150 | warning | since 1984 |
temporal tests
no tests available
multiple tests
no tests available
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 |
---|---|---|---|
910 | Message: Quantification limit must not be <= 0 where parameter is VALUE SQL: where NOT (quantification_limit > 0) |
error | since 1984 |
916 | Message: Control chart mean must not be <= 0 where parameter is VALUE SQL: where NOT (control_chart_mean > 0) |
error | since 1984 |
940 | 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 |
946 | Message: Control chart std must not be <= 0 where parameter is VALUE SQL: where NOT (control_chart_std > 0) |
error | since 1984 |
988 | Message: Quantification limit VALUE not in range between 0.01 and 1 for Parameter B SQL: where (parameter='B') AND NOT (quantification_limit between 0.01 and 1) |
warning | since 1984 |
989 | Message: Quantification limit VALUE not in range between 0.5 and 50 for Parameter Cd SQL: where (parameter='Cd') AND NOT (quantification_limit between 0.5 and 50) |
warning | since 1984 |
990 | Message: Quantification limit VALUE not in range between 0.005 and 0.5 for Parameter Ca SQL: where (parameter='Ca') AND NOT (quantification_limit between 0.005 and 0.5) |
warning | since 1984 |
991 | Message: Quantification limit VALUE not in range between 0.1 and 10 for Parameter C SQL: where (parameter='C') AND NOT (quantification_limit between 0.1 and 10) |
warning | since 1984 |
992 | Message: Quantification limit VALUE not in range between 0.01 and 1 for Parameter Cu SQL: where (parameter='Cu') AND NOT (quantification_limit between 0.01 and 1) |
warning | since 1984 |
993 | Message: Quantification limit VALUE not in range between 0.05 and 5 for Parameter Fe SQL: where (parameter='Fe') AND NOT (quantification_limit between 0.05 and 5) |
warning | since 1984 |
994 | Message: Quantification limit VALUE not in range between 0.005 and 0.5 for Parameter Pb SQL: where (parameter='Pb') AND NOT (quantification_limit between 0.005 and 0.5) |
warning | since 1984 |
995 | Message: Quantification limit VALUE not in range between 0.003 and 0.3 for Parameter Mg SQL: where (parameter='Mg') AND NOT (quantification_limit between 0.003 and 0.3) |
warning | since 1984 |
996 | Message: Quantification limit VALUE not in range between 0.05 and 5 for Parameter Mn SQL: where (parameter='Mn') AND NOT (quantification_limit between 0.05 and 5) |
warning | since 1984 |
997 | Message: Quantification limit VALUE not in range between 0.02 and 2 for Parameter N SQL: where (parameter='N') AND NOT (quantification_limit between 0.02 and 2) |
warning | since 1984 |
998 | Message: Quantification limit VALUE not in range between 0.003 and 0.3 for Parameter P SQL: where (parameter='P') AND NOT (quantification_limit between 0.003 and 0.3) |
warning | since 1984 |
999 | Message: Quantification limit VALUE not in range between 0.005 and 0.5 for Parameter K SQL: where (parameter='K') AND NOT (quantification_limit between 0.005 and 0.5) |
warning | since 1984 |
1000 | Message: Quantification limit VALUE not in range between 0.003 and 0.3 for Parameter S SQL: where (parameter='S') AND NOT (quantification_limit between 0.003 and 0.3) |
warning | since 1984 |
1001 | Message: Quantification limit VALUE not in range between 0.05 and 5 for Parameter Zn SQL: where (parameter='Zn') AND NOT (quantification_limit between 0.05 and 5) |
warning | since 1984 |
1076 | Message: Control chart mean VALUE not in range between 5 and 50 for Parameter B SQL: where (parameter='B') AND NOT (control_chart_mean between 5 and 50) |
warning | since 1984 |
1077 | Message: Control chart mean VALUE not in range between 25 and 400 for Parameter Cd SQL: where (parameter='Cd') AND NOT (control_chart_mean between 25 and 400) |
warning | since 1984 |
1078 | Message: Control chart mean VALUE not in range between 1 and 15 for Parameter Ca SQL: where (parameter='Ca') AND NOT (control_chart_mean between 1 and 15) |
warning | since 1984 |
1079 | Message: Control chart mean VALUE not in range between 45 and 57 for Parameter C SQL: where (parameter='C') AND NOT (control_chart_mean between 45 and 57) |
warning | since 1984 |
1080 | Message: Control chart mean VALUE not in range between 1 and 15 for Parameter Cu SQL: where (parameter='Cu') AND NOT (control_chart_mean between 1 and 15) |
warning | since 1984 |
1081 | Message: Control chart mean VALUE not in range between 20 and 300 for Parameter Fe SQL: where (parameter='Fe') AND NOT (control_chart_mean between 20 and 300) |
warning | since 1984 |
1082 | Message: Control chart mean VALUE not in range between 0.15 and 15 for Parameter Pb SQL: where (parameter='Pb') AND NOT (control_chart_mean between 0.15 and 15) |
warning | since 1984 |
1083 | Message: Control chart mean VALUE not in range between 0.4 and 3 for Parameter Mg SQL: where (parameter='Mg') AND NOT (control_chart_mean between 0.4 and 3) |
warning | since 1984 |
1084 | Message: Control chart mean VALUE not in range between 30 and 4000 for Parameter Mn SQL: where (parameter='Mn') AND NOT (control_chart_mean between 30 and 4000) |
warning | since 1984 |
1085 | Message: Control chart mean VALUE not in range between 6 and 30 for Parameter N SQL: where (parameter='N') AND NOT (control_chart_mean between 6 and 30) |
warning | since 1984 |
1086 | Message: Control chart mean VALUE not in range between 0.4 and 2.5 for Parameter P SQL: where (parameter='P') AND NOT (control_chart_mean between 0.4 and 2.5) |
warning | since 1984 |
1087 | Message: Control chart mean VALUE not in range between 2 and 13 for Parameter K SQL: where (parameter='K') AND NOT (control_chart_mean between 2 and 13) |
warning | since 1984 |
1088 | Message: Control chart mean VALUE not in range between 0.5 and 2.4 for Parameter S SQL: where (parameter='S') AND NOT (control_chart_mean between 0.5 and 2.4) |
warning | since 1984 |
1089 | Message: Control chart mean VALUE not in range between 10 and 100 for Parameter Zn SQL: where (parameter='Zn') AND NOT (control_chart_mean between 10 and 100) |
warning | since 1984 |
1170 | Message: Value of Quantification limit is missing SQL: where NOT (quantification_limit IS NOT NULL) |
warning | since 1984 |
1176 | Message: Value of Control chart mean is missing SQL: where NOT (control_chart_mean IS NOT NULL) |
warning | since 1984 |
1182 | Message: Value of Control chart std is missing SQL: where NOT (control_chart_std IS NOT NULL) |
warning | since 1984 |
1188 | Message: Value of Laboratory ID is missing SQL: where NOT (Laboratory_ID IS NOT NULL) |
warning | since 1984 |
20220040 | Message: Laboratory ID "VALUE" has not participated in a ringtest with pretreatment "VALUE" and determination method "VALUE" SQL: where NOT (ref.fn_check_lab_id('FO_LF_GB', survey_year, Laboratory_ID, pretreatment, determination) IS TRUE) |
warning | since 2009 |