3.11 BSAConfigHistory Table

The BSAConfigHistory table persists Service Level Manager (SLM) configuration information when modified. The table is currently only used for historical auditing purposes. Configuration information stored to it includes Service Level Agreements and time management data.

Table 3-10 BSAConfigHistory Table

Name

Type

P

M

F

Description

HistoryID

$ID$

Y

Y

N

A unique random number generated when the record is created.

BandID

$ID$

N

Y

Y

Foreign key to the BSATimeband table.

SeriesID

$ID$

N

Y

Y

Foreign key to the BSASeries table.

DataType

INTEGER

N

Y

N

Configuration history data type ID. A sequential number representing the data type.

TimePoint

$LONG$

N

Y

N

Date and time the configuration information record was recorded.

TimePointDateTime

$DATETIME$

N

Y

N

Date and time the configuration information record was recorded. This value is stored in the database native DATE format.

ConfigBlob

$BLOB$

N

Y

N

The configuration information stored as a serialized object.