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. |