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_modified_shift
The data_modified_shift table contains the shifts on a specific date that are assigned a predefined shift type and for which a working time deviation exists.
Table Description
| Column | Data type | Description |
|---|---|---|
| modified_shift_id | int | Primary key (Auto value) Unique record ID |
| employee_id | int | Foreign key to table data_employee Identifies the associated employee |
| shift_type_id | int | Foreign key to table data_shift_type Identifies the associated shift type |
| workplace_id | int | Foreign key to table data_workplace Identifies the associated workplace. NULL if no workplace is assigned. Default value: NULL |
| date | date | Validity date |
| part_count | tinyint | Number of work intervals. Possible values: 1-3. Default value: 1 |
| start_at_0 | time | Start time of the 1. work interval Default value: 00:00 |
| end_at_0 | time | End time of the 1. work interval Default value: 00:00 |
| start_at_1 | time | Start time of the 2. work interval Default value: 00:00 |
| end_at_1 | time | End time of the 2. work interval Default value: 00:00 |
| start_at_2 | time | Start time of the 3. work interval Default value: 00:00 |
| end_at_2 | time | End time of the 3. work interval Default value: 00:00 |
| actual_hours | double | Actual hours to be credited for the shift Default value: 0.0 |
| plan_type | tinyint | Plan in which the modified shift is valid. Possible values:
|
| deleted | tinyint | 1 for deleted entry, otherwise 0. Default value: 0 |
| 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 |