Справочник Пользователя для Lucent Technologies Caller ID Box 585-210-939
Database Items and Calculations
CentreVu® CMS R3V8 Database Items and Calculations
Calculations
2-230
AVG_HOLD_TIME_SUM
sum(HOLDTIME) /
sum(HOLDCALLS)
sum(HOLDCALLS)
Total average hold
time.
time.
AVG_INB_ACD_TIME
(TOTAL_ACDTIME - O_ACDTIME) /
(TOTAL_ACDCALLS -
O_ACDCALLS)
(TOTAL_ACDCALLS -
O_ACDCALLS)
The average inbound
ACD time.
ACD time.
AVG_INB_ACW_TIME
(TOTAL_ACWTIME - O_ACWTIME) /
INBOUND_ACDCALLS
INBOUND_ACDCALLS
The average inbound
ACW time.
ACW time.
AVG_INB_ACD_TIME_SUM
(sum(TOTAL_ACDTIME -
O_ACDTIME)) /
INBOUND_ACDCALLS
O_ACDTIME)) /
INBOUND_ACDCALLS
Average inbound
ACD time.
ACD time.
AVG_INB_ACW_TIME_SUM
(sum(TOTAL_ACWTIME-
O_ACWTIME))/
INBOUND_ACDCALLS
O_ACWTIME))/
INBOUND_ACDCALLS
Average inbound
ACW time.
ACW time.
AVG_OUTB_ACD_SUM
sum(O_ACDTIME) /
sum(O_ACDCALLS)
sum(O_ACDCALLS)
Total outbound
average ACD talk
time.
average ACD talk
time.
AVG_OUTB_ACD_TIME
O_ACDTIME / O_ACDCALLS
Outbound average
ACD talk time.
ACD talk time.
AVG_OUTB_ACW_SUM
sum(O_ACWTIME) /
sum(O_ACDCALLS)
sum(O_ACDCALLS)
Total outbound
average ACW talk
time.
average ACW talk
time.
AVG_OUTB_ACW_TIME
O_ACWTIME / O_ACDCALLS
Outbound average
ACW talk time.
ACW talk time.
AVG_POS_STAFF
I_STAFFTIME / (INTRVL * 60)
Average positions
staffed.
staffed.
AVG_POS_STAFF_SUM
sum(I_STAFFTIME) / sum(INTRVL *
60)
60)
Total average
positions staffed.
positions staffed.
AVG_TALK_TIME_IN
(ACWINTIME + AUXINTIME) /
(ACWINCALLS + AUXINCALLS)
(ACWINCALLS + AUXINCALLS)
Extension in calls
average talk time.
average talk time.
AVG_TALK_TIME_IN_SUM
sum(ACWINTIME + AUXINTIME) /
sum(ACWINCALLS + AUXINCALLS)
sum(ACWINCALLS + AUXINCALLS)
Extension in calls
total average talk
time.
total average talk
time.
AVG_TALK_TIME_OUT
(ACWOUTTIME + AUXOUTTIME) /
(ACWOUTCALLS + AUXOUTCALLS)
(ACWOUTCALLS + AUXOUTCALLS)
Extension out calls
average talk time.
average talk time.
Calculation Name
Calculation
Description