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 |