Wave database schema A-2
Appendix A: Creating Custom Reports
Wave Contact Center Administrator Guide
Wave database schema
The Wave database contains the following tables that are used for reporting:
• CallLog table (page A-3)
• PartyLog table (page A-5)
• QueueEncounter table (page A-8)
• AgentStateChange table (page A-9)
• UserStateChange table (page A-10)
• PhoneBookEntry table (page A-10)
• ExtensionSettings table (page A-11)
• Agent table (page A-11)
• QueueSkillDefinitions table (page A-12)
• PBEQueueSkills table (page A-12)
• PBEQueueAttributes table (page A-12)
• PersonalStatus table (page A-13)
• Queue table (page A-13)
• QueueSkills table (page A-14)
• SkillReqLog table (page A-14)
• UserPSChange table (page A-14)
As Contact Center agent-states change and calls are completed, the Wave Server uses SQL
Server-stored procedures to write the appropriate data into these tables for later reporting. In
some cases the stored procedures themselves calculate the values of other fields to improve the
performance of later data retrieval.
Note: Not all columns in all tables are listed.
Release 2.0 Service Pack 1
