Technical References

Keys and Null Option:Data Type:Description:Field Name:
NULLDBINT
The number of bit positions to shift the value to the left.
Shift
PK NOT NULLDBINT
A unique identifier for the column.
ViewColumnID
AK-2 NOT NULLVNAME32
The name used for the column within the ICM software.
ViewName
Vru_Currency Table
This is one of the VRU_Micro_Application (page 463) tables. For database rules, click here
(page 513).
This table contains a list of currencies supported by VRU micro-applications.
Related table
VRU Defaults (page 435) (via CurrencyID)
Table 218: Indexes for View_Currency Table
index_keysindex_descriptionindex_name
CurrencyNamenonclustered, unique, unique key
located on PRIMARY
XAK1Vru_Currency
CurrencyIDclustered, unique, primary key
located on PRIMARY
XPKVru_Currency
Fields in Vru_Currency Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
PK NOT NULLDBINT
A unique identifier.
CurrencyID
AK-1 NOT NULLvarchar(10)
Specifies the currency supported by the VRU micro-application:
CurrencyName
• 1 = U.S. Dollar (default)
• 2 = Euro
• 3 = Pound Sterling
• 4 = French franc
• 5 = Deutschmark
• 6 = Lira
• 7 = Peseta
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
434
Chapter 2: All Tables
Vru_Currency Table