The BSAFactSeriesSummary table is a summary performance data repository. It contains a summary of BSLM performance information.
Table 3-15 BSAFactSeriesSummary Table
Name |
Type |
P |
M |
F |
Description |
---|---|---|---|---|---|
FactSeriesSummaryID |
$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. |
SeriesID |
$ID$ |
N |
Y |
Y |
Foreign key to the BSASeries table. |
SequenceID |
LONG |
N |
Y |
N |
Maintains data order when the data occurs within the same millisecond. |
TimePoint |
$TIMEPOINT$ |
N |
Y |
N |
The summary time point of the performance series record. |
TimePointDateTime |
$DATETIME$ |
N |
Y |
N |
The summary time point of the performance series record. This value is represented as a native date/time object. |
DateStamp |
$DATETIME$ |
N |
Y |
N |
Date and time that the BSAFactSeriesSummary 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. |