Cisco Cisco IPCC Web Option Installation Guide
5-9
WebView Installation and Administration Guide for Cisco Enterprise & Hosted Editions, Release 7.0(0)
Chapter 5 The WebView Database
WebView Database Tables
The Print Jobs Table
This table contains one record for each scheduled print job (print and save to file). The table refers to
the Report table for report parameters.
the Report table for report parameters.
Table 5-2
Print Jobs Table
Field Name
Description
Constraint/Index
Database Table
Header
Database Table
Header
Data Types in
ICM/IPCC
databases
ICM/IPCC
databases
Allow
Nulls
Nulls
JobTrackID
A unique ID to track the print job
Primary Key
char(50)
No
Frequency
The number of times the print job is
to be run
to be run
char(1)
No
TokenValue
A random number generated from the
value of the job ID
value of the job ID
char(260)
No
JobTime
The time the print job is to be run
char(260)
No
Command
The command-line string that
schedules the print job
schedules the print job
char(1000)
No
ReportID
The unique ID identifying the report
to be printed
to be printed
int
No
DayDates
The day(s) and date(s) on which the
report is to be printed
report is to be printed
char(1000)
Yes
ClientJobID
The ID number of the job on the
WebView client computer where the
print job is created
WebView client computer where the
print job is created
int
Yes
ClientHost
The name of the WebView host
computer from which the print job is
printed
computer from which the print job is
printed
char(260)
Yes
PrintCount
The number of print jobs
int
No
ServerPrint
The server from which the job is
printed
printed
int
No
Printer
The name of the printer selected to do
the print job
the print job
char(260)
Yes
FileLocation
The location of the file to be printed
char(260)
Yes
SaveFileName
The file name of the print job
char(260)
Yes
OwnerIDint
The person who created the print job
int
Yes
Instance
The ICM instance where the print job
is created
is created
char(260)
No
ClientIP
The IP address of the computer on
which the print job is created.
which the print job is created.
char(16)
Yes
FileFormat
The format of the report to be
printed. For example: HTML, PDF,
or XLS
printed. For example: HTML, PDF,
or XLS
char(10)
Yes
PrinterPort
The port number to which the printer,
selected for the print job, is
connected
selected for the print job, is
connected
char(10)
Yes