Default PostgreSQL database tables

By default, one database containing three database tables are defined in the Reports.json file that is supplied with the Reports feature.
Database Table Purpose Default Properties
job_history Holds the values of job properties specified in the jobStepProgress section of the Reports.json file. 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 jobPrinting section of the Reports.json file. Values are stored at the beginning and end of processing in each step of a workflow.
  • 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
printer_status Holds the values of printer properties specified in the printerStatus section of the Reports.json file. Values are stored at the beginning and end of processing in each step of a workflow.
  • 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

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.

  • 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.
 
Copyright © 2018