EventFrame schema

Tables representing event frames, such as EventFrame, EventFrameHierarchy , EventFrameAttribute, and so on, are grouped into the EventFrame schema.

Event frames can reference elements (column PrimaryReferencedElementID) and refer to data using element attributes.

Event frames can also have attributes (table EventFrameAttributes) and refer to data using these attributes. Event frame attributes reference data tables in the Data schema, prefixed EventFrame (for example, EventFrameSnapshot, EventFrameArchive, and ft_EventFramePlot).

Typical queries are as follows:

• Event frame element attribute query = inner join of EventFrame.EventFrame and Asset.ElementAttribute.

• Event frame attribute query = inner join of EventFrame.EventFrame and EventFrame.EventFrameAttribute.

• Time-series data query = inner join EventFrame.EventFrame, Asset.ElementAttribute, and any one data table or TVF dedicated to element attributes from the Data schema

  or

  inner join EventFrame.EventFrame, EventFrame.EventFrameAttribute, and any one data table or TVF dedicated to event frames from the Data schema.

  Note: PI OLEDB Enterprise Event Frames support requires PI AF server 2012 or later.