Navigation: Schema: planning > Tables

slot

Planning Shift

Catalog: Odoo

Schema: planning

The data in this table is partitioned per value of the column.

This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.

Table Columns

The columns of the table slot are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required	Documentation
access_token	string	Security Token	☑
allocated_hours	decimal	Allocated Time	☐
allocated_percentage	decimal	Allocated Time %	☐
allocation_type	string	Allocation Type	☐
allow_self_unassign	boolean	Let Employee Unassign Themselves	☐
allow_template_creation	boolean	Allow Template Creation	☐
color	int32	Color	☐
company_id_label	string		☐
company_id	string		☐
confirm_delete	boolean	Confirm Slots Deletion	☐
conflicting_slot_ids	string		☐
create_date	datetime	Created on	☐
create_uid_label	string		☐
create_uid	string		☐
department_id_label	string		☐
department_id	string		☐
display_name	string	Display Name	☐
duration	decimal	Duration	☐
employee_id_label	string		☐
employee_id	string		☐
employee_skill_ids	string		☐
end_datetime	datetime	End Date	☐
id	int32	ID	☐
is_absent	boolean	Employees on Time Off	☐
is_assigned_to_me	boolean	Is This Shift Assigned To The Current User	☐
is_hatched	boolean	Is Hatched	☐
is_past	boolean	Is This Shift In The Past?	☐
is_unassign_deadline_passed	boolean	Is unassignement deadline not past	☐
is_users_role	boolean	Is the shifts role one of the current user roles	☐
job_title	string	Job Title	☐
leave_warning	string	Leave Warning	☐
manager_id_label	string		☐
manager_id	string		☐
name	string	Note	☐
overlap_slot_count	int32	Overlapping Slots	☐
partner_id_label	string		☐
partner_id	string		☐
previous_template_id_label	string		☐
previous_template_id	string		☐
publication_warning	boolean	Modified Since Last Publication	☐	If checked, it means that the shift contains has changed since its last publish.
recurrency_id_label	string		☐
recurrency_id	string		☐
repeat_interval	int32	Repeat every	☐
repeat_number	int32	Repetitions	☐
repeat_type	string	Repeat Type	☐
repeat_unit	string	Repeat Unit	☑
repeat_until	datetime	Repeat Until	☐
repeat	boolean	Repeat	☐	Modifications made to a shift only impact the current shift and not the other ones that are part of the recurrence. The same goes when deleting a recurrent shift. Disable this option to stop the recurrence.To avoid polluting your database and performance issues, shifts are only created for the next 6 months. They are then gradually created as time passes by in order to always get shifts 6 months ahead. This value can be modified from the settings of Planning, in debug mode.
request_to_switch	boolean	Has there been a request to switch on this shift slot?	☐
resource_id_label	string		☐
resource_id	string		☐
resource_type	string	Type	☐
role_id_label	string		☐	Define the roles your resources perform (e.g. Chef, Bartender, Waiter...). Create open shifts for the roles you need to complete a mission. Then, assign those open shifts to the resources that are available.
role_id	string		☐	Define the roles your resources perform (e.g. Chef, Bartender, Waiter...). Create open shifts for the roles you need to complete a mission. Then, assign those open shifts to the resources that are available.
role_product_ids	string		☐
sale_line_id_label	string		☐	Sales order item for which this shift will be performed. When sales orders are automatically planned, the remaining hours of the sales order item, as well as the role defined on the service, are taken into account.
sale_line_id	string		☐	Sales order item for which this shift will be performed. When sales orders are automatically planned, the remaining hours of the sales order item, as well as the role defined on the service, are taken into account.
sale_line_plannable	boolean	Plan Services	☐	If enabled, a shift will automatically be generated for the selected role when confirming the Sales Order. Only employees with this role will automatically be assigned shifts for Sales Orders containing this service.
sale_order_id_label	string		☐
sale_order_id	string		☐
self_unassign_days_before	int32	Days before shift for unassignment	☐	Deadline in days for shift unassignment
start_datetime	datetime	Start Date	☐
state	string	Status	☐
template_autocomplete_ids	string		☐
template_creation	boolean	Save as Template	☐
template_id_label	string		☐
template_id	string		☐
template_reset	boolean	Template Reset	☐
unassign_deadline	datetime	Deadline for unassignment	☐
user_id_label	string		☐	Related user name for the resource to manage its access.
user_id	string		☐	Related user name for the resource to manage its access.
was_copied	boolean	This Shift Was Copied From Previous Week	☐
work_address_id_label	string		☐
work_address_id	string		☐
work_email	string	Work Email	☐
work_location_id_label	string		☐
work_location_id	string		☐
working_days_count	decimal	Working Days	☐
write_date	datetime	Last Updated on	☐
write_uid_label	string		☐
write_uid	string		☐

01-03-2023 15:29 Version 22.1.135-BETA+3826

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Please enable JavaScript to view this site.

Odoo API Data Model

slot

Table Columns

Important Safety and Usage Information