CentreVu
®
Advocate Database Items and Calculations
CentreVu® Advocate Release 8 User Guide
Database Table Names
13-7
Database Table Names
0
Introduction
0
To select data for custom reports, you must use the names listed in the
tables in this section. The database items are described in later sections
of this chapter.
Real-Time Table
Names
0
The following tables lists the real-time database tables with new or
modified data for
CentreVu Advocate and the type of data stored in them.
Historical
Database Tables
0
The following table lists historical database tables with new or modified
data and the type data stored in them.
Name
Data Stored
csplit
Split/Skill data for the current interval.
psplit
Split/Skill data for the previous interval.
cagent
Agent data for the current interval.
pagent
Agent data for the previous interval.
Name
Data Stored
hsplit
Split/Skill data for each intrahour interval.
dsplit
Split/Skill data summarized by day.
wsplit
Split/Skill data summarized by week.
msplit
Split/Skill data summarized by month.
hagent
Agent data for each intrahour interval.
dagent
Agent data summarized by day.
wagent
Agent data summarized by week.
magent
Agent data summarized by month.
