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