PHE

range tests

no tests available

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR_TYPE ACTIVE
20011 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

PLP

range tests

no tests available

temporal tests

RULE_ID TEST ERROR_TYPE ACTIVE
72 Message: date_installation VALUE does not match with value VALUE from previous year
SQL: where NOT (date_installation = date_installation_t-1)
warning since 1984
86 Message: tree_species VALUE must not change for particular tree
SQL: where (tree_species_t-1 NOT IN (99, 199, 0, 94)) AND NOT (tree_species = tree_species_t-1)
error since 1984
158 Message: tree VALUE must be the same as at previous observation (unless new trees were intentiously involved - e.g. due to ingrowth - or existing trees were felled or wind-thrown)
SQL: where NOT (tree = tree_t-1)
warning since 1984

multiple tests

RULE_ID TEST ERROR_TYPE ACTIVE
545 Message: specified Submission year VALUE must not smaller than specified DATE_INSTALLATION VALUE
SQL: where (date_installation IS NOT NULL) AND NOT (TO_NUMBER(TO_CHAR(date_installation,'YYYY'),'9999') <= survey_year)
error since 1984
20012 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

PHI

range tests

no tests available

temporal tests

RULE_ID TEST ERROR_TYPE ACTIVE
283 Message: tree VALUE must be the same as at previous observation (unless new trees were intentiously involved - e.g. due to ingrowth - or existing trees were felled or wind-thrown)
SQL: where NOT (tree = tree_t-1)
warning since 1984

multiple tests

RULE_ID TEST ERROR_TYPE ACTIVE
648 Message: linkage to plot file must exist
SQL: where NOT (EXIST(tree))
error since 1984

PHD

range tests

no tests available

temporal tests

RULE_ID TEST ERROR_TYPE ACTIVE
88 Message: tree_species VALUE must not change for particular tree
SQL: where (tree_species_t-1 NOT IN (99, 199, 0, 94)) AND NOT (tree_species = tree_species_t-1)
error since 1984

multiple tests

RULE_ID TEST ERROR_TYPE ACTIVE
20010 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

PHC

range/temp tests/mulitiple tests

no tests available