Skill_Group_Half_Hour OR Skill_Group_Interval

[MhLove007]

first time poster! We are new to ICM... I am trying to conver call reports for CSR(s)  (Customer Services Reps) to get total calls by date, time logged in ... that type of data. What would the difference between Skill_Group_Half_Hour  OR Skill_Group_Interval.

Is it better to use Skill_Group_Interval to roll-up for the day?

help me understand this from Schema (

Note:

The Agent_Skill_Group_Interval Table will be populated with 30- or 15-minute reportingdata, depending on the Historical Reporting Interval setting for the PG. TheAgent_Skill_Group_Half_Hour Table will not be populated with this data.

)

[Senthil Kumar Sankar · Accepted solution]

Hi

Some, but not all, Half_Hour tables now have an equivalent Interval table. The Half_Hour tables still appear in the database, but are no longer populated. For CUIC only (and not for WebView) the equivalent Interval tables are populated by either half-hour or fifteen-minute data, based on configuration. WebView uses “half-hour views” to pull 30-minute data from the Interval tables.

While configuring the PG, you will give whether the Reporting interval should for 15 minutes or 30 Minutes, If you have 15 minutes selected then will see 15 minutes Interval in the Agent_Skill_Group_Interval Table.

Regards,

Senthil

[MhLove007]

Thanks for the feedback...