Normalized alarm history data field values are stored in the BSAAlarmValues table when the Normalize feature is enabled for the Alarms history expression on a profile. The table contains one row for each field associated with an alarm.
Table 3-8 BSAAlarmValues Table
Name |
Type |
P |
M |
F |
Description |
---|---|---|---|---|---|
AlarmKey |
$ID$ |
Y |
Y |
Y |
Foreign key reference to the BSAAlarmData table. |
ColumnID |
$ID$ |
Y |
Y |
Y |
Foreign key reference to the BSAMetaData table. |
ColumnIndex |
NUMBER |
N |
Y |
N |
Index of the current field within the alarm. |
TypeID |
NUMBER |
N |
Y |
Y |
Foreign key to the BSAAlarmValueTypes table. |
StringValue |
$STRING$ |
N |
N |
N |
The string representation of the alarm field. |
BlobValue |
$BLOB$ |
N |
N |
N |
Alarm field value for non‑ASCII data. |