Technical References

Table 170: Indexes for Schedule_Report Table
index_keysindex_descriptionindex_name
EntityID, EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Schedule_Report
ScheduleReportIDclustered, unique, primary key
located on PRIMARY
XPKSchedule_Report
Fields in Schedule_Report Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the report.
Description
AK-1 NOT NULLVNAME32
A name that is unique among all schedule reports defined in the ICM
database.
EnterpriseName
AK-1, FK NOT NULLDBINT
If partitioning is enabled, indicates the business entity to which the
schedule belongs.
EntityID
NULLvarchar(255)
For a SQL report, the UNC name of the file.
PathName
NOT NULLDBINT
The type of report:
ReportType
• 8 = Based on a template.
• 9= Based on a SQL report.
PK NOT NULLDBINT
A unique identifier for the report.
ScheduleReportID
NULLVNAME32
For a SQL report, the name of the system containing the report.
SystemName
NULLvarchar(255)
For a template-based report, the time zone offset to use with the
template.
SystemTimeZone
NULLVNAME32
For a template-based report, the category used to locate the template.
TemplateCategory
NULLvarchar(255)
For a template-based report, the name of the template used to create
the report.
TemplateName
NULLvarchar(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
NULLVNAME32
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)
313
Chapter 2: All Tables
Schedule_Report Table