Lucent Technologies CentreVu Call Management System Release 3 Version 8 Manual

  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-169
Agent tables
This is an index item.
The split number to which the EXTENSION is assigned to or the skill 
number that the agent logged into.
This is a row identifier item.
Trunk group tables
The split/skill to which this TKGRP terminates.
This is an administrative item.
Trunk tables
This is a real-time item.
The first split/skill number to which the call is currently queued or 
split/skill for which...

  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-170
SPLIT12
Database tables2The SPLIT1 item appears in the following database tables:
Call record tables
First split/skill the call queued to in the first VDN with which it was 
associated in the call segment.
SPLIT2-32
Database tables2The SPLIT2 ... 3 items appear in the following database tables:
Trunk tables
This is a real-time item.
The split/skill numbers of the second and third splits/skills to...

  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-171
STARTED 
(real-time)
2
Database tables2The STARTED (real-time) item appears in the following database tables:
Agent tables
Time of day that WORKMODE began. Valid values for STARTED are 
NULL and time-of day.
This is a status item.
Trunk tables
The time of day that TKSTATE started. Valid values are NULL and time-
of-day
This is a status item.
STARTTIME2
Database tables2The STARTTIME item appears in the...

  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-172
Vector tables
This is a real-time item.
Start time of the interval for which data was collected. STARTTIME 
applies only to the interval table.
This is a row identifier item.
VDN tables
Start time of the interval for which data was collected. STARTTIME 
applies only to the interval table. STARTTIME is a table index for the VDN 
table.
This is a row identifier item.
Call work codes tables
Start time of...

  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-173
TAGINRING
(real-time)
2
Database tables2The TAGINRING item appears in the following database tables:
Split/skill tables
The number of top agents logged into the skill who have ACD calls 
ringing and who are not doing anything else. 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...

  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-174
TDA_INACW
(real-time)
2
Database tables2The TDA_INACW 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 
associated with direct agent calls. TDA_INACW is a subset of TOTHER. 
Requires a Generic 3 switch with the ASAI or EAS feature for direct agent 
calling. Available with Generic 3 switches. However, top...

  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-175
Trunk group exception table
Limit, as a number of occurrences, administered for the exception type. 
An exception occurs when the trunk groups activity falls outside of that 
limit.
This is a cumulative item.
VDN exception table
Limit, as a number of occurrences, administered for the exception type. 
An exception occurs when the VDN activity falls outside of that limit.
This is a cumulative item....

  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-176
TI_AUXTIME02
Database tables2The TI_AUXTIME0 item appears in the following database tables:
Agent tables
The time the agent spent in AUX with reason code 0 (zero). This is time 
in system AUX for switches with AUX reason codes active. It is the 
same as TI_AUXTIME for switches without AUX reason codes active. 
TI_ time is only stored for the skill logged in to the longest. TI_ time 
needs to be summed...

  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-177
TI_AVAILTIME2
Database tables2The TI_AVAILTIME item appears in the following database tables:
Agent tables
The time during the collection interval that the agent was in the available 
state for split/skill or direct agent ACD calls in any split/skill. 
TI_AVAILTIME is recorded for the split/skill that was the 
OLDEST_LOGON. For a non-EAS operation, if an agent logged into 
multiple splits and is in...

  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-178
TI_STAFFTIME2
Database tables2The TI_STAFFTIME item appears in the following database tables:
Agent tables
The time during the collection interval that the agent was staffed in any 
split/skill. TI_ time is only stored for the split/skill logged into the longest. 
TI_ time needs to be summed across the splits/skills the agents may log 
in to, in case the login order changes during the collection...