Defining the data for a custom report
76 Avaya CMS Custom Reports
When you run the report, the decimal point and the decimal places will use up spaces in
the field. For example, if the field contains six spaces and you specify three decimal places
for the field, then data will be displayed with two characters to the left and three characters
to the right of the decimal point (for example,
12.344
).
Date
Select
Date
if the field expression is
ROW_DATE
. You must also specify a date format, with
appropriate punctuation. You can select a single format or a combination of formats. The
available formats are:
●
mm = Numerical month (for example,
12
for December)
●
MMM = Month represented by three letters (for example,
APR
for April).
●
yy = Year as two digits (for example,
94
)
●
YYYY = Year as four digits (for example,
1994
)
●
dd = Numerical day of the month (for example,
31
)
●
jjj = Day of the year in the Julian calendar (for example,
151
for May 31)
●
www = Day of the week as three letters (for example,
THU
)
String
Select
String
for those database items whose data CMS identifies as character strings,
not numbers. (Each of these items is identified as being a CHAR column type in INFORMIX
terminology.) Even though these items store numbers, CMS searches for values as if the
items stored nonnumeric symbols and alphabetic words, as well as numbers.
Database items for which you might select
String
are as follows:
●
VDN
(the value is a VDN number)
●
EXTENSION
(the value is an extension number)
●
LOGID
(the value is an agent login ID)
●
EQLOC
(the value is a 9-digit trunk location number)
●
CWC
(the value is a call work code)
●
Custom database items
with the CHAR column type
String, as used here, does not have the same meaning as string-value database item, as
defined for the Dictionary subsystem. For the purposes of custom report design, Dictionary
names for string-value database items are referred to as
Synonyms
, and include names
for agents, splits, VDNs, trunk groups, and vectors. In fact, for the
VDN
and
LOGID
database items, you may want to select
Synonym
, not
String
, since you may have
assigned names to VDNs and login IDs in the Dictionary subsystem.
