Cisco Cisco E-Mail Manager Unity Integration Option Riferimenti tecnici
2-189
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Schedule_Report_Input Table
Related tables:
Schedule (via ScheduleReportID)
Schedule Report Input (via ScheduleReportID)
Schedule_Report_Input Table
Specifies the targets that are used with a template to create a schedule report.
TemplateCategory
For a template-based report, the category used to
locate the template.
locate the template.
varchar(32)
NULL
TemplateScope
For a template-based report, the scope used to locate
the template.
the template.
varchar(32)
NULL
TemplateName
For a template-based report, the name of the template
used to create the report.
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.
template: /H to include the SQL header and column
name information; /A to append to the output file.
varchar(255)
NULL
Description
Additional information about the report.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-150 Schedule_Report Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-151 Schedule Report_Input Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ScheduleReportInputID
A unique identifier for the report input row.
int
PK, NOT NULL
ScheduleReportID
Identifies the associated schedule report.
int
FK,
TargetType
Type of table to which the ForeignKey applies:
0
=
Unknown
1
=
Service
2
=
Skill Group
3
=
Agent
4
=
Translation Route
5
=
Agent Administration Group
6
=
Announcement
7
=
Call Type
8
=
Enterprise Service
9
=
Enterprise Skill Group
10
=
Region
11
=
Dialed Number
int
NOT NULL