Cisco Cisco E-Mail Manager Unity Integration Option Technical References

EntityID, EnterpriseName

nonclustered, unique, unique key
located on PRIMARY

XAK1Schedule_Report

ScheduleReportID

clustered, unique, primary key
located on PRIMARY

XPKSchedule_Report

NOT NULL

CHANGESTAMP

Incremented when the record is changed in the central database.

ChangeStamp

NULL

DESCRIPTION

Additional information about the report.

Description

AK-1 NOT NULL

VNAME32

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

EnterpriseName

AK-1, FK NOT NULL

DBINT

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

EntityID

NULL

varchar(255)

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

PathName

NOT NULL

DBINT

The type of report:

ReportType

• 8 = Based on a template.

• 9= Based on a SQL report.

PK NOT NULL

DBINT

A unique identifier for the report.

ScheduleReportID

NULL

VNAME32

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

SystemName

NULL

varchar(255)

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

SystemTimeZone

NULL

VNAME32

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

TemplateCategory

NULL

varchar(255)

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

TemplateName

NULL

varchar(255)

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

TemplateOptions

NULL

VNAME32

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

TemplateScope

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)