3.21 BSARootCauseTrees Table

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.