StateSummaryHistory (INSQL​.Runtime​.dbo​.StateSummaryHistory)

TagName

nvarchar(256) NOT NULL

The tag name.

StartDateTime

datetime2(7) NOT NULL

Start time of retrieval cycle.

EndDateTime

datetime2(7) NOT NULL

End time of retrieval cycle.

Value

float NULL

Numeric state.

vValue

nvarchar(4000) NULL

Non-numeric state.

OPCQuality

int NULL

OPC quality. Normal OPC quality retrieval logic is applied if:

• All the points found and processed for this row have GOOD quality. If they all have the same GOOD quality, then that quality is returned.

• If there is a gap in the entire calculation cycle, then BAD quality is returned for the tag.

• If the retrieval cycle contains a tag datatype transition (for example, the tag was configured to store integer values initially, then changed to store floating-point values) a DOUBTFUL OPC quality (64) is returned.

StateCount

int NULL

The number of times the state occurred within the retrieval cycle, including states that only partially occur in the cycle.

ContainedStateCount

int NULL

The number of times the state occurred fully contained within the retrieval cycle. States that only partially occur in the cycle are not counted.

StateTimeMin

float NULL

Minimum time in this state among all occurrences of this state during this retrieval cycle, including state occurrences that fall only partially within the period. An occurrence that was partially contained in two or more consecutive storage cycles is converted to a contained state within the retrieval cycle if possible.

StateTimeMinContained

float NULL

The minimum of the contained times in this state among all occurrences of this state during the entire retrieval cycle, excluding state occurrences that fall only partially within the period. An occurrence that was partially contained in two or more consecutive storage cycles is converted to a contained state within the retrieval cycle if possible.

StateTimeMax

float NULL

Maximum time in this state among all occurrences of this state during this retrieval cycle, including state occurrences that fall only partially within the period. An occurrence that was partially contained in two or more consecutive storage cycles is converted to a contained state within the retrieval cycle if possible.

StateTimeMaxContained

float NULL

The maximum of the contained times in this state among all occurrences of this state during the entire retrieval cycle, excluding state occurrences that fall only partially within the period. An occurrence that was partially contained in two or more consecutive storage cycles is converted to a contained state within the retrieval cycle if possible.

StateTimeAvg

float NULL

Average time in this state among all occurrences of this state during this retrieval cycle, including state occurrences that fall only partially within the period.

StateTimeAvgContained

float NULL

Average time in this state among all occurrences of this state during this retrieval cycle, excluding state occurrences that fall only partially within the period. An occurrence that was partially contained in two or more consecutive storage cycles is converted to a contained state within the retrieval cycle if possible.

StateTimeTotal

float NULL

Total time in this state during this retrieval cycle, including state occurrences that fall only partially within the period.

StateTimeTotalContained

float NULL

Total time in this state during this retrieval cycle, excluding state occurrences that fall only partially within the period. An occurrence that was partially contained in two or more consecutive storage cycles is converted to a contained state within the retrieval cycle if possible.

StateTimePercent

float NULL

Percent of the time during this retrieval cycle that the tag was in this state, including state occurrences that fall only partially within the period.

StateTimePercentContained

float NULL

The precentage of the entire retrieval cycle time that the tag was in this state, excluding state occurrences that fall only partially within the period. This is a ratio between StateTimeTotalContained and StateTimeTotal expressed as a percentage in the range 0 to 100. An occurrence that was partially contained in two or more consecutive storage cycles is converted to a contained state within the retrieval cycle if possible.

SourceTag

nvarchar(256) NULL

The source (tier 1) tag for the summary tag.

SourceServer

nvarchar(256) NULL

The source (tier 1) server for the summary tag.

wwCycleCount

int NULL

The number of cycles into which the entire query time range has been divided.

wwResolution

int NULL

Length of cycles in milliseconds. The default is 3600000 (equal to 1 hour).

wwTimeZone

nvarchar(50) NOT NULL

Time zone to use for interpreting both input and output timestamp parameters. If none is specified, then the default is set to LOCAL.

wwVersion

nvarchar(30) NOT NULL

Data version, ORIGINAL or LATEST. If none is specified, the default is LATEST.

wwTagKey

int NOT NULL

Tag key.

wwRetrievalMode

nvarchar(16) NOT NULL

Determines whether to use CYCLIC or DELTA retrieval. The default is DELTA.

wwMaxStates

int NULL

The maximum number of states (for state summaries) that are stored. The first N states will have summary values. For internal use only.