Database Items and Calculations
CentreVu®
CMS R3V8 Database Items and Calculations
Calculations 2-234
MAX_FTE_AGENTS MAX_TOT_PERCENTS / 100 The maximum
number of full-time
equivalent agents on
this skill.
PERCENT_ACD_TIME 100 * ((I_ACDTIME + I_ACWTIME) /
I_STAFFTIME) Percentage of time
agents spend on
split/skill ACD calls
and in ACW.
PERCENT_ACD_TIME_SUM 100 * (sum(I_ACDTIME +
I_ACWTIME) / sum(I_STAFFTIME)) Total percentage of
time agents in spend
on split/skill ACD
calls and in ACW.
PERCENT_ALL_BUSY 100 * (ALLINUSETIME /
SECS_PER_DAY) Percentage of time all
trunks in use.
PERCENT_ALL_BUSY_D 100 * (ALLINUSETIME /
d_secs.SECSPERDAY) Percentage of time all
trunks in use in the
day.
PERCENT_ALL_BUSY_I 100*(ALLINUSETIME)/sum(INTERVL
*60) Percent of time all
trunks were busy in
interval.
PERCENT_ALL_BUSY_M 100 * (ALLINUSETIME
/m_secs.SECSPERMN) Percentage of time all
trunks in use in the
month.
PERCENT_ALL_BUSY_W 100 * (ALLINUSETIME
/w_secs.SECSPERWK) Percentage of time all
trunks in use in the
week.
PERCENT_ALL_BUSY_SUM 100 * (sum(ALLINUSETIME) /
sum(SECS_PER_DAY)) Percentage of time all
trunks in use.
PERCENT_AL_BSY_SUM_D 100 * (sum(ALLINUSETIME) /
sum(d_secs.SECSPERDAY)) Percentage of time all
trunks in use during
the day.
PERCENT_AL_BSY_SUM_M 100 * (sum(ALLINUSETIME) /
sum(m_secs.SECSPERMN)) Percentage of time all
trunks in use during
the month.
PERCENT_AL_BSY_SUM_W 100 * (sum(ALLINUSETIME) /
sum(w_secs.SECSPERWK)) Percentage of time all
trunks in use during
the week.
Calculation Name Calculation Description