Cisco Cisco IPCC Web Option Technical References
Schedule_Map Table
Identifies the primary key values from a schedule in the external data source from which it is
imported. Each schedule has one Schedule_Map row for each component of the primary key.
If the primary key is a compound key, the schedule has multiple Schedule_Map rows.
imported. Each schedule has one Schedule_Map row for each component of the primary key.
If the primary key is a compound key, the schedule has multiple Schedule_Map rows.
Related table
(viaScheduleID)
Table 169: Indexes for Schedule_Map Table
index_keys
index_description
index_name
ScheduleID
nonclustered located on PRIMARY
XIE1Schedule_Map
ScheduleMapID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKSchedule_Map
Fields in Schedule_Map Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
IAdditional information about the key field.
Description
NOT NULL
VNAME32
The name of a primary key field.
FieldName
NOT NULL
DESCRIPTION
The value of the primary key field for the schedule.
FieldValue
IE-1, FK NOT NULL
DBINT
Foreign key that identifies the schedule.
ScheduleID
PKNOT NULL
DBINT
A unique identifier for the record.
ScheduleMapID
Schedule_Report Table
Each row describes a report used to export information from the ICM platform to a workforce
management system.
management system.
Related tables
(via ScheduleReportID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
312
Chapter 2: All Tables
Schedule_Map Table