Database Associations

The following table lists the statistics that store values in the database, and the columns and database tables in which they store the values. The table uses the following abbreviations:

A=AGENT_METRICS table

AG=AGENT_GROUP_METRIC table

CC=CC_METRICS table

S=SERVICE_METRICS table

Statistic

Column

A

AG

CC

S

Calls Queued

V_CALLS_QUEUED

n

n

X

X

Number of Accepted Transfers

V_TRANSFERS_ACCEPTED

X

X

X

X

Number of Answered Returned Interactions

V_ANSWERED_RETURNS

X

X

X

X

Number of Calls Abandoned

V_CALLS_ABANDONED

n

n

X

X

Number of Calls Answered

V_CALLS_ANSWERED

X

X

X

X

Number of Calls Received

V_CALLS_RECEIVED

n

n

X

n

Number of Calls Short-Abandoned

V_CALLS_SHORT_ABANDONED

n

n

X

X

Number of Disconnected in IVR Interactions

V_INT_IVR_DISCONNECTED

n

n

X

X

Number of Originated Transfers

V_TRANSFERS_ORIGINATED

X

X

X

X

Number of Rejected Transfers

V_TRANSFERS_REJECTED

X

X

X

X

Number of Returned Interactions

V_INT_RETURNED

X

X

X

X

Service Factor

V_SERVICE_FACTOR

n

n

X

X

Total After Call Work Time

V_WRAPUP_TIME

X

X

X

n

Total Busy Time

V_TOTAL_BUSY_TIME

X

X

X

n

Total Handling Time

V_TOTAL_HANDLING_TIME

X

X

X

n

Total Held Time

V_HELD_TIME

X

X

X

n

Total Logon Time

V_LOGON_TIME

X

X

X

n

Total Not Ready Time

V_NOT_READY_TIME

X

X

X

n

Total Ready Time

V_READY_TIME

X

X

X

n

Total Time in Queue

V_TOTAL_QUEUED_TIME

n

n

X

X

Total Working Time

V_WORK_TIME

X

X

X

n