The BSAAlarmQueue table is used internally by the Warehouse to queue alarm records for normalization. Alarm history data normalization occurs as a lower priority maintenance thread to prevent performance bottlenecks during normal operations.
Table 3-6 BSAAlarmQueue Table
Name |
Type |
P |
M |
F |
Description |
---|---|---|---|---|---|
AlarmKey |
$ID$ |
Y |
Y |
Y |
Foreign key reference to the BSAAlarmData table. |
SeriesID |
$ID$ |
Y |
Y |
Y |
Foreign key reference to the BSASeries table. |
DateStamp |
$TIMEPOINT$ |
N |
Y |
N |
The date and time that the BSAAlarmQueue record was created. |
SequenceID |
LONG |
N |
Y |
N |
Maintains data order when the data occurs within the same millisecond. |