Back

Topic

[KB325]What do the EventNumber, VarType and AlarmState columns mean ?

Tags: HDS, MSSqlServer, SQL, SQL Server

System
14 years ago
By RM
Options
Print
Applies to:

PcVue all versions.
Summary:

The meaning of the EventNumber, VarType and AlarmState columns in an SQL database as used by the Historic Data Server (HDS).
Details:

Sometimes it could be useful to have the meaning of VarType, EventNumber and AlarmState value.

Below, you have the hexadecimal and decimal value.

The hexadecimal value is used by PcVue to make filters, but in the log table of the SQL database you will see the decimal value which is easier to read for the user.

Variable Type

Value (HEX) 

VALUE (DEC)
Bit

0x0001 

1
Register

0x0002 

2
Text

0x0004 

4
Alarm

0x0008 

8
Bit command

0x0010 

16
Threshold

0x0020 

32
Register control

0x0040 

64
Counter

0x0080 

128
Chrono

0x0100 

256
Text command

0x0200 

512

 

Event Type

Value (HEX) 

Value (DEC)
No event

0x00000000 

0
Alarm on and not ack 

0x00000001 

1
Alarm on and ack 

0x00000002 

2
Alarm off and not ack

0x00000004 

4
Alarm off 

0x00000008 

8
Alarm NS

0x00000010 

16
Alarm masked by user

0x00000040 

64
Log change to 0

0x00000200 

512
Log change to 1

0x00000400 

1 024
Log change to NS

0x00001800 

6 144
Alarm masked by program

0x00008000 

32 768
Alarm masked by variable (by dependence)

0x00010000 

65 536
Alarm masked by expression

0x00020000 

131 072
Register send

0x00040000 

262 144
Text Send

0x00080000 

524 288
Program Send

0x00100000

1 048 576
Alarm user ack

0x00200000 

2 097 152
Alarm not accessible

0x00400000 

4 194 304
Alarm inhibited

0x00800000 

8 388 608
Start Session

0x01000000 

16 777 216
Stop Session

0x02000000

33 554 432
Attempt to logon

0x04000000

67 108 864
User Mask Action

0x08000000

134 21 728
User unmask Action

0x10000000

268 435 456
Send Recipes

0x20000000

536 870 912
Start maintenance

0x40000000

1 073 741 824
Stop maintenance

0x80000000

2 147 483 648
Alarm on

0x100000000

4 294 967 296
Alarm off

0x200000000

8 589 934 592

 

Alarm State

Value (DEC)

Alarm on and ack

2

Alarm on and not ack

3

Alarm off

4

Alarm off and not ack

5

Alarm masked by user

6

Alarm NS

8

Alarm NS COM

9

Alarm inhibited

10

Alarm Program Masked

11

Alarm Variable Masked

12

Alarm Expression Masked

13

 

  <p> </p>

Created on: 23 Dec 2010 Last update: 13 May 2024