Timeline year table
- Last UpdatedApr 24, 2025
- 2 minute read
The year table in the Timeline database provides a summary of the yearly data.
|
Internal Fields |
Data Type |
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. |