leave_accrual_level |
Accrual Plan Level
Catalog: Odoo
Schema: hr
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_accrual_level are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
accrual_plan_id_label |
string |
|
☐ |
|
accrual_plan_id |
string |
|
☐ |
|
action_with_unused_accruals |
string |
At the end of the calendar year, unused accruals will be |
☑ |
|
added_value_type |
string |
Added Value Type |
☑ |
|
added_value |
decimal |
Rate |
☑ |
The number of hours/days that will be incremented in the specified Time Off Type for every period |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
first_day_display |
string |
First Day Display |
☐ |
|
first_day |
int32 |
First Day |
☐ |
|
first_month_day_display |
string |
First Month Day Display |
☐ |
|
first_month_day |
int32 |
First Month Day |
☐ |
|
first_month |
string |
First Month |
☐ |
|
frequency |
string |
Frequency |
☑ |
|
id |
int32 |
ID |
☐ |
|
is_based_on_worked_time |
boolean |
Based on worked time |
☐ |
If checked, the rate will be prorated on time off type where type is set on Working Time in the configuration. |
maximum_leave |
decimal |
Limit to |
☐ |
Choose a cap for this accrual. 0 means no cap. |
parent_id_label |
string |
|
☐ |
If this field is empty, this level is the first one. |
parent_id |
string |
|
☐ |
If this field is empty, this level is the first one. |
postpone_max_days |
int32 |
Maximum amount of accruals to transfer |
☐ |
Set a maximum of days an allocation keeps at the end of the year. 0 for no limit. |
second_day_display |
string |
Second Day Display |
☐ |
|
second_day |
int32 |
Second Day |
☐ |
|
second_month_day_display |
string |
Second Month Day Display |
☐ |
|
second_month_day |
int32 |
Second Month Day |
☐ |
|
second_month |
string |
Second Month |
☐ |
|
sequence |
int32 |
sequence |
☐ |
Sequence is generated automatically by start time delta. |
start_count |
int32 |
Start after |
☐ |
The accrual starts after a defined period from the employee start date. This field defines the number of days, months or years after which accrual is used. |
start_type |
string |
|
☑ |
This field defines the unit of time after which the accrual starts. |
week_day |
string |
Allocation on |
☑ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
yearly_day_display |
string |
Yearly Day Display |
☐ |
|
yearly_day |
int32 |
Yearly Day |
☐ |
|
yearly_month |
string |
Yearly Month |
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826