Calendars table description

Applies to version: 2020.1.x and above; author: Franciszek Sakławski

Introduction

When designing the processes and individual workflows in WEBCON BPS, it is good to know how the data is stored in the tables, what are the relations between them and how individual information is displayed on the form. This article describes the Calendars table.

Table description

The Calendars table stores the calendar days. To modify the calendar, go to the “System settings” and in the “Global parameters” tab select the “Working days calendar” option.

Fig. 1. The configuration of the calendar in WEBCON BPS Designer Studio

You can define the non-working days of week and non-working dates (e.g. holidays) in a given year.

Storing the data

Below three most often used columns from the user’s point of view was displayed:

1. CAL_IsDeleted – information whether the row was deleted
2. CAL_WorkingDate – a date
3. CAL_IsWorkingDay – information whether a current day is a working day

The data in the Calendars table:

Fig. 2. The Calendars table

Business case

The simple “Leave of absence” workflow used to register the absence requests was created.

Fig. 3. The “Leave of absence” workflow

At the exit from the “Registration” step, the “Calculate days off” action has been created. This action calculates how many working days were selected by the employee in the planned date and then, displays this information on the form. After approving the request, the number of days is subtracted from the employee pool.

Fig. 4. The configuration of the action

The SQL query used in this action:

Fig. 5. The SQL query uses to calculate the working days

This query uses the Calendar table. From this table in the third row, you can limit the extracted rows by the date range defined on the request (”Leave start”, “Leave end”) and then, in the fourth row limit these days to working days only (CAL_IsWorkingDay = 1) and deleted the entries from the table.

Summary

The Calendars table allows you to operate the non-working and working days by defining them in WEBCON BPS Designer Studio. A properly configured calendar can support your other business applications as shown in this article, and bring many benefits.