sp600_report_data_categories
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table provides for a list of categories for grouping defined date ranges for use within Analytics Reports.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| id | integer | Â |  |
| description | varchar2(20) | Â | |
| period | integer | Â |  |
Keys
primary key (id)
Column Descriptions
| Field | Description |
|---|---|
| id | Identifier for this category. Id is 0 is reserved. |
| description | A descriptive text describing this category. This is displayed on the report pages when selecting categories. |
| period | For reports which group results by day, week or month, this defines the grouping to be used: 1 – day 2 – week 3 – month |