In addition to the usual data fields that you would expect to find on a ClearSCADA Point object, a Totalflow Trend Point object also has the following data fields, which are listed in the ClearSCADA Database Schema (Trend Point Schema View). The name in bold at the start of each entry is also the OPC tag name.
- LastError—This field contains a string that describes the last error on the point.
- LastErrorTime—This is the timestamp for the LastError field. The driver generates the timestamp and as such the timestamp uses the same time zone as the server.
- NewestHistoricTime—The driver uses the value of this field to track the timestamp of the newest trend record that it inserted into the point’s historic record. If communications go down, and then come back, the driver will attempt to retrieve data from this time to the present. You should not need to manipulate this field directly.
- NewestHistoricValue—The driver tracks the newest historic value in this field. This is the value that corresponds to the newest historic timestamp. When historic Compression is enabled, the driver uses this field to determine whether or not to insert a value into the point’s historic record. If historic Compression is not enabled, the driver does not use this value. You should not need to manipulate this field directly.
Further Information