SWC
range tests
no tests available
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 130 | Message: specified ring_depth_upper VALUE must not smaller than specified ring_depth_lower VALUE SQL: where NOT (ring_depth_upper < ring_depth_lower) |
error | since 1984 |
| 131 | Message: specified ring_depth_lower VALUE does not match with specified ring_depth_upper VALUE SQL: where (ring_depth_upper >= 0) AND NOT (ring_depth_lower > 0) |
error | since 1984 |
| 134 | Message: specified ring_depth_upper VALUE does not match with specified ring_depth_lower VALUE SQL: where (ring_depth_lower <= 0) AND NOT (ring_depth_upper < 0) |
error | since 1984 |
| 479 | Message: specified date VALUE must not smaller than specified date_analysis VALUE SQL: where NOT (date_sampling <= date_analysis) |
error | since 1984 |
| 544 | Message: no linkage between SWC and PFH for VALUE (pit) and VALUE (horizon) SQL: where NOT (EXIST(profile_pit|PFH_pit=profile_pit|horizon=horizon)) |
warning | since 1984 |
SWA
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| matric_preasure | -1900 | 0 | warning | since 1984 |
| water_content | 0 | 1 | error | since 1984 |
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 480 | Message: specified date VALUE must not smaller than specified date_analysis VALUE SQL: where NOT (date_sampling <= date_analysis) |
error | since 1984 |
| 481 | Message: No corresponding observation found in SWC SQL: where NOT (EXIST(depth_layer)) |
error | since 1984 |