Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

DiscreteWideHistory

  • Last UpdatedMar 18, 2021
  • 1 minute read

This table (INSQL.Runtime.dbo.DiscreteWideHistory) has been superceded by the WideHistory_OLEDB table. DiscreteWideHistory is the wide version of DiscreteHistory, where only discrete tags are considered. It is the same as WideHistory applied to discrete tags. In a query, this table must be referenced using an OPENQUERY statement.

Column

Data type

DateTime

datetime2(7) NOT NULL

TagD1

tinyint NULL

TagD2

tinyint NULL

ManyOtherTags

tinyint NULL

wwRowCount

int NULL

wwResolution

int NULL

wwEdgeDetection

nvarchar(16) NULL

wwRetrievalMode

nvarchar(20) NULL

The default is DELTA.

wwTimeDeadband

int NULL

wwTimeZone

nvarchar(50) NULL

wwVersion

nvarchar(30) NULL

wwCycleCount

int NULL

wwTimeStampRule

nvarchar(20) NULL

wwParameters

nvarchar(128) NULL

TitleResults for “How to create a CRG?”Also Available in