Technical References

Schedule_Map Table
This table is in the Schedule category (page 450). To see database rules, click here (page 508).
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.
Related table
Schedule (page 305) (viaScheduleID)
Table 169: Indexes for Schedule_Map Table
index_keysindex_descriptionindex_name
ScheduleIDnonclustered located on PRIMARYXIE1Schedule_Map
ScheduleMapIDclustered, unique, primary key
located on PRIMARY
XPKSchedule_Map
Fields in Schedule_Map Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
IAdditional information about the key field.
Description
NOT NULLVNAME32
The name of a primary key field.
FieldName
NOT NULLDESCRIPTION
The value of the primary key field for the schedule.
FieldValue
IE-1, FK NOT NULLDBINT
Foreign key that identifies the schedule.
ScheduleID
PKNOT NULLDBINT
A unique identifier for the record.
ScheduleMapID
Schedule_Report Table
This table is in the Schedule category (page 450). To see database rules, click here (page 508).
Each row describes a report used to export information from the ICM platform to a workforce
management system.
Related tables
Schedule (page 305) (via ScheduleReportID)
Schedule Report Input (page 314) (via ScheduleReportID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
312
Chapter 2: All Tables
Schedule_Map Table