Try OpenEdge Now
skip to main content
Application Developer's Guide
Understanding the Business Process Server repository : Schema for process tables

Schema for process tables

This section describes the schema for Process tables. Business Process Server stores process templates, process instances, worksteps, workitems, and metadata information in a set of relational database tables.
Business Process Server uses a sequence generator to generate IDs for PROCESSTEMPLATE, PROCESSINSTANCE, and WORKITEM. For every sequence (for example, processinstance sequence), the BP Server stores 100 numbers in memory cache in order to avoid excessive database access. If the user stops the BP Server using CTRL+C, then all the cached numbers are lost, causing a gap among the IDs.
* Process template tables
* Process instance tables
* Meta data information tables
* Workstep tables
* Work item tables