Navigation: Schema: hr > Tables

leave

Time Off

Catalog: Odoo

Schema: hr

Documentation:

Time Off Requests Access specifications

- a regular employee / user

- can see all leaves;

- cannot see name field of leaves belonging to other user as it may contain

private information that we don't want to share to other people than

HR people;

- can modify only its own not validated leaves (except writing on state to

bypass approval);

- can discuss on its leave requests;

- can reset only its own leaves;

- cannot validate any leaves;

- an Officer

- can see all leaves;

- can validate "HR" single validation leaves from people if

- he is the employee manager;

- he is the department manager;

- he is member of the same department;

- target employee has no manager and no department manager;

- can validate "Manager" single validation leaves from people if

- he is the employee manager;

- he is the department manager;

- target employee has no manager and no department manager;

- can first validate "Both" double validation leaves from people like "HR"

single validation, moving the leaves to validate1 state;

- cannot validate its own leaves;

- can reset only its own leaves;

- can refuse all leaves;

- a Manager

- can do everything he wants

On top of that multicompany rules apply based on company defined on the

leave request leave type.

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 leave are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required	Documentation
active_employee	boolean	Employee Active	☐	If the active field is set to False, it will allow you to hide the resource record without removing it.
active	boolean	Active	☐
activity_calendar_event_id_label	string		☐
activity_calendar_event_id	string		☐
activity_date_deadline	datetime	Next Activity Deadline	☐
activity_exception_decoration	string	Activity Exception Decoration	☐	Type of the exception activity on record.
activity_exception_icon	string	Icon	☐	Icon to indicate an exception activity.
activity_ids	string		☐
activity_state	string	Activity State	☐	Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities.
activity_summary	string	Next Activity Summary	☐
activity_type_icon	string	Activity Type Icon	☐	Font awesome icon e.g. fa-tasks
activity_type_id_label	string		☐
activity_type_id	string		☐
activity_user_id_label	string		☐
activity_user_id	string		☐
all_employee_ids	string		☐
attachment_ids	string		☐
can_approve	boolean	Can Approve	☐
can_cancel	boolean	Can Cancel	☐
can_reset	boolean	Can reset	☐
category_id_label	string		☐	Category of Employee
category_id	string		☐	Category of Employee
color	int32	Color	☐	The color selected here will be used in every screen with the time off type.
create_date	datetime	Created on	☐
create_uid_label	string		☐
create_uid	string		☐
date_from	datetime	Start Date	☑
date_to	datetime	End Date	☑
department_id_label	string		☐
department_id	string		☐
display_name	string	Display Name	☐
duration_display	string	Requested (Days/Hours)	☐	Field allowing to see the leave request duration in days or hours depending on the leave_type_request_unit
employee_company_id_label	string		☐
employee_company_id	string		☐
employee_id_label	string		☐
employee_id	string		☐
employee_ids	string		☐
employee_overtime	decimal	Total Overtime	☐
first_approver_id_label	string		☐	This area is automatically filled by the user who validate the time off
first_approver_id	string		☐	This area is automatically filled by the user who validate the time off
has_message	boolean	Has Message	☐
has_stress_day	boolean	Has Stress Day	☐
holiday_allocation_id_label	string		☐
holiday_allocation_id	string		☐
holiday_status_id_label	string		☐
holiday_status_id	string		☐
holiday_type	string	Allocation Mode	☑	By Employee: Allocation/Request for individual Employee, By Employee Tag: Allocation/Request for group of employees in category
id	int32	ID	☐
is_hatched	boolean	Hatched	☐
is_striked	boolean	Striked	☐
leave_type_request_unit	string	Take Time Off in	☐
leave_type_support_document	boolean	Supporting Document	☐
linked_request_ids	string		☐
manager_id_label	string		☐
manager_id	string		☐
meeting_id_label	string		☐
meeting_id	string		☐
message_attachment_count	int32	Attachment Count	☐
message_follower_ids	string		☐
message_has_error_counter	int32	Number of errors	☐	Number of messages with delivery error
message_has_error	boolean	Message Delivery error	☐	If checked, some messages have a delivery error.
message_has_sms_error	boolean	SMS Delivery error	☐	If checked, some messages have a delivery error.
message_ids	string		☐
message_is_follower	boolean	Is Follower	☐
message_main_attachment_id_label	string		☐
message_main_attachment_id	string		☐
message_needaction_counter	int32	Number of Actions	☐	Number of messages which requires an action
message_needaction	boolean	Action Needed	☐	If checked, new messages require your attention.
message_partner_ids	string		☐
mode_company_id_label	string		☐
mode_company_id	string		☐
multi_employee	boolean	Multi Employee	☐	Holds whether this allocation concerns more than 1 employee
my_activity_date_deadline	datetime	My Activity Deadline	☐
name	string	Description	☐
notes	string	Reasons	☐
number_of_days_display	decimal	Duration in days	☐	Number of days of the time off request according to your working schedule. Used for interface.
number_of_days	decimal	Duration (Days)	☐	Number of days of the time off request. Used in the calculation. To manually correct the duration, use this field.
number_of_hours_display	decimal	Duration in hours	☐	Number of hours of the time off request according to your working schedule. Used for interface.
number_of_hours_text	string	Number Of Hours Text	☐
overtime_deductible	boolean	Overtime Deductible	☐
overtime_id_label	string		☐
overtime_id	string		☐
parent_id_label	string		☐
parent_id	string		☐
payslip_state	string	Payslip State	☑
private_name	string	Time Off Description	☐
report_note	string	HR Comments	☐
request_date_from_period	string	Date Period Start	☐
request_date_from	datetime	Request Start Date	☐
request_date_to	datetime	Request End Date	☐
request_hour_from	string	Hour from	☐
request_hour_to	string	Hour to	☐
request_unit_half	boolean	Half Day	☐
request_unit_hours	boolean	Custom Hours	☐
second_approver_id_label	string		☐	This area is automatically filled by the user who validate the time off with second level (If time off type need second validation)
second_approver_id	string		☐	This area is automatically filled by the user who validate the time off with second level (If time off type need second validation)
state	string	Status	☐	The status is set to 'To Submit', when a time off request is created.The status is 'To Approve', when time off request is confirmed by user.The status is 'Refused', when time off request is refused by manager.The status is 'Approved', when time off request is approved by manager.
supported_attachment_ids_count	int32	Supported Attachment Ids Count	☐
supported_attachment_ids	string		☐
timesheet_ids	string		☐
tz_mismatch	boolean	Tz Mismatch	☐
tz	string	Tz	☐
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.
validation_type	string	Validation Type	☐
website_message_ids	string		☐	Website communication history
write_date	datetime	Last Updated on	☐
write_uid_label	string		☐
write_uid	string		☐

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

Please enable JavaScript to view this site.

Odoo API Data Model

leave

Table Columns

Important Safety and Usage Information