Cisco Cisco E-Mail Manager Unity Integration Option Riferimenti tecnici
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.
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
Option
CampaignID
The campaign to which this target sequence belongs.
Foreign key from the Campaign table.
Foreign key from the Campaign table.
int
PK1, NOT
NULL
NULL
Sequence
Part of the primary key. Indicates the sequence of the
number to dial within a campaign.
number to dial within a campaign.
smallint
PK2, NOT
NULL
NULL
RangeType
Part of the primary key:
H = Home range.
W = Work 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.
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
Option
DesktopSnapShotID
A unique identifier for the desktop snapshot.
int
PK, FK, NOT
NULL
NULL
ApplicationID
Identifies the application.
int
PK, FK, NOT
NULL
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