PLL
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| length_less | 30 | 2000 | error | since 1984 |
temporal tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 286 | Message: longitude VALUE does not match with value VALUE from previous year SQL: where ((survey_tp = survey_tp_t-1)) AND NOT (longitude = longitude_t-1) |
warning | since 1984 |
| 287 | Message: latitude VALUE does not match with value VALUE from previous year SQL: where ((survey_tp = survey_tp_t-1)) AND NOT (latitude = latitude_t-1) |
warning | since 1984 |
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 749 | Message: OZ_altitude VALUE is not the same as in GENER.PLT SQL: where NOT (altitude = altitude) |
warning | since 1984 |
| 750 | Message: OZ_latitude VALUE is not the same as in GENER.PLT (VALUE). SQL: where NOT (latitude = latitude) |
warning | since 1984 |
| 751 | Message: OZ_longitude VALUE is not the same as in GENER.PLT (VALUE). SQL: where NOT (longitude = longitude) |
warning | since 1984 |
| 3020 | Message: plot VALUE is not registered in the system installation SQL: where NOT (EXIST(plot)) |
error | since 1984 |
| 3237 | 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 |
| 3238 | 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 |
| 20220070 | Message: Plot VALUE is not submitted in form LSS , but registered in form PLL with survey_type = 'LSS' SQL: where (survey_tp = 'LSS') AND NOT (EXIST(plot)) |
error | since 1984 |
| 20220071 | Message: Plot VALUE is not submitted in form OTS , but registered in form PLL with survey_type = 'OTS' SQL: where (survey_tp = 'OTS') AND NOT (EXIST(plot)) |
error | since 1984 |
| 20220072 | Message: Plot VALUE is not submitted in form LTF , but registered in form PLL with survey_type = 'LTF' SQL: where (survey_tp = 'LTF') AND NOT (EXIST(plot)) |
error | since 1984 |
LTF
range tests
no tests available
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 797 | Message: specified tree_species VALUE does not match with specified Perc. of symptomatic needles of last year code: VALUE SQL: where (percentage_symptomatic_cl IS NOT NULL) AND NOT (tree_species between 100 AND 199) |
error | since 1984 |
| 20009 | Message: Tree species -9 is not valid for this form. Specify a proper tree species. Plot: VALUE SQL: where NOT (tree_species > 0) |
error | since 1984 |
| 20220075 | Message: Plot VALUE is not submitted in form PLL with survey_type = 'LTF' SQL: where NOT (EXIST(plot, (survey_tp = 'LTF'))) |
error | since 1984 |
LSS
range tests
no tests available
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 13600 | Message: The direction "All sides" is not valid in this context. Please select a direction code between 1 and 8. SQL: where (code_aspect IS NOT NULL) AND NOT (code_aspect BETWEEN 1 AND 8) |
error | since 1984 |
| 20220073 | Message: Plot VALUE is not submitted in form PLL with survey_type = 'LSS' SQL: where NOT (EXIST(plot, (survey_tp = 'LSS'))) |
error | since 1984 |
OTS
range tests
no tests available
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 20220074 | Message: Plot VALUE is not submitted in form PLL with survey_type = 'OTS' SQL: where NOT (EXIST(plot, (survey_tp = 'OTS'))) |
error | since 1984 |
OZP
range tests
no tests available
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 20220056 | Message: Time invalid: VALUE. Required format: HHMMSS, e.g. 094533 for 09:45h 33s SQL: where NOT ((adds.isnumeric(time) AND time::NUMERIC >= 0 AND LENGTH(time) =6) OR CASE WHEN adds.isnumeric(time) AND time::NUMERIC >= 0 AND LENGTH(time) = 6 THEN (LEFT(time, 2)::INTEGER > 23 OR SUBSTRING(time, 3, 2)::INTEGER > 59 OR RIGHT(time, 2)::INTEGER > 59) END) |
error | since 1984 |