Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.2
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Download
Page of 404
 
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.
varchar(32)
NULL
TemplateScope
For a template-based report, the scope used to locate 
the template.
varchar(32)
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
Description
Additional information about the report.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL
Table 2-150 Schedule_Report Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-151 Schedule Report_Input Table
Field Name
Description
Data Type
Keys and Null 
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