Important: You do not have the latest version of Historian! You are missing out on the newest capabilities and enhanced security. For information on all the latest features, see the Historian product page. For more information on upgrades, contact your GE Digital sales agent or e-mail GE Digital Sales Support. For the most up-to-date documentation, go here.

About the Table Descriptions

The following sections describe each table, list each column in the table, and list the data type and description for each column. The following table outlines the data types that are used throughout this chapter.

Table 1. Column Data Types
Data Type	Format of Data
`VT_BOOL`	Boolean
`VT_BSTR`	String
`VT_DBTimeStamp`	Date and Time
`VT_I4`	Integer
`VT_R4`	Float
`VT_R8`	Double Float
`VT_UI1`	Short Integer
`VT_VARIANT`	Numeric or String

Also included after each table description are examples of SQL statements used with the specified database table. These examples are only provided to get you started with creating SQL statements with the Historian OLE DB Provider. For more detailed information on creating SQL queries, refer to your reporting software documentation.