TimeSeries dataQualityDefine table
- Last UpdatedApr 24, 2025
- 1 minute read
The dataQualityDefine table in the TimeSeries database provides definitions of all possible data qualities (including the name and a description of each data quality) that are referenced by the collect, hour, day, month and year tables.
|
Internal Fields |
Data Value |
Description |
|---|---|---|
|
DataQualityBitmask |
bigint |
This field displays the data quality integer value associated with a data quality. |
|
DataQualityname |
nvarchar(96) |
This field displays the name of the data quality. |
|
DataQualityDescription |
nvarchar(96) |
This field displays the description of the data quality. |
|
Priority |
int |
This field displays the priority of the data quality used in user displays (e.g. easy eXtended Operator Station (ezXOS)) when multiple data qualities are combined together. |
The following table describes the data quality integer values contained in the dataQualityDefine table.
|
Integer |
Data Quality Name |
Description |
|---|---|---|
|
0 |
Questionable |
The data was of an unknown quality. |
|
1 |
Offscan |
The record was stale and not up to date when its data was collected. |
|
2 |
Manual Override |
The record data was manually entered. |
|
4 |
Fresh |
The record data was updating normally. |
|
8 |
Flashing |
The record was in an unacknowledged alarm state when the data was collected. |
|
16 |
Error |
The record was in an ERROR state when the data was collected. |
|
32 |
Alarm Inhibited |
The record was in an alarm state, but the alarm was inhibited when the record data was collected. |
|
64 |
Alarm |
The record was in an alarm state when the data was collected. |