Table Properties for an ODBC Data Source | Historian 2023 Documentation

Column Name	Data Type	Description
TableName	String	Enter the name of the table. A value is required and must match the name of a table you specify in the list of tags.
TagNameColumn	String	Enter the name of the tag whose data you want to extract from the table. A value is required and must match the name of a tag you specify in the list of tags.
TimestampColumn	String	Enter the name of the column in the database table from which you want to extract the timestamp values.
ValueColumn	String	Enter the name of the column in the database table from which you want to extract the tag values.
QualityColumn	String	Enter the name of the column in the database table from which you want to extract the quality values.
ihOPCBad	String	Enter the values or range of values whose quality must be considered bad. For example, if a tag value is considered bad when the value is between 0 and 50, enter `<ihOPCBad>0-50</ihOPCBad>`. You can also enter words and values separated by commas (for example, `<ihOPCBad>bad, uneven</ihOPCBad>`). A value is required.
ihOPCGood	String	Enter the values or range of values whose quality must be considered good. For example, if a tag value is considered good when the value is between 51 and 100, enter `<ihOPCGood>51-100</ihOPCGood>`. You can also enter words and values separated by commas (for example, `<ihOPCGood>good, better, excellent</ihOPCGood>`). A value is required.
ihOPCUncertain	String	Enter the values or range of values whose quality must be considered uncertain. For example, if a tag value is considered uncertain when the value is 101 or 102, enter `<ihOPCUncertain>101,102</ihOPCUncertain>`. You can also enter a range of values.
ihOPCNA	String	Enter the values or range of values whose quality must be considered not applicable. For example, if a tag value is considered not applicable when the value is 103, 104, or 105, enter `<ihOPCNA>103,104,105</ihOPCNA>`. You can also enter a range of values.
Condition	String	Enter the condition that you want to use to filter data. For example, if you enter Historian = 1, you can use this condition in a WHERE clause when querying data.

TableName

String

Enter the name of the table. A value is required and must match the name of a table you specify in the list of tags.

TagNameColumn

String

Enter the name of the tag whose data you want to extract from the table. A value is required and must match the name of a tag you specify in the list of tags.

TimestampColumn

String

Enter the name of the column in the database table from which you want to extract the timestamp values.

ValueColumn

String

Enter the name of the column in the database table from which you want to extract the tag values.

QualityColumn

String

Enter the name of the column in the database table from which you want to extract the quality values.

ihOPCBad

String

Enter the values or range of values whose quality must be considered bad. For example, if a tag value is considered bad when the value is between 0 and 50, enter <ihOPCBad>0-50</ihOPCBad>. You can also enter words and values separated by commas (for example, <ihOPCBad>bad, uneven</ihOPCBad>).

A value is required.

ihOPCGood

String

Enter the values or range of values whose quality must be considered good. For example, if a tag value is considered good when the value is between 51 and 100, enter <ihOPCGood>51-100</ihOPCGood>. You can also enter words and values separated by commas (for example,

<ihOPCGood>good, better,
                                    excellent</ihOPCGood>

).

A value is required.

ihOPCUncertain

String

Enter the values or range of values whose quality must be considered uncertain. For example, if a tag value is considered uncertain when the value is 101 or 102, enter <ihOPCUncertain>101,102</ihOPCUncertain>. You can also enter a range of values.

ihOPCNA

String

Enter the values or range of values whose quality must be considered not applicable. For example, if a tag value is considered not applicable when the value is 103, 104, or 105, enter <ihOPCNA>103,104,105</ihOPCNA>. You can also enter a range of values.

Condition

String

Enter the condition that you want to use to filter data. For example, if you enter Historian = 1, you can use this condition in a WHERE clause when querying data.