hourSumBuffer table
- Last UpdatedApr 24, 2025
- 1 minute read
The hourSumBuffer table in the Historical TimeSeries database summarizes history data into the TimeSeries database's hour table. For performance reasons, the hourSumBuffer table only stores a week's worth of hourly records and purges older data.
|
Internal Field |
Data Type |
Description |
|---|---|---|
|
tagId |
tagIDType(int) |
The tag ID of the collect record. |
|
time |
datetime2(7) |
The start time of the hour. |
|
value |
doubleType(float) |
The last value received in the hour. |
|
dataQuality |
bigint |
The quality of the current value. |
|
minTime |
datetime2(7) |
The time of the minimum value of the hour. |
|
minValue |
doubleType(float) |
The minimum value of the hour. |
|
minDataQuality |
bigint |
The quality of the minimum value of the hour. |
|
maxTime |
datetime2(7) |
The time of the maximum value of the hour. |
|
maxValue |
doubleType(float) |
The maximum value of the hour. |
|
maxDataQuality |
bigint |
The quality of the maximum value of the hour. |
|
averageValue |
doubleType(float) |
The average value of the hour. |
|
averageCount |
int |
The number of values received in the hour. |
|
ownSysId |
tagIDType(int) |
The owning system ID. |
|
datasetId |
tagIDType(int) |
The dataset ID. |
|
modified |
bit |
Was any existing value of the hour modified (re-polled or modified in easy eXtended Operator Station [ezXOS])? |
|
lastModTime |
datetime |
Last modification time if it is modified. |