Configuration tables in WEBCON BPS

Applies to version 2020.1.3; author: Dawid Golonka

Introduction

One of the types of data stored in WEBCON BPS databases is the configuration of the elements that make up applications and processes. The configuration settings entered by a user are stored in the tables appropriate for the configured elements. The article provides a summary that schematically shows which table is responsible for which part of the configuration.

Description

This article describes the configuration tables that relate to the settings entered on the application part. The picture below presents the standard structure of the application created in WEBCON BSP Designer Studio.

Fig. 1. The standard structure of the application

The simplified diagram of the application is shown in figure below:

Fig. 2. The simplified diagram of the application

a) Configuration tables related to the application level:

Fig. 3. Configuration tables related to the application level

• WFApplicationsGroups – it contains information about the configuration of the application groups
• WFApplications – the configuration of the individual applications
• WFConfigurationSecurities – information about privileges at the application level
• WFApplicationLinkedProcesses - information about the applications that use the linked processes mechanism

b) Configuration tables related to the process level:

Fig. 4. Configuration tables related to the process level

• WFDefinitions – it contains information about the configuration of processes

The remaining tables contain the configuration of the process elements are described in sections below.

c) Configuration tables related to the workflows configuration and form fields matrix level:

Fig. 5. Configuration tables related to the form fields matrix level

• WorkFlows – it describes the configuration of workflows
• WFSteps – the configuration of steps
• WFStepForms – the configuration of the form types on the individual steps and workflows
• WFStepFormFields – information about requirements and editability of form fields and additional configuration settings on the individual forms
• WFStepFormFieldDetails – it describes information about requirements and editability of item list columns on the individual forms
• WFAvailablePaths – information about paths created in the system between steps
• WFTimeouts – the configuration of timeout actions
• WFTimeoutActions – it links actions with timeouts in which these actions are executed

d) Configuration tables related to the form fields:

Fig. 6. Configuration table  related to the form fields

• WFConfigurations – it contains information about the configuration of the individual form fields
• WFDetailConfigs – information about the configuration of all item list columns
• WFFieldDefinitions – information about definition of all form field types available in the system. It is a dictionary with the form field names for the WFConfigurations table.
• WFFieldDetailDefinitions – information about definition of all form fields available as an item list columns. It is a dictionary with the form field names for the WFDetailConfigs.

e) Configuration tables related to the actions:

Fig. 7. Configuration tables related to the actions

• WFActions – it contains information about the configuration of all actions in the system
• WFActionButtonGroups – information about the configuration of action group buttons from the top menu
• WFActionButtons – information about the configuration of action buttons from the top menu
• WFActionBusinessRules - information about the configuration of business rules used in the action configuration
• WFTimeoutActions – it links actions with cycles in which these actions are executed

f) Configuration tables related to the setting of the “Configuration” section

Fig. 8. Configuration tables related to the configuration settings

1. Constants

Global

• WFEnvironmentGlobalVariables – it describes the configuration of global constants
• WFEnvironmentGlobalVariablesGroups – the configuration of the created groups of process constants

Process

• WFEnvironmentProcessVariables – the configuration of process constants
• WFEnvironmentProcessVariablesGroups – the configuration of the created process constant groups

2. Form types

• WFDocTypes – it contains information about the configuration of the form types

3. Business and form rules:

• WFBusinessRuleDefinitions – it contains information about the parameters configured in the business and form rules (Business rules: BRD_RuleType = 1, Form rules: BRD_RuleType = 2)
• WFBusinessRuleParameters – information about the parameters configured in the business rules
• WFBusinessRulesGroups – information about the groups in which the business rules are defined
• WFActionBusinessRules – the configuration of the business rules used in the action configuration

4. E-mail notifications

• WFMessageTemplates – the configuration of the e-mail notification templates

g) Configuration tables related to the setting of the “Presentation” section

Fig. 9. Configuration table related to the presentation settings

• AppStarts – it contains the configuration of the start buttons
• AppReports – information about the report configuration (AppReportViews – information about the user’s report views)
• AppDashboard – information about the configuration of dashboards