The BSAAlarmElements table contains a list of all affected elements for a particular alarm. It is used mainly as a reference table to join the BSAAlarmData and BSAElements tables during alarm history queries.
Table 3-3 BSAAlarmElements Table
|
Name |
Type |
P |
M |
F |
Description |
|---|---|---|---|---|---|
|
AlarmKey |
$ID$ |
Y |
Y |
Y |
Foreign key reference to the BSAAlarmData table. |
|
ElementKey |
$ID$ |
Y |
Y |
Y |
Foreign key to the BSAElements table. |
|
RecordedDate |
$TIMEPOINT$ |
N |
Y |
N |
Date and time that the BSAAlarmData record was created (represented in milliseconds). |
|
TimeCreated |
$TIMEPOINT$ |
N |
Y |
N |
The date and time the alarm was created. This field is the same as NativeLastUpdateTime for alarm create records. However, if this is an alarm delete entry, the TimeCreated field is set to Long.MAX_VALUE; that is, 9223372036854775807. |
|
LastUpdateTime |
$TIMEPOINT$ |
N |
Y |
N |
The date and time of the most recent update of the current alarm. This is a skewed date/time, meaning the time is adjusted for differences between the network management system and the Operations Center server. This value is represented in milliseconds. |
|
AlarmType |
CHAR(1) |
N |
Y |
N |
Alarm type. |