TimeSeries collect_IdxStg table

tagId

tagIDType

This field displays the ID of the collect point.

time

datetime2(7)

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

value

doubleType

This field displays the value at the start of the hour.

dataQuality

bigint

This field displays the integer value from the dataQualityDefine table that describes the highest priority data quality for the data contained in the row. The priority, in descending order, is as follows:

• Manual

• Questionable

• Offscan

• Alarm

• Fresh

ownSysId

tagIDtype

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

datasetId

tagIDType

This field displays the ID associated with the dataset.

fieldTime

datetime2(7)

This field displays the field time of the collected point (UTC).

dqFlags

bigint

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

For more information, refer to TimeSeries data quality attributes.