v_SummaryData
- Last UpdatedMar 18, 2021
- 2 minute read
Returns one row for each summarization of a tag (specified by the TagName column) for an associated summary event tag (specified by the EventTag column). The resolution is applied to data before the calculation is performed. The quality value returned is the highest quality value of the raw data from which the result is calculated.
|
Column |
Data type |
Description |
|---|---|---|
|
TagName |
TagNameType(nvarchar(256)) NOT NULL |
The unique name of the tag within the AVEVA Historian system. |
|
CalcType |
varchar(3) NULL |
The type of calculation to be performed: SUM, MAX, MIN, or AVG. |
|
SummaryDate |
datetime2(7) NOT NULL |
The date applicable to the results of the calculation. It is either the time of the beginning or end of the calculation period, as specified by the summary operation definition. |
|
Value |
float NULL |
The value of the summary. |
|
Quality |
tinyint NOT NULL |
The basic data quality indicator associated with the data value. |
|
Duration |
real NULL |
The period, in seconds, for which the calculation is performed. |
|
Resolution |
int NULL |
The sampling rate, in milliseconds, for retrieving the data in cyclic mode. The system returns values stored over the requested time period at the interval specified by the resolution. For example, if you specify a 5000 ms resolution, the system queries for all data during the time period and then only returns those values that occur at each 5000 ms interval, starting with the start date and ending with the end date. |
|
TimeStamp |
tinyint NULL |
The timestamp to use when storing the result of the calculation. The timestamp can be either the time when the calculation period starts or ends. |
|
EventTag |
TagNameType(nvarchar(256)) NOT NULL |
The name of the event tag to which the snapshot tag is related. |