Cisco Cisco IP Contact Center Release 4.6.2 Technical References

2-293

Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)

Chapter 2 Table Details

Schedule_Report Table

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

Table 2-305 Schedule_Report Table Constraints

Constraint

Field Name(s)

ScheduleReportID

AK-1

EnterpriseName
EntityID

EntityID

Table 2-306 Schedule_Report Table

Field Name

Description

Data Type

Keys and
Null Option

ChangeStamp

Incremented when the record is changed in the
central database.

CHANGESTAMP

NOT NULL

Description

Additional information about the report.

DESCRIPTION

NULL

EnterpriseName

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

VNAME32

AK-1

NOT NULL

EntityID

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

DBINT

AK-1, FK

NOT NULL

PathName

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

varchar(255)

NULL

ReportType

The type of report:

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

DBINT

NOT NULL

ScheduleReportID

A unique identifier for the report.

DBINT

NOT NULL

SystemName

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

VNAME32

NULL

SystemTimeZone

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

varchar(255)

NULL

TemplateCategory

For a template-based report, the category used to
locate the template.

VNAME32

NULL

TemplateName

For a template-based report, the name of the
template used to create the report.

varchar(255)

NULL

TemplateOptions

For a template-based report, options used with the
template: /H to include the SQL header and
column name information; /A to append to the
output file.

varchar(255)

NULL

TemplateScope

For a template-based report, the scope used to
locate the template.

VNAME32

NULL