ALM table

 images\btn_mini.gif Notation 

Summary

This table contains all the alarm log data which are also saved in the *.alm files located in the report folder. The active [MyConfig].alm file is located in the configuration root folder.

Important: This table is read-only. You can control the amount of data saved in this table on the Files tab in System Configuration.

Field name

SQL type

Description

GUI name

OAN

INTEGER

The object’s autonumber.

-

AREA

CHAR (31)

Area name

Name in Area Properties dialog box

ENAME

CHAR (31)

Object name

Name in Definition of Object dialog box

ALMNO

INTEGER

Alarm number as defined on the Edit Mapping tab

Alarm Number in the alarm list

BEG_TIME

TIMESTAMP

The start date and time of the alarm (in seconds), for example,
22-04-03 10:57:25

Start Date and Start Time in the alarm list

BEG_MSEC

DOUBLE

The time in milliseconds, for example, 530.
This gives the exact time together with the above field.

Start Time in the alarm list

ACK_TIME

TIMESTAMP

The date and time of the acknowledgement of the alarm
(in seconds), for example,
22-04-03 11:17:30

Acknowledge Date and Acknowledge Time in the alarm list

ACK_MSEC

DOUBLE

The time in milliseconds, for example, 530.
This gives the exact time together with the above field.

Acknowledge Time in the alarm list

END_TIME

TIMESTAMP

The end date and time of the alarm (in seconds), for example,
22-04-03 12:46:35

End Date and End Time in the alarm list

END_MSEC

DOUBLE

The time in milliseconds, for example, 530.
This gives the exact time together with the above field.

End Time in the alarm list

LASTCHANGE_TIME

TIMESTAMP

The date and time (in seconds) of the last change for the alarm, that is the latest of the BEG_, ACK_ and END_ times above., for example,
22-04-03 12:46:35

-

LASTCHANGE_MSEC

DOUBLE

The time in milliseconds, for example, 530.
This gives the exact time together with the above field.

-

ALMSTATE

INTEGER

Shows the alarm state:

0 = No alarm

1 = Acknowledged by IGSS
(sys in Alarm List)

2 = Acknowledged by operator

3 = Unacknowledged
(*** in Alarm List)

Alarm State in the alarm list

MNT

INTEGER

1 if the alarm is a maintenance alarm, 0 if not.

-

WORSTVAL

DOUBLE

Worst value measured for the process component while it was in alarm.

Worst Value in the alarm list

DRIVERID

INTEGER

Driver number if the alarm is a driver alarm, NULL if it is not.

Driver ID in the alarm list.

NODE_NUMBER

INTEGER

Node number if the alarm is a driver alarm, NULL if it is not.

Node ID in the alarm list.

CODE

INTEGER

Error code if the alarm is a driver alarm, NULL if it is not.

-

SUBCODE

INTEGER

Error sub code if the alarm is a driver alarm, NULL if it is not.

-

IGSSUSER

INTEGER

The ID of the user who acknowledged the alarm.

List of user IDs

User in the alarm list
BEG_USER INTEGER The ID of the PLC or IGSS module which triggered the alarm.

List of user IDs		 User in the alarm list
END_USER INTEGER The ID of the PLC or IGSS module which triggered the alarm.

List of user IDs
 User in the alarm list

 
See Also