Lucent Technologies CentreVu Call Management System Release 3 Version 8 Manual

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-179
VDN exception table
Limit, as a number of seconds, administered for timed exceptions types. 
An occurrence is logged against the threshold when the VDN activity falls 
outside of that limit.
This is a cumulative item.
Vector exception table
Limit, as a number of seconds, administered for timed exceptions types. 
An occurrence is logged against the threshold when the vector activity 
falls outside of that limit.
This is a cumulative item.
TINACW
(real-time)
2
Database tables2The TINACW item appears in the following database tables:
Split/skill tables
The number of top agents logged into the skill who are in after call work 
for ACD calls to the skill. This includes top agents on ACWIN/ACWOUT 
calls, as well as agents who are in after call work not associated with an 
ACD call. Available on Generic 3 switches with the EAS feature for top 
skills. However, top database items are only significant for Generic 3 
switches and the ECS with EAS. TINACW includes TONACWIN and 
TONACWOUT.
This is a status item.
TINAUX
(real-time)
2
Database tables2The TINAUX item appears in the following database tables:
Split/skill tables
The number of top agents logged into the skill who are in the AUX work 
mode. This includes agents on AUXIN/AUXOUT calls. Available on 
Generic 3 switches with the EAS feature for top skills. However, top 
database items are only significant for Generic 3 switches and the ECS 
with EAS. TINAUX includes TINAUX0, TINAUX1-9, TONACDAUXOUT, 
TONAUXIN, and TONAUXOUT.
This is a status item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-180
TINAUX0
(real-time)
2
Database tables2The TINAUX0 item appears in the following database tables:
Split/skill tables
The number of top agents logged into the skill who are in the AUX work 
for reason code 0 (zero) for all splits/skills or on AUXIN/AUXOUT calls for 
AUX with reason code 0 (zero). For the ECS with EAS, reason code 0 
(zero) is for system AUX work when reason codes are active. For 
switches without EAS and for releases prior to ECS, TINAUX0 will be the 
same as TINAUX. Also available on Generic 3 and newer switches with 
EAS in top skills.
This is a status item.
TINAUX1-9
(real-time)
2
Database tables2The TINAUX1-9 item appears in the following database tables:
Split/skill tables
The number of top agents logged into the skill who are in AUX work for 
each of the reason codes 1-9. This includes agents on AUXIN/AUXOUT 
calls from AUX with the appropriate reason code. Available for ECS and 
later switch releases with the EAS feature for top skills.
This is a status item.
TKGRP2
Database tables2The TKGRP item appears in the following database tables:
Trunk group tables
This is an index item.
The trunk group number for which data was collected. This will be zero if 
the trunk group carrying the call is not measured
This is a row identifier item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-181
Trunk tables
This is an index item.
The trunk group number to which the trunk is assigned.
This is an administrative item.
Call record tables
Trunk group number for which data was collected (or for which an 
exception occurred). This will be null if the trunk group carrying the call is 
not measured.
Trunk group exception table
Trunk group number for which data was collected (or for which an 
exception occurred). This will be zero if the trunk group carrying the call is 
not measured.
This is a cumulative item.
Malicious call trace exception table
Trunk group number for which data was collected (or for which an 
exception occurred). This will be zero if the trunk group carrying the call is 
not measured.
This is a cumulative item.
TKSTATE (real-
time)
2
Database tables2The TKSTATE (real-time) item appears in the following database tables:
Trunk tables
The current state of the call. Trunk states include: IDLE, SEIZED, 
QUEUED, CONN, RING, DABN, FBUSY, FDISC, HOLD, MBUSY, 
UNKNOWN, or as defined in Dictionary.
This is a status item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-182
TONACD
(real-time)
2
Database tables2The TONACD item appears in the following database tables:
Split/skill tables
The number of top agents logged into the skill who are on inbound and 
outbound ACD calls for the skill. Available with Generic 3 and newer 
switches with the EAS feature for top skills. However, top database 
items are only significant for Generic 3 switches and the ECS with EAS. 
TONACD includes TONACDOUT.
This is a status item.
TONACDAUX-
OUT
(real-time)
2
Database tables2The TONACDAUXOUT item appears in the following database tables:
Split/skill tables
The number of top agents logged into the skill who are on AUXOUT calls 
with an ACD call for the skill on hold. Available with Generic 3 and newer 
switches with the EAS feature for top skills. However, top database 
items are only significant for Generic 3 switches and the ECS with EAS.
This is a status item.
TONACDOUT
(real-time)
2
Database tables2The TONACDOUT item appears in the following database tables:
Split/skill tables
The number of top agents that are on outbound calls placed by an 
adjunct to this skill. Available with Generic 3 and newer switches with the 
EAS feature for top skills. However, top database items are only 
significant for Generic 3 switches and the ECS with EAS. Available for 
outbound calls on Generic 3 switches with the ASAI feature.
This is a status item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-183
TONACWIN
(real-time)
2
Database tables2The TONACWIN item appears in the following database tables:
Split/skill tables
The number of top agents that are in ACW for this skill and on inbound 
extension calls. These agents also appear in TINACW. Available with 
Generic 3 switches. However, top database items are only significant 
for Generic 3 switches and the ECS with EAS.
This is a status item.
TONACWOUT
(real-time)
2
Database tables2The TONACWOUT item appears in the following database tables:
Split/skill tables
The number of top agents that are in ACW for this skill and on outbound 
extension calls. These agents also appear in TINACW. Available with 
Generic 3 and newer switches with the EAS feature for top skills. 
However, top database items are only significant for Generic 3 switches 
and the ECS with EAS.
This is a status item.
TONAUXIN
(real-time)
2
Database tables2The TONAUXIN item appears in the following database tables:
Split/skill tables
The number of top agents that are in AUX work or AVAILABLE. For 
Generic 3 switches, including agents with an ACD or AUXIN/AUXOUT 
call attributed to this split/skill on hold and on inbound extension calls. 
However, top database items are only significant for Generic 3 switches 
and the ECS with EAS. Available with Generic 3.
This is a status item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-184
TONAUXOUT
(real-time)
2
Database tables2The TONAUXOUT item appears in the following database tables:
Split/skill tables
The number of top agents that are in AUX work or AVAILABLE. For 
Generic 3 switches, including agents with an ACD or AUXIN/AUXOUT 
call attributed to this split/skill on hold and on inbound extension calls. 
Available with Generic 3 switches. However, top database items are 
only significant for Generic 3 switches and the ECS with EAS.
This is a status item.
TOPCALLS2
Database tables2The TOPCALLS item appears in the following database tables:
Split/skill tables
The number of ACDCALLS with top priority that were answered by 
agents in this split/skill. Available with Generic 3 switches with vectoring.
This is a cumulative item.
TOPSKILL
(real-time)
2
Database tables2The TOPSKILL item appears in the following database tables:
Agent tables
The agents first-administered, highest-level, measured skill, where skill 
level 1 is the highest, skill level 16 is the lowest. Available on a Generic 3 
switch with EAS. 
The TOPSKILL of an agent will be 0 except when PREFERENCE is skill 
level (LVL). This means that an agent will not have a top skill or be 
counted in any split/skill table Top Skill items if their call handling 
preference is greatest need (NEED) or percent allocation (PCNT). In 
addition, agents who have skill level preference but only reserve levels 
for all their skills will not have a TOPSKILL. Requires a DEFINITY ECS 
R5 or R6 or later with EAS. PCNT and reserve levels are only available 
on the ECS R6 or later.
This is a status item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-185
TOT_PERCENTS
(real-time)
2
Database tables2The TOT_PERCENTS item appears in the following database tables:
Split/Skill tables
The total staffed agent percentages allocated to the skill. Requires a 
DEFINITY ECS R6 or later with EAS. 
This is a real-time item.
TOTHER
(real-time)
2
Database tables2The TOTHER item appears in the following database tables:
Split/skill tables
The number of top agents that are doing other work. Agents are logged 
into multiple splits/skills and doing work for a split/skill other than this one 
(on an ACD call or in ACW, or ACD calls ringing).
For Generic 3, while in Auto-in or Manual-In mode: the agent put any call 
on hold and has performed no further action; the agent is on a direct 
agent call or in ACW for a direct agent call; the agent is dialing to place a 
call or to activate a feature; an extension call or a direct agent ACD call is 
ringing with no other activity.
For Generic 3 EAS with multiple call handling, agents are available for 
other, multiple call handling, skills. Agent POSITIONS will show up in 
TOTHER directly after the link to the switch comes up and directly after 
the agents log in before the 
CentreVu CMS is notified of the agents work 
state.
Available with Generic 3 switches with the EAS feature. However, top 
database items are only significant for Generic 3 switches and the ECS 
with EAS. TOTHER includes TDA_INACW and TDA_ONACD.
This is a status item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-186
TRANSFERRED2
Database tables2The TRANSFERRED item appears in the following database tables:
Split/skill tables
The number of ACDCALLS that were transferred to another destination. 
For Generic 3 switches, includes all split/skill calls transferred.
This is a cumulative item.
Agent tables
Number of calls the agent transferred to another destination. Note that 
TRANSFERRED calls include both inbound and outbound calls. 
Therefore, OTHERCALLS and O_OTHERCALLS may each include 
some SHORTCALLS. For Generic 3 switches, this includes transferring 
all calls.
This is a cumulative item.
Trunk group tables
The number of calls that the agent transferred to another destination. 
Note that TRANSFERRED includes both inbound and outbound calls. 
Therefore, OTHERCALLS and O_OTHERCALLS may each include 
some TRANSFERRED. For Generic 3 switches, TRANSFERRED 
includes all calls that transferred.
This is a cumulative item.
VDN tables
Number of calls that were transferred to another destination. For Generic 
Generic 3 switches and for the ECS, TRANSFERRED includes all VDN 
calls transferred.
This is a cumulative item.
Agent trace tables
Whether or not an answering agent initiated a transfer for this call. Valid 
values are YES and NO. For Generic 3 switches, TRANSFERRED 
includes all calls that are transferred.
Call record tables
Whether or not an answering agent initiated a transfer for this call 
segment. Valid values are 0=NO, 1=YES. For Generic 3 switches and the 
ECS, TRANSFERRED includes all calls that are transferred. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-187
TRENDBASE2
Database tables2The TRENDBASE item appears in the following database tables:
Current day configuration tables
Base date for seasonal trending.
TRUNKS2
Database tables2The TRUNKS item appears in the following tables:
Trunk group tables
The current number of trunks assigned to this TKGRP.
This is an administrative item.
TSTAFFED
(real-time)
2
Database tables2The TSTAFFED item appears in the following database tables:
Split/skill tables
The current number of top agents that are staffed in SPLIT. Available with 
Generic 3 switches with the EAS feature. However, top database items 
are significant only for Generic 3 switches and the ECS with EAS. 
TSTAFFED = TAVAILABLE + TAGINRING + TONACD + TINACW + 
TINAUX + TOTHER.
This is a status item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-188
TYPE (real-time)2
Database tables2The TYPE (real-time) item appears in the following database tables:
Agent tables
The skill type (p for primary or s for secondary) associated with the 
SPLIT. Available on Generic 3 switches with EAS/vectoring feature. Note: 
For the ECS and later switch releases with the EAS feature, skill level 1 
will be represented by p, skill level 2 by s and skill levels 3-16 by 
blank. Users of more than 2 skill levels should use SKLEVEL items 
instead of SKILLTYPE items.
This is a status item.
UCID2
Database tables2The UCID item appears in the following database tables:
Agent trace tables
The UCID is the Universal Call Identifier-a unique number assigned to 
this call segment within the customer network. Requires the 
DEFINITY 
ECS R6 and later.
Call record tables
The UCID is the Universal Call Identifier-a unique number assigned to 
this call segment within the customer network. Requires the 
DEFINITY 
ECS R6 and later.
USE_SVC_OBJ
(real-time)
2
Database tables2The USE_SVC_OBJ item appears in the following database tables:
Agent tables
The agent requests calls based on the administered service objective for 
this skill. Values are 1=YES, 2=NO. Requires a DEFINITY ECS R6 or 
later with EAS. 
This is a status item.