PLL
range tests
no tests available
temporal tests
| RULE_ID | TEST | ERROR |
|---|---|---|
| 286 | (longitude = longitude_t-1) WHERE ((survey_tp = survey_tp_t-1)) | w |
| 287 | (latitude = latitude_t-1) WHERE ((survey_tp = survey_tp_t-1)) | w |
| RULE_ID | MSG | MSG_CODE |
|---|---|---|
| 286 | longitude VALUE does not match with value VALUE from previous year | TT_NOT_MATCH |
| 287 | latitude VALUE does not match with value VALUE from previous year | TT_NOT_MATCH |
multiple tests
| RULE_ID | TEST | ERROR |
|---|---|---|
| 749 | altitude = altitude | w |
| 750 | latitude = latitude | w |
| 751 | longitude = longitude | w |
| 3020 | EXIST(plot) | e |
| 3237 | LENGTH(longitude) = 7 AND (longitude LIKE('+%') OR longitude LIKE('-%')) | e |
| 3238 | LENGTH(latitude) = 7 AND latitude LIKE('+%') | e |
| RULE_ID | MSG |
|---|---|
| 749 | OZ_altitude VALUE is not the same as in GENER.PLT |
| 750 | OZ_latitude VALUE is not the same as in GENER.PLT (VALUE). |
| 751 | OZ_longitude VALUE is not the same as in GENER.PLT (VALUE). |
| 3020 | plot VALUE is not registered in the system instalment |
| 3237 | longitude(VALUE) has to be submitted in a 7 digits format (+/-DDMMSS) with leading '+/-' |
| 3238 | latitude(VALUE) has to be submitted in a 7 digits format (+DDMMSS) with leading '+' |
LTF
range tests
no tests available
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR |
|---|---|---|
| 797 | (percentage_symptomatic_cl IS NOT NULL) AND NOT (tree_species between 100 AND 199) | e |
| RULE_ID | MSG |
|---|---|
| 797 | specified tree_species VALUE does not match with specified Perc. of symptomatic needles of last year code: VALUE |