Lucent Technologies CentreVu Call Management System Release 3 Version 8 Manual

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-119
Trunk group exception table
Login ID of the agent reporting audio difficulty.
This is a cumulative item.
Malicious call trace exception table
Login ID of the agent initiating a malicious call trace.
This is a cumulative item.
LOGIN2
Database tables2The LOGIN item appears in the following database tables:
Agent login/logout tables
Time at which the agent logged into this extension and split/skill with the 
given login ID. This field is a standard UNIX time field; that is, the time is 
stored as the number of seconds since January 1, 1970.
LOGONSKILL 
(real-time)
2
Database tables2The LOGONSKILL (real-time) item appears in the following database 
tables:
Agent tables
The first split/skill the agent logged in with. Requires a Generic 3 switch 
with EAS.
This is a status item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-120
LOGONSKILL2-
20
(real-time)
2
Database tables2The LOGONSKILL2-20 item appears in the following database tables:
Agent tables
This is a real-time item.
The second through twentieth skills the agent logged in with. The number 
of skills per agent depends on the type of switch. Available on the ECS 
with the EAS feature and Generic 3 switches with the EAS feature.
This is a status item.
Agent login/logout tables
The second through twentieth skills the agent logged in with. NOTE: The 
number of skills per agent depends on the type of switch. Available on 
the ECS with the EAS feature and later Generic 3 switches with the EAS 
feature.
LOGONSTART 
(real-time)
2
Database tables2The LOGONSTART (real-time) item appears in the following database 
tables:
Agent tables
The time of day that the agent logged into this SPLIT. This field is not set 
unless the agent is logged in. If the agent has not logged in during the 
collection interval, the value will be blank. Valid values are null and time-
of-day.
This is a status item.
LOGOUT2
Database tables2The LOGOUT item appears in the following database tables:
Agent login/logout tables
Time at which the agent logged out. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-121
LOGOUT_DATE2
Database tables2The LOGOUT_DATE item appears in the following database tables:
Agent login/logout tables
Date on which the agent logged out. This field is a standard UNIX time 
field; that is, the time is stored as the number of seconds since January 1, 
1970.
LOGOUTREA-
SON
2
Database tables2The LOGOUTREASON item appears in the following database tables:
Agent login/logout tables
Reason code (0 through 9) associated with the agents logout. For switch 
releases earlier than the ECS or switch releases that do not have the 
EAS feature and reason codes active, this field will always contain a 0 
when the agent has logged out.
Agent trace tables
Reason code (0 through 9) associated with the agents logout. For switch 
releases earlier than the ECS or switch releases that do not have the 
EAS feature and reason codes active, this field will always contain 0 
when the agent has logged out.
LOOKATTEMPTS2
Database tables2The LOOKATTEMPTS item appears in the following database tables:
Vector tables
The time all GOTOCALLS spent in this vector before being redirected to 
another vector. Available on Generic 3 switches and on the ECS.
This is a cumulative item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-122
VDN tables
The number of look-ahead interflow attempts for calls in this VDN. 
Available on Generic 3 switches and on the ECS with the vectoring and 
look-ahead interflow features. LOOKATTEMPTS includes 
LOOKFLOWCALLS.
This is a cumulative item.
LOOKFLOW-
CALLS
2
Database tables2The LOOKFLOWCALLS item appears in the following database tables:
Vector tables
Number of INTERFLOWCALLS that were redirected by way of the 
Lookahead Interflow feature. Available on Generic 3 switches with the 
Lookahead Interflow feature.
This is a cumulative item.
VDN tables
Number of INTERFLOWCALLS that were redirected by way of the 
Lookahead Interflow feature. Available on Generic 3 switches with the 
Lookahead Interflow feature.
This is a cumulative item.
LOWCALLS2
Database tables2The LOWCALLS item appears in the following database tables:
Split/skill tables
For switches with vectoring, this is the number of ACDCALLS with low 
priority that were answered by this split/skill. For switches without 
vectoring, this is the number of ACDCALLS with no priority that were 
answered by this split/skill.
This is a cumulative item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-123
MALICIOUS
(real-time)
2
Database tables2The MALICIOUS item appears in the following database tables:
Agent tables
This is a real-time item.
This indicates whether a malicious call trace is active for the agent for 
any split/skill. Values for MALICIOUS are 0= NO, 1 = YES. Available on 
Generic 3 switches (except for Generic 3i Version 1 switches).
This is a status item.
Call record tables
Indicates whether or not a malicious call trace was activated for this call 
segment. Valid values for MALICIOUS are 0=NO, 1=YES. Applies to the 
ECS and Generic 3 switches.
MAXINQUEUE2
Database tables2The MAXINQUEUE item appears in the following database tables:
Split/skill tables
Maximum number of simultaneous calls in this splits/skills queue during 
the collection interval.
This is a maximum value item.
MAXOCWTIME2
Database tables2The MAXOCWTIME item appears in the following database tables:
Split/skill tables
Maximum amount of time that a call, recorded during the collection 
interval, waited in queue and ringing before an agent answered in this 
split/skill, the caller abandoned, or the call was redirected, received a 
busy signal, or was disconnected.
This is a maximum value item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-124
VDN tables
The maximum time that a call, recorded during the collection interval, 
waited in the VDN before being answered (ACD calls) or connected (non-
ACD calls), abandoning, being redirected, receiving a busy signal or 
being disconnected. This applies only to the first disposition of the call.
This is a maximum value item.
MAXSTAFFED2
Database tables2The MAXSTAFFED item appears in the following database tables:
Split/skill tables
Maximum number of agent POSITIONS that were simultaneously staffed 
during the collection interval. MAXSTAFFED includes MAXTOP.
This is a maximum value item.
MAXTOP2
Database tables2The MAXTOP item appears in the following database tables:
Split/skill tables
Maximum number of top agents that were staffed during the collection 
interval in this split/skill.
This is a maximum value item.
MAX_TOT_
PERCENTS
2
Database tables2The MAX_TOT_PERCENTS item appears in the following database 
tables:
Split/skill tables
The maximum total staffed agent percentages allocated to a skill. 
Requires a DEFINITY ECS R6 or later with EAS. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-125
MAXWAITING2
Database tables2The MAXWAITING item appears in the following database tables:
VDN tables
Maximum number of calls simultaneously in progress in the VDN during 
the collection interval.
This is a maximum value item.
MBUSY (real-
time)
2
Database tables2The MBUSY (real-time) item appears in the following database tables:
Trunk group tables
The current number of trunks in the trunk group that are maintenance 
busy.
This is a status item.
MBUSYTIME2
Database tables2The MBUSYTIME item appears in the following database tables:
Trunk group tables
The total time during the collection interval that trunks in the trunk group 
were maintenance busy.
This is a cumulative item.
Trunk tables
The total time during the collection interval that this trunk was 
maintenance busy.
This is a cumulative item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-126
MCT2
Database tables2The MCT item appears in the following database tables:
Agent trace tables
The agent activated a malicious call trace. Available on Generic 3 
switches.
MEDCALLS2
Database tables2The MEDCALLS item appears in the following database tables:
Split/skill tables
For switches with vectoring, the number of ACDCALLS with medium 
priority that were answered by agents in the split/skill. For example, 
answered calls that were queued to the split/skill with medium priority by 
a queue to main or check backup vector command.
For Generic 3 with vectoring, MEDCALLS includes calls that were 
queued to a split/skill with no priority using the route to or messaging split 
vector commands, calls that queued directly to a non-vector-controlled 
split with no priority, and calls that intraflowed to a split/skill with no 
priority.
For switches without vectoring, the number of ACDCALLS with yes 
priority that were answered by agents in the split/skill.
This is a cumulative item.
MOVEPENDING 
(real-time)
2
Database tables2The MOVEPENDING (real-time) item appears in the following database 
tables:
Agent tables
This is an administrative item. move to a new split or skill or a change of 
skills is pending for this agent. This is only available for G3V4 and newer 
switches with the Move Agent While Staffed feature. Values for 
MOVEPENDING are 0= NO, 1 = YES.
This is a status item. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-127
NETDISCCALLS2
Database tables2The NETDISCCALLS item appears in the following database tables:
Vector tables
Number of disconnected calls for the reply step in BSR. Requires the 
DEFINITY ECS R6 and later.
This is a cumulative item.
VDN tables
Number of calls that disconnected from the BSR reply step. Requires the 
R6 and later ECS.
This is a cumulative item.
NETINCALLS2
Database tables2The NETINCALLS item appears in the following database tables:
VDN tables
Calls that interflowed in from the network in BSR. Requires the R6 and 
later ECS.
This is a cumulative item.
NETINTIME2
Database tables2The NETINTIME item appears in the following database tables:
VDN tables
Time, in seconds, that the call was in a VDN somewhere else in the 
network. Requires the R6 and later ECS.
This is a cumulative item.
Call record tables
The time the call spent in a VDN processing at another switch located 
elsewhere in the network. Requires the 
DEFINITY ECS R6 and later. 
						

							  Database Items and Calculations CentreVu® CMS R3V8 Database Items and Calculations
