Lucent Technologies CentreVu Call Management System Custom Reports Manual

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-1
6 Advanced Report Design
Creating a Custom Data Table6
The section of the CentreVuä Call Management System (CentreVu CMS) 
database that stores historical ACD data uses the 
INFORMIX *SQL (ISQL) 
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 
own...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-2
To define custom data tables, use the steps described in the following pages.
CautionIf you back up data using the Maintenance — Backup Data window, 
the data stored in custom 
INFORMIX tables will be saved, but the 
custom table definitions (table names, column names, data 
types, and so on) will not be saved. As a result, if you lose the 
custom table definitions because of a disk crash, power hit, or 
some other...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-3
Step 1: Access 
the 
CentreVu 
CMS Database 
in 
INFORMIX6
To access the CentreVu CMS database in INFORMIX, use the following 
steps:
1a.Press the   SLK.®
The Commands submenu 
appears.
1b.Select the UNIX option.®All windows and menus 
disappear, and the UNIX 
prompt appears.
1c.At the $ prompt, type the following 
command: 
DBPATH=/cms/db/inf. Press 
the   key. Type export 
DBPATH. Press the   key.®The UNIX prompt...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-4
Step 2: Build 
the Table
6
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.
NoteTo escape from a step and go back to the previous step, press   
or  , depending on your keyboard.
2a.At the 
INFORMIX Main Menu, 
select Table.®The Select Database 
screen appears.
Return
Delete
Del...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-5
CREATE TABLE >>
Enter the table name you wish to create with the schema editor.
------------------ cms --------------------- Press CTRL-W for Help --------
2d.Type a name of up to 18 characters 
for the table you are building. The 
table name must begin with c_ (a 
lower-case “c” and underscore). For 
example, type c_workcode. Press 
the 
 key.®
The Create Table menu 
appears with a highlighted 
box beneath “Column...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-6
The available data types are in the following table.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 database items. Press the...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-7
Table 6-1:  Data Types
CharCharacter (CHAR) columns store any combination 
of letters, numbers, and symbols.
NumberNumeric columns store numbers. The numbers 
stored can be one of the following five types:
—Decimal. A decimal is a number that contains 
a decimal point.
—Smallint. A Smallint column stores integers 
from -32,767 to +32,767.
—Integer. An Integer column stores integers 
from -2,147,483,647 to...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-8
2g.Select the type of data that the field 
will store.®The additional prompts that 
appear differ depending on 
your selected data type.
2h.Complete the definition of the 
column by responding to the 
additional prompts that appear. 
Which prompts appear and what 
order they appear in depend on the 
data type you selected. Table 6-2
 
lists the possible prompts.®
When you have responded 
to all of the prompts for the...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-9
NULLSEnter y if you want to allow the column to have 
rows with no values (versus requiring values). For 
example, if your table is a list of customer data and 
the column you are adding is for the customer’s 
employer, you might want to allow the NULL value 
for the case where the person is unemployed. 
Enter n if you want to require a value in each row. 
NULLS appears for all types except Serial.
ADD STARTING...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-10
 
ALTER TABLE c_workcode : Add Modify Drop  Screen Exit
Adds columns to the table above the line with the highlight.
------ Page 1 of 1 --------- cms -------- Press CTRL-W for Help --------
Column Name Type Length Index Nulls
cwc Char 16 Unique No
price Decimal 8.2 No
......................................
..
......................................
2k.Select Exit.®The Build-new-table menu 
appears.
 
Exit c_workcode:...