/mcpindex_keys index_description index_name ScheduleReportID clustered, unique, primary key located on PRIMARY XPKSchedule_Report Table 357: Fields in Schedule_Report Table Keys and NULL Option Data Type Description Name NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp 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 system 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: • 8 = Based on a template. • 9= Based on a SQL report. ReportType 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 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 436 All Tables Schedule_Report