TIME_DIMENSION
Date values in all tables are tied to TIME_DIMENSION by the ID. By default, the time dimension contains time and date values for a 20-year period. This period can be extended using the extendTimeDimension command. To do so, change to your FlexNet Operations install directory and enter flexnet extendTimeDimension.
|
Columns |
Type |
Length |
Description |
|
ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the device record as defined in FlexNet Operations. The ID is the primary key for the Time dimension. |
|
DATEVAL |
datetime |
8 |
Date as a date type. DATEVAL can be used to do date arithmetic for reports. |
|
DATE_NUMBER |
numeric |
19 |
Date as a number. DATE_NUMBER can be null. |
|
DATE_STRING |
string |
50 |
Date as a string. DATE_STRING can be null. |
|
HR_OF_DAY |
numeric |
2 |
Hour of the day. |
|
DAY_NAME |
string |
50 |
Name of the day. |
|
WEEK_NUMBER |
numeric |
2 |
Number of the week in the year, from 1-52. |
|
MONTH_NUMBER |
numeric |
2 |
Number of the month in the year, from 1-12. |
|
DAY_OF_MONTH |
numeric |
2 |
Number of the day in the month. |
|
MONTH_NAME |
string |
50 |
Name of the month. |
|
DAY_OF_YEAR |
numeric |
3 |
Number of the day in the year. |
|
QUARTER |
numeric |
1 |
Number of the quarter in the year, from 1-4. |
|
YEAR |
numeric |
4 |
Number (4 digits) of the year. |