Enterprise Communications Server Accessing Data using Database Service Elements
619510003-1A Copyright © 2009 ADTRAN, Inc. 161
7. Select a sort mode, and enable Descending if you wish the results to be sorted in a descending order.
When you choose a System Value in an element of a service, the information is taken from the current
call and from within your system and used, for example, to fetch a value for a Fetch Data element.
Table 12–1: System values
Name Description Example Format
Today A UC server Date value representing today’s
date.
December 25, 2006
Current Time A UC server Time of Day value representing the
current time.
Format depends on location.
For US and Canada, 12:02
PM.
User Name The user profile name of the profile that owns
the called extension.
Paul Smith
User Extension The extension number where the call was
initially received.
224
Selected User Name If a Select Extension element is executed, this
is the user profile name of the profile that owns
the selected extension. Otherwise, it is User
Name.
Mark Jones
Selected Extension If a Selected Extension element is executed,
this is the selected extension. Otherwise, it is
User Extension.
225
Caller Name The same as Matched Contact Name, if the
matched contact name is not blank. If it is, the
value of Caller-Id.
Paul Smith
Caller-Id A UC server Text Value representing the caller.
Typically, it is the form “name [number]”.
However, if the name is blank, it is in the form
“number”. It might also have special values,
such as <Private Number>, <Long Distance> or
<Unknown Caller>. Phone number format
depends on the underlying transport.
Paul Smith [613-599-9698]
Caller-Id Name A UC server Text Value containing the caller
name as provided by the underlying transport.
Paul Smith
Caller-Id Number A UC server Text Value containing the raw caller
telephone number as provided by the
underlying transport.
613-599-9698
Caller-Id Canonical
Number
A UC server Phone Number Value containing
the complete, formatted number.
+1 (613) 599-9698
Caller-Id Area Code A UC server Text Value containing the area
code of the number.
613
Caller-Id Area Code/
Exchange
A UC server Text Value containing the area
code and the exchange.
613599
Caller-Id Exchange A UC server Text Value containing the
exchange.
599