Indexes in data logging tables. |
|
Columns and rows in data logging tables. |
Indexes in data logging tables
Indexes in data logging tables include a:
Index |
Description |
|
Primary key |
Is on the Joined Point ID and Timestamp columns. Includes the following if: |
|
|
The project name
table |
Project name column |
|
milliseconds is enabled. |
An MSEC column |
Secondary key |
Joined Point ID and timestamp_utc columns. |
|
Secondary key |
Is on the timestamp only. |
|
Secondary key |
Is on the timestamp_utc only. |
Columns and rows in data logging tables
Columns and rows in data logging tables are as follows.
Column Name |
Data Type |
Description |
Constant fields |
|
|
timestamp |
date/time |
Timestamp of the logging event |
timestamp_utc |
date/time |
UTC timestamp of the logging event. |
point_id |
string |
CIMPLICITY identifier for the point |
Attribute fields |
|
|
_ALRM |
string |
Alarm state of the point . |
_ENG |
string |
Engineering units label of the point. |
_PREV |
As configured. Default is string |
Previous logged value of the point for the same logging event. |
_QUALITY |
number |
Point quality flags. |
_RAW |
As configured. Default is string |
Raw value of the point. |
_RES |
string |
CIMPLICITY Resource associated with the point. |
_TIME |
date/time |
Previous time the point was logged for the same logging event. |
_USER |
number |
Value of the user defined flags. |
_VAL |
As configured. Default is string |
Value of the point. |
Optional fields |
|
|
project |
string |
Name of the CIMPLICITY project |
msec |
number |
Actual number of milliseconds in the timestamp |
Point data logging. |