Try OpenEdge Now
skip to main content
Application Developer's Guide
Understanding the Business Process Server repository : Dashboard database tables : STAT_APP_STATUS_HISTORY table
 

STAT_APP_STATUS_HISTORY table

From this table, you can see how many applications were activated, completed, removed, or suspended for the last several days.

STAT_APP_STATUS_HISTORY table fields

Field
Type
Description
PROCESS_TEMPLATE_NAME
VARCHAR2(64) NOT NULL
Process template name
PROCESS_TEMPLATE_ID1
NUMBER NOT NULL
Unique template ID, 0 ID covers statistics over all applications.
ACTIVATED
NUMBER NOT NULL
Number of activated process instances every day
COMPLETED
NUMBER NOT NULL
Number of completed process instances every day
REMOVED
NUMBER NOT NULL
Number of removed process instances every day
SUSPENDED
NUMBER NOT NULL
Number of suspended process instances every day
RECORD_TIME2
DATE NOT NULL
Time updating this record
1 Table primary key. If 0, then the statistics are collected over all applications. The corresponding PROCESS_TEMPLATE_NAME is "SBM_ALL_APP."

2 Table primary key