Cisco Cisco IP Contact Center Release 4.6.1 Technical References

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.

Schedule (viaScheduleID)

Each row describes a report used to export information from the ICM platform to a workforce 
management system.

ScheduleMapID

A unique identifier for the record.

int

PK, NOT NULL

ScheduleID

Foreign key that identifies the schedule.

int

FK, NOT NULL

FieldName

The name of a primary key field.

varchar(32)

NOT NULL

FieldValue

The value of the primary key field for the schedule.

varchar(255)

NOT NULL

Description

Additional information about the key field.

varchar(255)

NULL

ChangeStamp

Incremented when the record is changed in the central 
database.

int

NOT NULL

ScheduleReportID

A unique identifier for the report.

int

PK, NOT NULL

EntityID

If partitioning is enabled, indicates the business entity 
to which the schedule belongs.

int

AK1, NOT 
NULL

EnterpriseName

A name that is unique among all schedule reports 
defined in the ICM database.

varchar(32)

AK1, NOT 
NULL

ReportType

The type of report: 

8 = Based on a template.
9 = Based on a SQL report.

int

NOT NULL

SystemName

For a SQL report, the name of the system containing 
the report.

varchar(32)

NULL

PathName

For a SQL report, the UNC name of the file.

varchar(255)

NULL

SystemTimeZone

For a template-based report, the time zone offset to use 
with the template.

varchar(255)

NULL