By default, one database containing these database tables are defined by the data
collectors supplied with the Reports feature.
Database Table
Purpose
Default Properties
job_history
Holds the values of job properties specified in the Job Step Progress collector. Values are stored at the beginning and end of processing in each step
of a workflow.
Job.Instance
Job.TotalSheets
Job.TotalPages
Job.SubmitTime
Job.JobType
Job.PersistenceID
Job.InputDatastream
Job.InputFile
Job.CustomerName
Job.RetainDuration
Job.Promote
Job.PromoteTime
Job.ParentJob
Job.FileReceiptTime
Job.SourceInputDeviceName
Job.JobSize
Job.RequestedPrinter
Job.Destination
Job.Form
Job.Class
Job.Duplex
Job.Copies
Job.Name
Job.PreviousPrinter
Job.ReprintCount
Job.Info.Attr1
Job.Info.Attr2
Job.Info.Attr3
Job.Info.Attr4
Job.Info.Attr5
job_printing
Holds the values of job and printer properties specified in the Job Print Progress collector. Values are stored when a job starts printing and when it finishes printing
successfully.
Job.ID
Job.PersistenceID
Job.Phase
Job.Process
Job.Step
Job.State
Job.Instance
Job.JobType
Job.TotalSheets
Job.TotalPages
Job.Priority
Job.InputDatastream
Job.CustomerName
Job.Locations
Job.SystemName
Job.JobSize
Job.Media
Job.Staple
Job.Punch
Job.OutputBin
Job.RealPageRange
Job.Print.EndPrintTime
Job.Info.Attr1
Job.Info.Attr2
Job.OutputFormat
Job.Ink.Cyan
Job.Ink.Magenta
Job.Ink.Yellow
Job.Ink.Black
Job.SheetsStacked
Job.PagesStacked
Job.CopiesStacked
Job.CurrentPrinter
Job.Destination
Job.Form
Job.Class
Job.Duplex
Job.Copies
Job.Name
Job.Print.AssignPrintTime
Job.ReprintCount
Job.PreviousPrinter
Printer.ID
Printer.CustomerName
Printer.Description
Printer.Destination
Printer.DeviceModelSNMP
Printer.Instance
Printer.Locations
Printer.Model
Printer.Model.Specific
Printer.OutputFormat
Printer.SerialNumber
Printer.SystemName
Printer.Version
job_step_durations
Holds the values of job properties specified in the Job Step Duration collector. Values are stored at the completion of each step in the workflow.
Job.Class
Job.Copies
Job.CustomerName
Job.Destination
Job.Duplex
Job.FileReceiptTime
Job.Form
Job.JobSize
Job.JobType
Job.Info.Attr1
Job.Info.Attr2
Job.Info.Attr3
Job.Info.Attr4
Job.Info.Attr5
Job.InputDatastream
Job.InputFile
Job.Insert.ReconcileUser.ID
Job.Instance
Job.Locations
Job.Name
Job.ParentJob
Job.PersistenceID
Job.PreviousPrinter
Job.Priority
Job.Promote
Job.PromoteTime
Job.RequestedPrinter
Job.ReprintCount
Job.RetainDuration
Job.ScheduleUserId
Job.SourceInputDeviceName
Job.SubmitTime
Job.TotalPages
Job.TotalSheets
order_status
Holds the values of order properties specified in the Order Status collector. Values are stored each time when the order is created, changes state,
or is deleted.
Note:
This table is created only if the Order Management feature is installed.
Order.Reference
Order.Name
Order.Customer
Order.Location
Order.State
Order.DueDate
printer_status
Holds the values of printer properties specified in the Printer Status collector. Values are stored each time that the Enabled status or Printer status
changes.
Printer.Status
Printer.ID
Printer.CustomerName
Printer.Description
Printer.Destination
Printer.DeviceModelSNMP
Printer.Instance
Printer.Locations
Printer.Model
Printer.Model.Specific
Printer.OutputFormat
Printer.SerialNumber
Printer.SystemName
Printer.Version
barcode_reader_actions
Holds the values of barcode reader and user properties specified in the User Actions on Barcode Readers collector.
BarcodeReader.ID
BarcodeReader.Description
BarcodeReader.Location
User.ID
User.Description
User.Groups
User.Location
input_device_actions
Holds the values of input device and user properties specified in the User Actions on Input Devices collector.
InputDevice.ID
InputDevice.Type
InputDevice.Locations
InputDevice.Description
User.ID
User.Description
User.Groups
User.Location
inserter_actions
Holds the values of inserter controller and user properties specified in the User Actions on Inserters collector.
InserterController.ID
InserterSystem.Location
InserterSystem.Description
User.ID
User.Description
User.Groups
User.Location
job_actions
Holds the values of job and user properties specified in the User Actions on Jobs collector.
Job.ID
Job.Name
Job.JobType
Job.ParentJob
Job.Info.Attr1
Job.Info.Attr2
Job.Info.Attr3
Job.Info.Attr4
Job.Info.Attr5
User.ID
User.Description
User.Groups
User.Location
printer_actions
Holds the values of printer and user properties specified in the User Actions on Printers collector.
Printer.ID
Printer.TCPIP.Address
Printer.Type
Printer.Description
Printer.Destination
Printer.DeviceModelSNMP
Printer.Instance
Printer.Locations
Printer.Model
Printer.Model.Specific
Printer.SerialNumber
Printer.Version
User.ID
User.Description
User.Groups
User.Location
user_actions
Holds the values of user and target user properties specified in the User Actions on Users collector.
User.ID
User.Description
User.Groups
User.Location
Additional database tables
The WritePropsToReportsDatabase step also stores property values in database tables. The step always stores these
job property values in the database tables that you specify for the Job properties table and Document properties table properties:
Job.ID
Job.Phase
Job.Process
Job.Reports.EventType
Job.State
Job.Step
You choose the names of those tables when you add the step to a workflow. The default
table names are:
job_workflow_props
In addition to the properties listed above, the step stores property values for the
job properties that you select in the Job properties to write field.
doc_workflow_props
In addition to the properties listed above, the step stores document property values
for the document properties that you select in the Document properties to write field.
Property values are stored every time the step runs.
Note:
Some properties have blank values until the job passes a certain point in a workflow.
If the WritePropsToReportsDatabase step runs before a value is set for a property, the property name is included as
a column in the database table, but no value is recorded.