Indexes, 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.

_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

More information

image\Buttongraysm.png

Point data logging.