Rockwell Automation FactoryTalk View Site Edition Users Guide User Manual
Page 240
F
ACTORY
T
ALK
V
IEW
S
ITE
E
DITION
U
SER
’
S
G
UIDE
11–28
• •
•
•
•
AlarmType
The number FactoryTalk View assigns to the
transaction type:
0 for SysAk (System Acknowledged)
1 for InAlm (In Alarm)
2 for OutAlm (Out of Alarm)
3 for InFlt (In Fault)
4 for OutFt (Out of Fault)
5 for Ack (Acknowledged)
6 for RmAck (Remote Acknowledged)
7 for SupOn (Suppress On)
8 for SupOf (Suppress Off)
9 for Remar (Remark)
SQL_SMALLINT, or
SQL_INTEGER
1
SrcArea
The area, in which the alarm occurred.
SQL_VARCHAR, or
SQL_CHAR
80
TagName
The name of the tag or alarm event that caused the
alarm.
SQL_VARCHAR, or
SQL_CHAR
255
TagValue
The value of the tag at the time the alarm occurred.
SQL_DOUBLE, or
SQL_INTEGER, or
SQL_SMALLINT
20
(10 decimal
places)
TagType
The type of the tag in alarm: 2 for Analog, 1 for
Digital.
SQL_VARCHAR, or
SQL_CHAR
1
ThreshVal
The threshold value.
SQL_DOUBLE, or
SQL_FLOAT
20
(10 decimal
places)
ThreshNum
The threshold number.
SQL_SMALLINT, or
SQL_INTEGER
1
ThreshLabl
The threshold label.
SQL_VARCHAR, or
SQL_CHAR
21
Severity
The alarm severity.
SQL_SMALLINT, or
SQL_INTEGER
1
UserID
The name of the user (including domain name, if
there is one) that initiated the alarm transaction. If
the transaction was initiated by an HMI server, the
user is NT Authority\System.
SQL_VARCHAR, or
SQL_CHAR
38
Dscrptn
The message that is associated with the transaction
(alarm) type, the log message for the alarm event, or
the alarm log remark.
SQL_VARCHAR, or
SQL_CHAR
132
This column
Contains
SQL data type
Length