Default PostgreSQL database tables

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
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.