Lucent Technologies Centrevu Report Designer Version 8 User Guide

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
CMS Database Table Basics18-9
lEvent counts (for example, ACDCALLS
, INTERFLOWCALLS
, 
ABNCALLS
, and so on)
lFor real-time and agent trace reports, current state data (for 
example, WORKMODE
, DURATION
, NUMINUSE
, and so on).
See the 
CentreVu CMS R3V8 Database Items and Calculations (585-
210-939) document for a description of database tables and items 
including the exceptions, forecast, and login/logout tables....

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
CMS Database Table Basics18-10
Using constants makes sense only if you have a fixed value that you 
want to use under one or both of the following conditions:
lThe constant is a value that you will use in a number of different 
custom reports (for example, an average wage rate).
lYou would not be able to remember the numerical value, but could 
remember a name assigned to the value (for example, for the $9.00 
hourly...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
CMS Database Table Basics18-11
Calculation names18A calculation name is a name, as defined in the Dictionary subsystem, 
that can substitute for the actual calculation. The calculation name can be 
a standard name (used in standard reports) or a name you define. You 
cannot append a table name to a calculation name. Therefore, you must 
specify a table name in the Table for calculations 
field.
A calculation name...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
CMS Database Table Basics18-12
Data from More 
Than One Table
18
A calculation can merge data from more than one table in a report field.
For example, you may want the percentage of a splits ACD calls that an 
agent handled in a day. Thus, you can enter a calculation that merges 
data from the Daily Agent and Daily Split tables, as in the following 
example.
dagent.ACDCALLS/dsplit.ACDCALLS
When you merge data from two...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Creating a Custom Data Table18-13
Creating a Custom Data Table18
The section of the CentreVuä Call Management System (CentreVu 
CMS) database that stores historical ACD data uses the 
INFORMIX *-
SQL Relational Database Management System. All historical ACD data 
available for use in custom reports is stored in tables in the 
CentreVu 
CMS database. You can access INFORMIX and the CentreVu CMS 
database to build your...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Creating a Custom Data Table18-14
To define a custom database table, complete the steps defined in the 
following sections.
Step 1: Access 
the 
CentreVu 
CMS Database in 
INFORMIX18
To perform these procedures, you must have purchased the INFORMIX 
SQL software.
To access the 
INFORMIX SQL software, you need to log into the CMS 
using 
CentreVu Terminal.
To access the 
CentreVu CMS database in INFORMIX, use the...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Creating a Custom Data Table18-15
Step 2: Build the 
Ta b l e
18
In INFORMIX, you can select menu items in one of two ways:
lUse the arrow keys (® or ¬) to move the cursor to the menu option. 
Then, press  .
lType the first character of the menu option
To escape from a step and go back to the previous step, press the Delete 
key on your keyboard.
2a.At the 
INFORMIX Main 
Menu, select Table
.®The Select Database...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Creating a Custom Data Table18-16
The available data types are as follows:2f.Type a name of up to 18 
characters for the column 
you are adding. If desired, 
you can use names of 
standard 
CentreVuCMS 
database items only if you 
enter the name in lowercase 
letters in the Dictionary 
subsystem. The Dictionary: 
Custom Items window 
accepts only lowercase 
letters for custom item 
names that are the same as 
standard...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Creating a Custom Data Table18-17
Interval
The Interval data type is not supported by CMS. 
An interval column allows you to specify an 
interval 
qualifier of year, month, day, hour, or minute.
MoneyThe Money data type is not supported by CMS.
If you data will be dollars and cents, you should use 
Decimal.
2g.Select the type of data that 
the field will store.®The additional prompts that 
appear differ depending on...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Creating a Custom Data Table18-18
DUPLICATES
Enter y 
if you want to allow the column to contain 
the same value in different rows. For example, if 
the column were to contain the last names of 
people, you would probably want to allow multiple 
entries (because, for example, you might have 
many different people with the last name of 
Smith).
However, if you were creating a column of social 
security numbers, then...