Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Unified Contact Center Enterprise 9.0(2)
  5. Technical References

Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

Download
Page of 404
 
2-61
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Campaign_Target_Sequence Table
Campaign_Target_Sequence Table 
Not currently used by the ICM software.
Related tables:
Campaign (via CampaignID)
Cfg_Mngr_App_Snapshot_State Table  
This table defines a specific state of the ICM Configuration Manager user interface that a user has saved. 
Information from this table is used to reconstruct the state of the ICM Configuration Manager when the 
Admin Workstation is restarted.
Table 2-37 Campaign_Target_Sequence able
Field Name
Description
Data Type
Keys and Null 
Option
CampaignID 
The campaign to which this target sequence belongs. 
Foreign key from the Campaign table.
int
PK1, NOT 
NULL
 Sequence
Part of the primary key. Indicates the sequence of the 
number to dial within a campaign.
smallint
PK2, NOT 
NULL
 RangeType
Part of the primary key:
H = Home range.
W = Work range.
int
NOT NULL
 TargetType
The type of target number:
H1..Hn = Home phone 1 through home phone n. 
W1..Wn = Work phone 1 through work phone n.
char(2)
NOT NULL
Table 2-38 Cfg_Mngr_App_Snapshot_State Table
Field Name
Description
Data Type
Keys and Null 
Option
DesktopSnapShotID
A unique identifier for the desktop snapshot. 
int
PK, FK, NOT 
NULL
ApplicationID
Identifies the application.
int
PK, FK, NOT 
NULL
Filter1
ID for the first filter key of the application. 
int
NULL
Filter2
ID for the second filter key of the application.
int
NULL
Filter3FieldName
A field name used for the third filter criteria.
varchar(32)
NULL
Filter3FieldType
A field type identifier used for text/numeric lookup.
smallint
NULL
Filter3OptionSelection
The selection type.
smallint
NULL
Filter3Selection
The selection value.
varchar(255)
NULL
POSX
The application’s X position on the desktop.
smallint
NULL