Download T/Mon LNX - DPS Telecom

Transcript
25
tinyint(4)
unsigned
Forms a unique identifier when used
in conjunction with the
EventDateTime.
AckDateTime
datetime
The date and time which the event
was acknowledged. This field is only
relevant if the “Initials” field is not
blank.
YES
Initials
varchar(10)
The initials of the user that
acknowledged the alarm.
YES
char(1)
The state of the event.
• ‘S’=Silenced
• ‘C’=Cleared
• ‘F’=Set
YES
AlarmLevel
char(1)
The severity level of the event.
• ‘A’=Critical
• ‘B’=Major
• ‘C’=Minor
• ‘D’=Status
YES
SubDevice
char(3)
Name of the sub-device which
reported the event.
YES
SiteName
varchar(40)
Name of the site which reported the
event.
YES
PointName
varchar(40)
Name of the point which corresponds
to the event.
YES
AuxPointName
varchar(40)
Auxiliary name of the point which
corresponds to the event.
YES
AlarmStatus
varchar(8)
Description of the current status of the
event.
YES
DispDesc
varchar(40)
Name of the display which the TMon
received the event on.
YES
datetime
The date and time which the device
that reported the event to the TMon
received the event.
YES
Current timestamp used by Microsoft
Access.
YES
EventCounter
AlarmState
TStamp
timestamp
PRI
0
MUL
CURRENT_
TIMESTAMP