Database Items2-128
NETPOLLS2
Database tables2The NETPOLLS item appears in the following database tables:
Vector tables
Number of network polls for the consider steps in BSR. Requires the 
DEFINITY ECS R6 and later.
This is a cumulative item.
VDN tables
Number of network polls for BSR consider steps. Requires the R6 and 
later ECS.
This is a cumulative item.
NOANSREDIR2
Database tables2The NOANSREDIR item appears in the following database tables:
Split/skill tables
Number of split/skill ACD calls that rang at agent positions in the split/skill 
and then were automatically redirected back to the split/skill queue or to a 
VDN by the Redirection on No Answer feature because they were not 
answered.
Available on Generic 3 Version 2 and newer switches.
Note: When a call is requeued to the same split/skill using the 
Redirection on No Answer feature, it is counted as an outflow from the 
split/skill and an inflow to the same split/skill. This is 
not true for calls that 
are redirected to a VDN using the Redirection on No Answer feature, 
rather than redirecting the call back to the same split/skill.
Such calls count as outflows from the original split or skill, but do not 
count as inflows to the next split/skill to which they are queued through 
the new VDN. It is also counted as a NOANSREDIR call and so can be 
subtracted out from the outflows and from the inflows to calculate the 
number of outflows and inflows that were not due to requeuing the call to 
the same split.
This is a cumulative item.