The BSARootCauseTrees table stores the element and time when a condition change affected the element.
Table 3-20 BSARootCauseTrees Table
Name |
Type |
P |
M |
F |
Description |
---|---|---|---|---|---|
RootCauseKey |
$ID$ |
Y |
Y |
N |
Random number generated at row creation time to identify the root cause tree record. |
RootElementKey |
$ID$ |
N |
Y |
Y |
Foreign key reference to the BSAElements table. |
CrcHash |
INTEGER |
N |
Y |
N |
A 32‑bit CRC hash of the entire root cause structure. This value is used to identify and deduplicate root cause events. |
DateStamp |
$DATETIME$ |
N |
N |
N |
Date and time that the BSARootCauseTrees record was created. |