TimeSeries day table

tagId

tagIDType

This field displays the ID of the collect point.

time

datetime2(7)

This field displays the server time of data summary This field displays the server time of the collected point (Coordinated Universal Time [UTC]).

value

doubleType

This field displays the value at the end of the period.

dataQuality

bigint

This field displays the data quality at the end of the period.

minTime

datetime2(7)

This field displays the server timestamp for the minimum value.

minValue

doubleType

This field displays the minimum data value over the period.

minDataQuality

bigint

This field displays the data quality for minimum value.

maxTime

datetime2(7)

This field displays the server timestamp for maximum value.

maxValue

doubleType

This field displays the maximum value over the period.

maxDataQuality

bigint

This field displays the data quality for maximum value.

averageValue

doubleType

This field displays the average value over the period.

ownSysId

tagIDtype

This field displays the System ID of the system that owns the point.

datasetId

tagIDType

This field displays the ID associated with dataset.

minDqFlags

bigint

This field represents all the data qualities present at the time of the minimum value.

For more information, refer to TimeSeries data quality attributes.

maxDqFlags

bigint

This field represents all the data qualities present at the time of the maximum value.

For more information, refer to TimeSeries data quality attributes.

avgDqFlags

bigint

This field represents a bit-wise, logical "OR" of all the data qualities that were active during the day.

For more information, refer to TimeSeries data quality attributes.

dqFlags

bigint

This field represents all the data qualities present at the end of the day period.

For more information, refer to TimeSeries data quality attributes.