Skip Navigation
Expand
Knowledge foundation tables windows field
Answer ID 5921   |   Last Review Date 12/12/2018

What do the values in the 'windows' field of the Knowledge Foundation tables mean?

Environment:

All sites on the November 2011 version or more recent

Resolution:

The following Knowledge Foundation tables were added beginning with the November 2011 version of Oracle RightNow CX:

kf_action_stats - collects detailed statistics on pages and other 'clickstreams' actions
kf_answer_stats - collects detailed statistics on answers
kf_error_stats - collects statistics on errors and preceding 'clickstreams' actions
kf_escalation_sessions - collects statistics on escalations grouped by session type
kf_escalation_stats - collects statistics on escalations from various sources
kf_referrer_stats - collects statistics on referring sites and search queries
kf_sa_log -details of SmartAssistant transaction data (i.e. search text) for joining against rows in the 'clickstreams' table
kf_search_stats - collects detailed statistics on searches
kf_searches - records stemmed searches
kf_smartassistant_stats - collects statistics on SmartAssistant usage
kf_top_item_stats - collects additional statistics on answers and searches

With the exception of the 'kf_sa_logs' and 'kf_searches' tables, each of the abovementioned tables contains a 'windows' field (i.e. kf_action_stats.window) that portrays the aggregation time period.  This field will contain one of the following values:

0 = hourly
1 = daily
2 = monthly
3 = yearly

The data in the Knowledge Foundation tables is aggregated from the 'clickstreams' table by the dataminer utility based on the type of activity for a given time interval per interface.  For more descriptive information on how the data is aggregated, please reference Answer ID 5922: Dataminer aggregation of knowledge foundation tables

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.