---
title: "leave_type (Odoo)"
description: "itgen_odoo_leave_type"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.hr.leave_type
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.hr.leave_type
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# leave_type: Odoo itgen_odoo_leave_type

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `hr`
- Label: itgen_odoo_leave_type

Time Off Type

Can only retrieve data.

## Table Columns

The columns of the table `leave_type` 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 |
|---|---|---|:---:|---|---|
| `accrual_count` | `numeric` | Accruals count | [ ] |  |  |
| `accruals_ids` | `varchar2` |  | [ ] |  |  |
| `active` | `boolean` | Active | [ ] |  | If the active field is set to false, it will allow you to hide the time off type without removing it. |
| `allocation_count` | `int32` | Allocations | [ ] |  |  |
| `allocation_notif_subtype_id` | `varchar2` |  | [ ] |  |  |
| `allocation_notif_subtype_id_label` | `varchar2` |  | [ ] |  |  |
| `allocation_validation_type` | `varchar2` | Approval | [ ] |  | Select the level of approval needed in case of request by employee         - No validation needed: The employee's request is automatically approved.         - Approved by Time Off Officer: The employee's request need to be manually approved by the Time Off Officer. |
| `closest_allocation_to_expire` | `varchar2` |  | [ ] |  |  |
| `closest_allocation_to_expire_label` | `varchar2` |  | [ ] |  |  |
| `color` | `int32` | Color | [ ] |  | The color selected here will be used in every screen with the time off type. |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `create_calendar_meeting` | `boolean` | Display Time Off in Calendar | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `employee_requests` | `varchar2` | Employee Requests | [x] |  | Extra Days Requests Allowed: User can request an allocation for himself.          Not Allowed: User cannot request an allocation. |
| `group_days_leave` | `numeric` | Group Time Off | [ ] |  |  |
| `has_valid_allocation` | `boolean` | Has Valid Allocation | [ ] |  | This indicates if it is still possible to use this type of leave |
| `hr_attendance_overtime` | `boolean` | Hr Attendance Overtime | [ ] |  |  |
| `icon_id` | `varchar2` |  | [ ] |  |  |
| `icon_id_label` | `varchar2` |  | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `leave_notif_subtype_id` | `varchar2` |  | [ ] |  |  |
| `leave_notif_subtype_id_label` | `varchar2` |  | [ ] |  |  |
| `leave_validation_type` | `varchar2` | Time Off Validation | [ ] |  |  |
| `leaves_taken` | `numeric` | Time off Already Taken | [ ] |  | This value is given by the sum of all time off requests with a negative value. |
| `max_leaves` | `numeric` | Maximum Allowed | [ ] |  | This value is given by the sum of all time off requests with a positive value. |
| `name` | `varchar2` | Time Off Type | [x] |  |  |
| `overtime_deductible` | `boolean` | Deduct Extra Hours | [ ] |  | Once a time off of this type is approved, extra hours in attendances will be deducted. |
| `remaining_leaves` | `numeric` | Remaining Time Off | [ ] |  | Maximum Time Off Allowed - Time Off Already Taken |
| `request_unit` | `varchar2` | Take Time Off in | [x] |  |  |
| `requires_allocation` | `varchar2` | Requires allocation | [x] |  | Yes: Time off requests need to have a valid allocation.                No Limit: Time Off requests can be taken without any prior allocation. |
| `responsible_id` | `varchar2` |  | [ ] |  | Choose the Time Off Officer who will be notified to approve allocation or Time Off request |
| `responsible_id_label` | `varchar2` |  | [ ] |  | Choose the Time Off Officer who will be notified to approve allocation or Time Off request |
| `sequence` | `int32` | Sequence | [ ] |  | The type with the smallest sequence is the default value in time off request |
| `support_document` | `boolean` | Supporting Document | [ ] |  |  |
| `time_type` | `varchar2` | Kind of Time Off | [ ] |  | The distinction between working time (ex. Attendance) and absence (ex. Training) will be used in the computation of Accrual's plan rate. |
| `timesheet_generate` | `boolean` | Generate Timesheet | [ ] |  | If checked, when validating a time off, timesheet will be generated in the Vacation Project of the company. |
| `timesheet_project_id` | `varchar2` |  | [ ] |  |  |
| `timesheet_project_id_label` | `varchar2` |  | [ ] |  |  |
| `timesheet_task_id` | `varchar2` |  | [ ] |  |  |
| `timesheet_task_id_label` | `varchar2` |  | [ ] |  |  |
| `unpaid` | `boolean` | Is Unpaid | [ ] |  |  |
| `virtual_leaves_taken` | `numeric` | Virtual Time Off Already Taken | [ ] |  | Sum of validated and non validated time off requests. |
| `virtual_remaining_leaves` | `numeric` | Virtual Remaining Time Off | [ ] |  | Maximum Time Off Allowed - Time Off Already Taken - Time Off Waiting Approval |
| `work_entry_type_id` | `varchar2` |  | [ ] |  |  |
| `work_entry_type_id_label` | `varchar2` |  | [ ] |  |  |
| `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:

- [Odoo](/en/release-notes/drivers?driver=odoo)

