Timeline hour table

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 shows the owning system for this record.

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 data quality status at the end of the period.

minTime

GMTtime

This field displays the timestamp for the minimum value (GMT).

minOffset

GMToffset

This field displays the offset what was in effect when the 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 of the minimum value.

minMilli

smallint

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

maxTime

GMTtime

This field displays the timestamp for the maximum value.

maxOffset

GMToffset

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

maximum

doubleType

This field displays the maximum value for the hour.

maxStatus

statusType

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

maxMilli

smallint

This field displays the data quality status of maximum value.

average

doubleType

This field displays the average value for the hour.

avgStatus

statusType

This field displays the data status of average.