AQDC - Rules Engine
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

Comment only
 
 
ABCDEFGHIJ
1
Rule IDRule DescriptionConditionSIDL column nameAcceptable valuesReject?
Enabled
Error CodeError MessageRemarks
2
AQ-T001
Missing data in mandatory column
Mandatory column missing data
measurement_timestamp OR
measurement_timestamp_epoch
Not null valueYesYesAQ-ERR-T001Missing data in mandatory column - measurement_timestampOne of these two columns is mandatory
3
AQ-T002
Missing data in mandatory column
Mandatory column missing data
measurement_latitude_degree_decimal
Not null valueYesYesAQ-ERR-T002
Missing data in mandatory column - measurement_latitude_degree_decimal
4
AQ-T003
Missing data in mandatory column
Mandatory column missing data
measurement_longitude_degree_decimal
Not null valueYesYesAQ-ERR-T003
Missing data in mandatory column - measurement_longitude_degree_decimal
5
AQ-T004
Missing data in mandatory column
Mandatory column missing datameasurand_nameNot null valueYesYesAQ-ERR-T004Missing data in mandatory column - measurand_name
6
AQ-T005
Missing data in mandatory column
Mandatory column missing datameasured_valueNot null valueYesYesAQ-ERR-T005Missing data in mandatory column - measured_value
7
AQ-T006
Missing data in mandatory column
Mandatory column missing datameasurement_unitNot null valueYesYesAQ-ERR-T006Missing data in mandatory column - measurement_unit
8
AQ-T007
Missing data in mandatory column
Mandatory column missing datadata_avg_durationNot null valueYesYesAQ-ERR-T007Missing data in mandatory column - data_avg_duration
9
AQ-T008
Missing data in mandatory column
Mandatory column missing datasensor_mobility_typeNot null valueYesYesAQ-ERR-T008Missing data in mandatory column - sensor_mobility_type
10
AQ-T009
Missing data in mandatory column
Mandatory column missing datasensor_manufacturer_nameNot null valueYesYesAQ-ERR-T009Missing data in mandatory column - sensor_manufacturer_name
11
AQ-T010
Missing data in mandatory column
Mandatory column missing datasensor_model_nameNot null valueYesYesAQ-ERR-T010Missing data in mandatory column - sensor_model_name
12
AQ-T013
Missing data in mandatory column
Mandatory column missing datadata_license_by_ownerNot null valueYesYesAQ-ERR-T013Missing data in mandatory column - data_license_by_owner
13
AQ-T014Timestamp not parsableInvalid timestamp formatmeasurement_timestampTimestamp value in valid formatYesYesAQ-ERR-T101Timestamp not parsable - measurement_timestampValid format per ASW date and timestamp guidelines
14
AQ-T015Timestamp not parsableInvalid epoch timestamp formatmeasurement_timestamp_epochValid epoch valueYesYesAQ-ERR-T102Timestamp not parsable - measurement_timestamp_epoch
15
AQ-T016Invalid locationLatitude value out of range
measurement_latitude_degree_decimal
-90 to 90YesYesAQ-ERR-T103Invalid location - measurement_latitude_degree_decimal
16
AQ-T017Invalid locationLongitude value out of range
measurement_longitude_degree_decimal
-180 to 180YesYesAQ-ERR-T104Invalid location - measurement_longitude_degree_decimal
17
AQ-T018Invalid valueUnsupported value for measurand_namemeasurand_nameLookup master data tableYesYesAQ-ERR-T201Invalid value - measurand_name
18
AQ-T019Invalid valueUnsupported value for measurement_unitmeasurement_unitLookup master data tableYesYesAQ-ERR-T202Invalid value - measurement_unit
19
AQ-T020Invalid value
Unsupported value for sensor_mobility_type
sensor_mobility_typeLookup master data tableYesYesAQ-ERR-T203Invalid value - sensor_mobility_type
20
AQ-T021Invalid valueUnsupported value for data_lifecycle_stagedata_lifecycle_stageLookup master data tableNoYesAQ-WARN-T204Invalid value - data_lifecycle_stage
21
AQ-T022Invalid value
Unsupported value for data_upload_version
data_upload_versionLookup master data tableNoYesAQ-WARN-T205Invalid value - data_upload_version
22
AQ-T023Date not parsableInvalid date format or valuesensor_origin_dateValid dateNoYesAQ-WARN-T105Date not parsable - sensor_origin_dateValid format per ASW date and timestamp guidelines
23
AQ-T024Date not parsableInvalid date format or valuesensor_purchase_dateValid dateNoYesAQ-WARN-T106Date not parsable - sensor_purchase_dateValid format per ASW date and timestamp guidelines
24
AQ-T025Date not parsableInvalid date format or valuesensor_system_origin_dateValid dateNoYesAQ-WARN-T107Date not parsable - sensor_system_origin_dateValid format per ASW date and timestamp guidelines
25
AQ-T026Date not parsableInvalid date format or valuesensor_system_purchase_dateValid dateNoYesAQ-WARN-T108Date not parsable - sensor_system_purchase_dateValid format per ASW date and timestamp guidelines
26
AQ-T027Date not parsableInvalid date format or valuesensor_system_deployment_dateValid dateNoYesAQ-WARN-T109Date not parsable - sensor_system_deployment_dateValid format per ASW date and timestamp guidelines
27
AQ-T028Timestamp not parsableInvalid timestamp formatsensor_last_calibration_timestampTimestamp value in valid formatNoYesAQ-WARN-T110Timestamp not parsable - sensor_last_calibration_timestampValid format per ASW date and timestamp guidelines
28
AQ-T029Timestamp not parsableInvalid timestamp formatsensor_last_service_timestampTimestamp value in valid formatNoYesAQ-WARN-T111Timestamp not parsable - sensor_last_service_timestampValid format per ASW date and timestamp guidelines
Loading...