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_ |
varchar2 |
Security Token | |||
allocated_ |
numeric |
Allocated Time | |||
allocated_ |
numeric |
Allocated Time % | |||
allocation_ |
varchar2 |
Allocation Type | |||
allow_ |
boolean |
Let Employee Unassign Themselves | |||
allow_ |
boolean |
Allow Template Creation | |||
color |
int32 |
Color | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
confirm_ |
boolean |
Confirm Slots Deletion | |||
conflicting_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
duration |
numeric |
Duration | |||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
end_ |
datetime |
End Date | |||
id |
int32 |
ID | |||
is_ |
boolean |
Employees on Time Off | |||
is_ |
boolean |
Is This Shift Assigned To The Current User | |||
is_ |
boolean |
Is Hatched | |||
is_ |
boolean |
Is This Shift In The Past? | |||
is_ |
boolean |
Is unassignement deadline not past | |||
is_ |
boolean |
Is the shifts role one of the current user roles | |||
job_ |
varchar2 |
Job Title | |||
leave_ |
varchar2 |
Leave Warning | |||
manager_ |
varchar2 |
||||
manager_ |
varchar2 |
||||
name |
varchar2 |
Note | |||
overlap_ |
int32 |
Overlapping Slots | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
previous_ |
varchar2 |
||||
previous_ |
varchar2 |
||||
publication_ |
boolean |
Modified Since Last Publication | If checked, it means that the shift contains has changed since its last publish. | ||
recurrency_ |
varchar2 |
||||
recurrency_ |
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_ |
int32 |
Repeat every | |||
repeat_ |
int32 |
Repetitions | |||
repeat_ |
varchar2 |
Repeat Type | |||
repeat_ |
varchar2 |
Repeat Unit | |||
repeat_ |
datetime |
Repeat Until | |||
request_ |
boolean |
Has there been a request to switch on this shift slot? | |||
resource_ |
varchar2 |
||||
resource_ |
varchar2 |
||||
resource_ |
varchar2 |
Type | |||
role_ |
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_ |
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_ |
varchar2 |
||||
sale_ |
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_ |
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_ |
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_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
self_ |
int32 |
Days before shift for unassignment | Deadline in days for shift unassignment | ||
start_ |
datetime |
Start Date | |||
state |
varchar2 |
Status | |||
template_ |
varchar2 |
||||
template_ |
boolean |
Save as Template | |||
template_ |
varchar2 |
||||
template_ |
varchar2 |
||||
template_ |
boolean |
Template Reset | |||
unassign_ |
datetime |
Deadline for unassignment | |||
user_ |
varchar2 |
Related user name for the resource to manage its access. | |||
user_ |
varchar2 |
Related user name for the resource to manage its access. | |||
was_ |
boolean |
This Shift Was Copied From Previous Week | |||
work_ |
varchar2 |
||||
work_ |
varchar2 |
||||
work_ |
varchar2 |
Work Email | |||
work_ |
varchar2 |
||||
work_ |
varchar2 |
||||
working_ |
numeric |
Working Days | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: