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
IDint
No
Identifier; primary key.
NAMEvarchar
254
No
Name of the interval in the default language.
NAME_ENvarchar
254
Yes
Name of the interval in English.
ABBREVIATIONvarchar
8
Yes
Abbreviation for the interval in the default language.
ABBREVIATION_ENvarchar
8
Yes
Abbreviation for the interval in English.
START_TIMESTAMPtimestamp
No
Starting point for the interval.
END_TIMESTAMPtimestamp
No
End point for the interval.
