This table provides the time interval options that appear in the report prompts. By default, the table includes the following calculated intervals:
Today
Yesterday
Week to Date
Last 14 Days
Month to Date
Quarter to Date
Year to Date
Prior Week to Date
Prior 14 Days
Prior Month to Date
Prior Quarter to Date
Prior Year to Date
Prior Year End
All
This tabled described in surrounding text
Column Name
Type
Length
Null Allowed
Description
ID
int
No
Identifier; primary key.
NAME
varchar
254
No
Name of the interval in the default language.
NAME_EN
varchar
254
Yes
Name of the interval in English.
ABBREVIATION
varchar
8
Yes
Abbreviation for the interval in the default language.
ABBREVIATION_EN
varchar
8
Yes
Abbreviation for the interval in English.
START_TIMESTAMP
timestamp
No
Starting point for the interval.
END_TIMESTAMP
timestamp
No
End point for the interval.