sp601_report_date_ranges
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table provides named date ranges for use within Analytics reports, each set of date ranges is associated with a category from sp600_report_date_categories.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| id | varchar2(20) | Â |  |
| description | varchar2(20) | Â | |
| startdate | date | Â | |
| enddate | date | Â | |
| duration | number(38) | Â | |
| category | number(38) | Â | |
Keys
primary key (id)Â
foreign key (categoryid) references sp600_report_date_categories(id)
Column Descriptions
| Field | Description |
|---|---|
| id | Identifier for this date range. |
| description | A descriptive text describing the date range, display on the reporting pages. |
| startdate | The starting date for this range (inclusive). |
| enddate | The ending date for this range (inclusive). enddate must be greater than or equal to startdate otherwise the reports will issue a (non fatal) warning. No trigger provided to validate this. |
| duration | Defines the duration from the start date using the calendar period defined in sp600.period. |
| categoryid | Reference to sp600_report_date_categories(id) to define which category this date range belongs to. |