/
14.1 sp600_report_data_categories

14.1 sp600_report_data_categories

This table provides for a list of categories for grouping defined date ranges for use within Analytics Reports.


 

Table Definition

Field
Type
Default
Nullable
idinteger (error)
descriptionvarchar2(20) (error)
periodinteger (tick)

Keys

primary key (id)

Column Descriptions

FieldDescription
idIdentifier for this category. Id is 0 is reserved. 
descriptionA descriptive text describing this category. This is displayed on the report pages when selecting categories.
periodFor reports which group results by day, week or month, this defines the grouping to be used: 
1 – day
2 – week
3 – month

Related content

sp600_report_data_categories
sp600_report_data_categories
More like this
14.1 sp601_report_date_ranges
14.1 sp601_report_date_ranges
More like this
sp601_report_date_ranges
sp601_report_date_ranges
More like this