invantive documentation
Invantive Support ForumsLog In / Sign Up

slot: Odoo itgen_odoo_slot

read only per partition

  • Catalog: Odoo
  • Schema: planning
  • Label: itgen_odoo_slot

Planning Shift

Can only retrieve data.

Table Columns

The columns of the table slot are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
access_token varchar2 Security Token
allocated_hours numeric Allocated Time
allocated_percentage numeric Allocated Time %
allocation_type varchar2 Allocation Type
allow_self_unassign boolean Let Employee Unassign Themselves
allow_template_creation boolean Allow Template Creation
color int32 Color
company_id varchar2
company_id_label varchar2
confirm_delete boolean Confirm Slots Deletion
conflicting_slot_ids varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
department_id varchar2
department_id_label varchar2
display_name varchar2 Display Name
duration numeric Duration
employee_id varchar2
employee_id_label varchar2
employee_skill_ids varchar2
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 varchar2 Job Title
leave_warning varchar2 Leave Warning
manager_id varchar2
manager_id_label varchar2
name varchar2 Note
overlap_slot_count int32 Overlapping Slots
partner_id varchar2
partner_id_label varchar2
previous_template_id varchar2
previous_template_id_label varchar2
publication_warning boolean Modified Since Last Publication If checked, it means that the shift contains has changed since its last publish.
recurrency_id varchar2
recurrency_id_label varchar2
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.
repeat_interval int32 Repeat every
repeat_number int32 Repetitions
repeat_type varchar2 Repeat Type
repeat_unit varchar2 Repeat Unit
repeat_until datetime Repeat Until
request_to_switch boolean Has there been a request to switch on this shift slot?
resource_id varchar2
resource_id_label varchar2
resource_type varchar2 Type
role_id varchar2 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_label varchar2 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 varchar2
sale_line_id varchar2 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_label varchar2 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 varchar2
sale_order_id_label varchar2
self_unassign_days_before int32 Days before shift for unassignment Deadline in days for shift unassignment
start_datetime datetime Start Date
state varchar2 Status
template_autocomplete_ids varchar2
template_creation boolean Save as Template
template_id varchar2
template_id_label varchar2
template_reset boolean Template Reset
unassign_deadline datetime Deadline for unassignment
user_id varchar2 Related user name for the resource to manage its access.
user_id_label varchar2 Related user name for the resource to manage its access.
was_copied boolean This Shift Was Copied From Previous Week
work_address_id varchar2
work_address_id_label varchar2
work_email varchar2 Work Email
work_location_id varchar2
work_location_id_label varchar2
working_days_count numeric Working Days
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: