Technical References

Keys and
Null Option:
Data Type:Description:Field Name:
NULLchar(4)
This eld is reserved.
Unused
NULLvarchar(131)
ISDN private network User to User information.
UserToUser
NULLvarchar(40)
User dened call variable.
Variable1
NULLvarchar(40)
User dened call variable.
Variable2
NULLvarchar(40)
User dened call variable.
Variable3
NULLvarchar(40)
User dened call variable.
Variable4
NULLvarchar(40)
User dened call variable.
Variable5
NULLvarchar(40)
User dened call variable.
Variable6
NULLvarchar(40)
User dened call variable.
Variable7
NULLvarchar(40)
User dened call variable.
Variable8
NULLvarchar(40)
User dened call variable.
Variable9
NULLvarchar(40)
User dened call variable.
Variable10
NULLDBINT
The VRUProgress call variable value.
VruProgress
NULLDBINT
Number of VRU Script nodes encountered by the call..
VruScripts
Route_Call_Variable Table
This table is in the Route category (page 447). To see database rules for these tables, click here
(page 507).
This table can become very large. Running custom reporting queries against it while it is on the
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
Central database only.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
283
Chapter 2: All Tables
Route_Call_Variable Table