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_user_specification
The data_user_specification table contains the rights of a schedule user.
Table Description
| Column | Data type | Description |
|---|---|---|
| user_specification_id | int | Primary key (Auto value) Unique record ID |
| collaborator_id | int | ID of the schedule user for whom the record is valid |
| rights | varchar(20) | Basic rights. Possible values:
|
| description | varchar(200) | Optional description |
| create_reports | tinyint | 1 if the user is allowed to create reports, otherwise 0 Default value: 1 |
| statistics_restriction | tinyint | Restriction on the display of statistical calculations for employees. Possible values:
|
| employee_master_data_visibility_restriction | tinyint | Restrictions regarding the display of employee master data. Possible values:
|
| open_group_window_restriction | tinyint | Restriction regarding opening the group window. Possible values:
|
| open_settings_window | tinyint | not used in the Schichtplaner program |
| open_staff_administration_window | tinyint | 1 if the user is allowed to open the staff administration window, otherwise 0 Default value: 1 |
| staff_table_minimized | tinyint | 1 if only the name column is displayed for the user in the staff table, otherwise 0 Default value: 0 |
| read_only_absences_display | tinyint | Restriction on the display of absences when only read-only access is granted to an employee. Possible values:
|
| show_read_only_notes | tinyint | 1 if the user is allowed to see the schedule comments when they have read-only access to an employee, otherwise, 0. Default value: 1 |
| create_employees | tinyint | 1 if the user, with limited rights, is allowed to create employees, otherwise 0 Default value: 0 |
| update_employee_master_data | tinyint | 1 if the user, with limited rights, is allowed to edit employee master data, otherwise 0 Default value: 1 |
| delete_employees | tinyint | 1 if the user, with limited rights, is allowed to delete employees, otherwise 0 Default value: 0 |
| schedule_custom_shifts | tinyint | 1 if the user, with limited rights, is allowed to create, edit, and delete custom shifts; otherwise, 0 Default value: 0 |
| schedule_overtimes | tinyint | not used in the Schichtplaner program |
| categories | char(20) |
Write permissions for a categorized shift or leave type
: 1 if write permissions exist, otherwise 0.
Index 0 for category 1, index 1 for category 2, ..., index 19 for category 20 Default value: 00000000000000000000 |
| 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 |
Note:The information in this table is irrelevant for users with administrator rights.
These users always have read and write permissions for all data (including user management).