14.1 sp600_report_data_categories
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
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 |