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

AVEVA Enterprise SCADA

Timeline day table

  • Last UpdatedApr 24, 2025
  • 2 minute read

The day table in the Timeline database provides a daily summary of the collect data.

Internal Fields

Data Types

Description

tagId

tagIDType

This field displays the ID of the collect point.

time

GMTtime

This field displays the time of data summary (Greenwich Mean Time (GMT)).

offset

GMToffset

This field displays the offset to local time zone that was in effect when the value was collected.

ownSysId

tagIDType

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

datasetId

tagIDType

This field displays the ID of the associated dataset.

value

doubleType

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

status

statusType

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

minTime

GMTtime

This field displays the timestamp for the minimum value.

minOffset

GMToffset

This field displays the offset to local time zone that was in effect when minimum was collected.

minimum

doubleType

This field displays the minimum data value over the hour, day, month, or year.

minStatus

statusType

This field displays the data quality status for the minimum value.

minMilli

smallint

This field displays the millisecond part of the time minimum value.

maxTime

GMTtime

This field displays the timestamp for maximum value.

maxOffset

GMToffset

This field displays the offset to local time zone that was in effect when maximum was collected.

maximum

doubleType

This field displays the maximum data value over the hour, day, month, or year.

maxStatus

statusType

This field displays the data quality status for the maximum value.

maxMilli

smallint

This field displays the millisecond part of time for the maximum value.

average

doubleType

This field displays the average value for the hour.

avgStatus

statusType

This field displays the data status of the average.