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_ |
numeric |
Accruals count | |||
accruals_ |
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_ |
int32 |
Allocations | |||
allocation_ |
varchar2 |
||||
allocation_ |
varchar2 |
||||
allocation_ |
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_ |
varchar2 |
||||
closest_ |
varchar2 |
||||
color |
int32 |
Color | The color selected here will be used in every screen with the time off type. | ||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
boolean |
Display Time Off in Calendar | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
employee_ |
varchar2 |
Employee Requests | Extra Days Requests Allowed: User can request an allocation for himself. Not Allowed: User cannot request an allocation. | ||
group_ |
numeric |
Group Time Off | |||
has_ |
boolean |
Has Valid Allocation | This indicates if it is still possible to use this type of leave | ||
hr_ |
boolean |
Hr Attendance Overtime | |||
icon_ |
varchar2 |
||||
icon_ |
varchar2 |
||||
id |
int32 |
ID | |||
leave_ |
varchar2 |
||||
leave_ |
varchar2 |
||||
leave_ |
varchar2 |
Time Off Validation | |||
leaves_ |
numeric |
Time off Already Taken | This value is given by the sum of all time off requests with a negative value. | ||
max_ |
numeric |
Maximum Allowed | This value is given by the sum of all time off requests with a positive value. | ||
name |
varchar2 |
Time Off Type | |||
overtime_ |
boolean |
Deduct Extra Hours | Once a time off of this type is approved, extra hours in attendances will be deducted. | ||
remaining_ |
numeric |
Remaining Time Off | Maximum Time Off Allowed - Time Off Already Taken | ||
request_ |
varchar2 |
Take Time Off in | |||
requires_ |
varchar2 |
Requires allocation | Yes: Time off requests need to have a valid allocation. No Limit: Time Off requests can be taken without any prior allocation. | ||
responsible_ |
varchar2 |
Choose the Time Off Officer who will be notified to approve allocation or Time Off request | |||
responsible_ |
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_ |
boolean |
Supporting Document | |||
time_ |
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_ |
boolean |
Generate Timesheet | If checked, when validating a time off, timesheet will be generated in the Vacation Project of the company. | ||
timesheet_ |
varchar2 |
||||
timesheet_ |
varchar2 |
||||
timesheet_ |
varchar2 |
||||
timesheet_ |
varchar2 |
||||
unpaid |
boolean |
Is Unpaid | |||
virtual_ |
numeric |
Virtual Time Off Already Taken | Sum of validated and non validated time off requests. | ||
virtual_ |
numeric |
Virtual Remaining Time Off | Maximum Time Off Allowed - Time Off Already Taken - Time Off Waiting Approval | ||
work_ |
varchar2 |
||||
work_ |
varchar2 |
||||
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: