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.

RICOH ProcessDirector™ for AIX

Default PostgreSQL database tables

Additional database tables

Related information: