The BSATimeBand table is used to store different time bands associated with an alarm event or performance series.
Table 3-22 BSATimeBand Table
|
Name |
Type |
P |
M |
F |
Description |
|---|---|---|---|---|---|
|
BandID |
$ID$ |
Y |
Y |
N |
Unique random number generated when the time band record was created. |
|
AlphaDayOf Week |
VARCHAR2(16) |
N |
N |
N |
Time band day of week represented by the day name (Monday, Tuesday Wednesday, etc). |
|
AlphaMonth |
VARCHAR2(16) |
N |
N |
N |
Time band month of year represented by month name (January, February, etc.). |
|
BandStart |
$DATETIME$ |
N |
Y |
N |
Date and time when the time band started. |
|
DayofWeek |
NUMBER |
N |
N |
N |
Numeric day of week associated with the current time band. |
|
DayofYear |
NUMBER |
N |
N |
N |
Numeric day of year associated with the current time band. |
|
DayValue |
NUMBER |
N |
N |
N |
The numeric day value for the current time band. |
|
Granularity |
INTEGER |
N |
N |
N |
Time band granularity. Currently not used. |
|
HourValue |
NUMBER |
N |
N |
N |
The hour value for the current time band. |
|
MonthValue |
NUMBER |
N |
N |
N |
The numeric month value for the current time band. |
|
IsWeekDay |
$BOOLEAN$ |
N |
N |
N |
Boolean flag which indicates if this time band falls on a weekday. |
|
WorkShift |
NUMBER |
N |
N |
N |
The shift identifier associated with the current time band. |
|
YearValue |
NUMBER |
N |
N |
N |
The year value for the current time band. |