Try OpenEdge Now
skip to main content
BP Server Developer's Guide
Reporting tables and views : Reporting tables
 

Reporting tables

BP Server stores the states of active process instances in a set of tables. When a process instance is completed its data is removed from these tables. There is a separate set of tables populated by BPM Process Store which store data about the active as well as completed process instances. You can use these tables for generating reports.
Note: When you uninstall a process template, all data of that process template and all its instances is removed from the reporting tables.
The Table 33 lists the important reporting tables.
Table 33. Reporting tables
Table name
Description
PROCESSTEMPLATE
This table stores data of install process templates.
PROCESSDATAINFO
This table stores metadata of dataslots of all installed process templates.
PROCESSWORKSTEPINFO
This table stores metadata of worksteps of all installed process templates.
PROCESSINSTANCE
This table stores data of active and completed process instances.
WORKSTEP
This table stores data of active and completed workstep instances.
WORKITEM
This table stores data of active and completed workitems.
SUBPROCESSINFO
This table stores data of all process instances and their parent processes.
CWORKITEM
This table stores data of collaborative workstepitems.
CSTEP
This table stores data of collaborative steps.
PROCESS_NOTES
This table stores data of all process notes
Note: You can use the archiver to purge the data from these reporting tables. For more information, refer to the Server Administrator's Guide.