Table of Contents
- Introduction
- Important Instructions
- Requirements
- Database
- Tables
- change_log
- data_absence
- data_booking
- data_custom_shift
- data_employee
- data_employee_access
- data_employment_period
- data_fixed_shift
- data_group
- data_group_access
- data_holiday
- data_individual_working_time
- data_leave_ban
- data_leave_entitlement
- data_leave_type
- data_membership
- data_modified_shift
- data_note
- data_overtime
- data_shift_cycle
- data_shift_cycle_assignment
- data_shift_cycle_element
- data_shift_cycle_exception
- data_shift_requirement
- data_shift_type
- data_shift_type_restriction
- data_special_period
- data_special_shift_requirement
- data_special_weekday_requirement
- data_surcharge_type
- data_user_setting
- data_user_specification
- data_working_time_model
- data_workplace
- Tables
Table data_working_time_model
The data_working_time_model table contains the working time models.
Table Description
| Column | Data type | Description |
|---|---|---|
| working_time_model_id | int | Primary key (Auto value) Unique record ID |
| name | varchar(250) | Name of the working time model Must not be empty |
| position | int | Position in the display order Default value: 0 |
| basic_type | tinyint | Basis for calculating working time. Possible values:
|
| daily_hours | double | Hours per workday if the value for basic_type is 1, 2, 4 or 5 Default value: 8.0 |
| weekly_hours | double | Weekly hours if the value for basic_type is 2 Default value: 40.0 |
| monthly_hours | double | Monthly hours if the value for basic_type is 4 Default value: 154.0 |
| total_hours | double | Total hours if the value for basic_type basic_type is 5 Default value: 0.0 |
| workdays | char(8) | Valid workdays if the value for basic_type is 1, 2, 4 or 5 Value 1 means valid, otherwise 0. Index 0: Monday,..., 6: Sunday, 7: Public holiday Default value: 11111000 |
| monday_hours | double | Working hours on Monday if the value for basic_type is 3 Default value: 8.0 |
| tuesday_hours | double | Working hours on Tueday if the value for basic_type is 3 Default value: 8.0 |
| wednesday_hours | double | Working hours on Wednesday if the value for basic_type is 3 Default value: 8.0 |
| thursday_hours | double | Working hours on Thursday if the value for basic_type is 3 Default value: 8.0 |
| friday_hours | double | Working hours on Friday if the value for basic_type is 3 Default value: 8.0 |
| saturday_hours | double | Working hours on Saturday if the value for basic_type is 3 Default value: 0.0 |
| sunday_hours | double | Working hours on Sunday if the value for basic_type is 3 Default value: 0.0 |
| subtract_holidays | tinyint | 1 if holidays should be included in the calculation, otherwise 0 if the value for basic_type is 2 or 4. Default value: 1 |
| hidden | double | 1 if the working time model should be hidden in lists, otherwise 0 Default value: 0 |
| deleted | tinyint | 1 for deleted entry, otherwise 0. Default value: 0 |
| set_null_on_delete | tinyint | Must be set to NULL if the entry is deleted, otherwise to 1. Default value: 1 |
| transaction_id | bigint unsigned | For internal use only |
| created_at | timestamp(6) | Record creation time Default value: current time |
| updated_at | timestamp(6) | Last record update time Default value: current time |