The BSAFactSeriesData table is the main Service Warehouse data repository. It contains all SLM performance information and is used as the primary data repository for graphing and charting performance data.
Table 3-13 BSAFactSeriesData Table
|
Name |
Type |
P |
M |
F |
Description |
|---|---|---|---|---|---|
|
FactSeriesID |
$ID$ |
Y |
Y |
N |
A unique random number generated when the performance record was created. |
|
BandID |
$ID$ |
N |
Y |
Y |
Foreign key reference to the BSATimeBand table. |
|
SequenceID |
LONG |
N |
Y |
N |
Maintains data order when the data occurs within the same millisecond. |
|
SeriesID |
$ID$ |
N |
Y |
Y |
Foreign key to the BSASeries table. |
|
TimePoint |
$TIMEPOINT$ |
N |
Y |
N |
The time point of the performance series record. This field is set to the date and time when the Operations Center server received the performance event. This value is represented in milliseconds. |
|
TimePointDateTime |
$DATETIME$ |
N |
Y |
N |
The time point of the performance series record. This field is set to the date and time when the Operations Center server received the performance event. This value is represented as a native date/time object. |
|
DateStamp |
$DATETIME$ |
N |
Y |
N |
Date and time that the BSAFactSeriesData record was created. |
|
DataType |
NUMBER |
N |
Y |
Y |
Foreign key reference to the BSADataTypes table. |
|
DoubleValue |
$DOUBLE$ |
N |
Y |
N |
If the performance data can be represented as a numeric value, it is converted to a double and inserted to this field. This provides an easy mechanism to produce averages or sums. |
|
Data |
VARCHAR2(128) |
N |
Y |
N |
Performance information data represented in string form. This data is converted to the proper data type by the Warehouse repository. All numeric data is stored as a string. |