CIMPLICITYIndexes, Columns, Rows in CIMPLICITY Data Log Tables
- 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 attribute is selected. | 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. |
| _VAL | As configured. Default is string | Point value. |
| _TIME | date/time | Previous time the point was logged for the same logging event. |
| _TIME_UTC | UTC date/time | Previous UTC time the point was logged for the same logging event. |
| _RAW | As configured. Default is string | Raw value of the point. |
| _RES | string | CIMPLICITY Resource associated with the point. |
| _QUALITY | number | Point quality flags. |
| _USER | number | Value of the user defined flags. |
| Optional fields | ||
| project | string | Name of the CIMPLICITY project |
| msec | number | Actual number of milliseconds in the timestamp |
