leave_allocation: Odoo itgen_odoo_leave_allocation
read only per partition
- Catálogo:
Odoo - Esquema:
hr - Etiqueta: itgen_odoo_leave_allocation
Time Off Allocation
Solo puede recuperar datos.
Resumen
Allocation Requests Access specifications: similar to leave requests
Columnas de la Tabla
A continuación se muestran las columnas de la tabla leave_allocation. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
accrual_ |
varchar2 |
||||
accrual_ |
varchar2 |
||||
active |
boolean |
Active | |||
active_ |
boolean |
Active Employee | If the active field is set to False, it will allow you to hide the resource record without removing it. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
allocation_ |
varchar2 |
Allocation Type | |||
approver_ |
varchar2 |
This area is automatically filled by the user who validates the allocation | |||
approver_ |
varchar2 |
This area is automatically filled by the user who validates the allocation | |||
can_ |
boolean |
Can Approve | |||
can_ |
boolean |
Can reset | |||
category_ |
varchar2 |
||||
category_ |
varchar2 |
||||
create_ |
datetime |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date_ |
datetime |
Fecha Inicial | |||
date_ |
datetime |
Fecha Final | |||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
display_ |
varchar2 |
Nombre para mostrar | |||
duration_ |
varchar2 |
Allocated (Days/Hours) | Field allowing to see the allocation duration in days or hours depending on the type_request_unit | ||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
numeric |
Total Overtime | |||
has_ |
boolean |
Has Message | |||
holiday_ |
varchar2 |
||||
holiday_ |
varchar2 |
||||
holiday_ |
varchar2 |
Allocation Mode | Allow to create requests in batchs: - By Employee: for a specific employee - By Company: all employees of the specified company - By Department: all employees of the specified department - By Employee Tag: all employees of the specific employee group category | ||
hr_ |
boolean |
Count Extra Hours | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Officer | |||
lastcall |
datetime |
Date of the last accrual allocation | |||
leaves_ |
numeric |
Time off Taken | |||
linked_ |
varchar2 |
||||
manager_ |
varchar2 |
||||
manager_ |
varchar2 |
||||
max_ |
numeric |
Max Leaves | |||
message_ |
int32 |
Número de archivos adjuntos | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Número de acciones | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
mode_ |
varchar2 |
||||
mode_ |
varchar2 |
||||
multi_ |
boolean |
Multi Employee | Holds whether this allocation concerns more than 1 employee | ||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Description | |||
name_ |
varchar2 |
Description with validity | |||
nextcall |
datetime |
Date of the next accrual allocation | |||
notes |
varchar2 |
Reasons | |||
number_ |
numeric |
Number of Days | Duration in days.Reference field to use when necessary. | ||
number_ |
numeric |
Duration (days) | If Accrual Allocation: Number of days allocated in addition to the ones you will get via the accrual' system. | ||
number_ |
numeric |
Duración (horas) | If Accrual Allocation: Number of hours allocated in addition to the ones you will get via the accrual' system. | ||
overtime_ |
boolean |
Overtime Deductible | |||
overtime_ |
varchar2 |
||||
overtime_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
private_ |
varchar2 |
Allocation Description | |||
state |
varchar2 |
Status | The status is set to 'To Submit', when an allocation request is created.The status is 'To Approve', when an allocation request is confirmed by user.The status is 'Refused', when an allocation request is refused by manager.The status is 'Approved', when an allocation request is approved by manager. | ||
taken_ |
varchar2 |
||||
type_ |
varchar2 |
Take Time Off in | |||
validation_ |
varchar2 |
Validation Type | 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. | ||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: