Installation guide

Wave database schema A-10
Appendix A: Creating Custom Reports
Wave Contact Center Administrator Guide
The UserStateChange table
The UserStateChange table contains data that tracks the state of users.
The PhoneBookEntry table
Most types of Wave extensions (users, auto attendants, queues, etc.) have an entry in the
PhoneBookEntry table.
Name Description
PbeID ID of the PhoneBookEntry row that represents the user.
Time Timestamp for when the user entered the state.
Duration Number of seconds the user was in the state before it changed.
State
The state the user was in before the change.
The state values are:
0 = Sign out
1 = Ready
2 = Break
3 = Training
4 = Unavailable
5 = ACD Active. This feature is not currently supported.
6 = Non ACD Active. This feature is not currently supported.
7 = Sign out Active
ToState
The state the user was in after the change. The state values are the
same as the State column values.
Name Description
ID Unique identifier of a record.
Primary Name Last name.
FirstName First name.
EntryType
1 = User.
21 = Contact Center queue.
Release 2.0 Service Pack 1
April 2011