Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA Enterprise SCADA

TimeSeries collect table

  • Last UpdatedApr 24, 2025
  • 1 minute read

The collect Table in the TimeSeries database provides the data for points configured for collection.

Internal Fields

Data Value

Description

tagId

tagIDType

This field displays the ID of the collect point.

time

datetime2(7)

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

value

doubleType

This field displays the value of the collected point.

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 the value collection.

For more information, refer to TimeSeries data quality attributes.