Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Leaflet
13
Cisco Customer Response Solutions Database Schema
Database Schema
Database Table Details
redirect
Was this call leg redirecting the call:
1 = redirect
0 = no
bit
NULL
metServiceLevel
Did the call meet the service level:
1 = met service level
0 = no
Note: Reserved for future use.
bit
NULL
originatorType
Originator of the call or the leg:
1—Agent. Call originated by an agent.
2—Device. Call originated by a
simulated caller. (Used for testing.)
simulated caller. (Used for testing.)
3—Unknown. Call originated by an
outside caller through a gateway or by
an unknown device.
outside caller through a gateway or by
an unknown device.
tinyint
NOT NULL
originatorID
Numeric identifier of the agent who
originated the call or the leg.
originated the call or the leg.
Used only if originatorType is 1.
int
NULL
originatorDN
If originatorType is 2, this field shows
the CTI
the CTI
port number.
If originatorType is 3, this field shows
the telephone number of the caller as
received by the Cisco Unified
CallManager, if available.
the telephone number of the caller as
received by the Cisco Unified
CallManager, if available.
Null if If originatorType is 1.
nvarchar(30)
NULL
Table 1-4
ContactCallDetail Table Fields (continued)
Field Name
Description
Storage