The BSARootCauseChains table contains information regarding the parent element that is being affected by an element’s change in condition, with a short description about why it is affected.
Table 3-17 BSARootCauseChains Table
|
Name |
Type |
P |
M |
F |
Description |
|---|---|---|---|---|---|
|
ChainKey |
$ID$ |
Y |
Y |
N |
Random number generated at row creation time to identify the Root Cause chain. |
|
ElementKey |
$ID$ |
N |
Y |
Y |
Foreign key to the BSAElements table. |
|
ReasonKey |
$ID$ |
N |
Y |
Y |
Foreign key to the BSARootCauseReasons table. |
|
Condition |
INTEGER |
N |
Y |
N |
The condition of the element when the root cause information was retrieved. |