STAT_APP_AVG_DURATION table

This table stores the average time (in hours) to complete an application. Each different application has a row in the following table.

STAT_APP_AVG_DURATION table fields

Field	Type	Description
PROCESS_TEMPLATE_NAME	VARCHAR2(64) NOT NULL	The process template name
PROCESS_TEMPLATE_ID¹	NUMBER NOT NULL	Unique template ID, 0 ID covers statistics over all applications.
AVERAGE_TIME	NUMBER NOT NULL	Average application completed duration

¹ Table primary key. If it is 0, then the statistics are collected over all applications. The corresponding PROCESS_TEMPLATE_NAME is "SBM_ALL_APP."