leave: Odoo itgen_odoo_leave
read only per partition
- Catalogo:
Odoo - Schema:
hr - Etichetta: itgen_odoo_leave
Time Off
È possibile solo recuperare i dati.
Riepilogo
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.
Colonne della tabella
Di seguito sono riportate le colonne della tabella leave. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
active |
boolean |
Active | |||
active_ |
boolean |
Employee Active | 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 |
||||
all_ |
varchar2 |
||||
attachment_ |
varchar2 |
||||
can_ |
boolean |
Can Approve | |||
can_ |
boolean |
Can Cancel | |||
can_ |
boolean |
Can reset | |||
category_ |
varchar2 |
Category of Employee | |||
category_ |
varchar2 |
Category of Employee | |||
color |
int32 |
Color | The color selected here will be used in every screen with the time off type. | ||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date_ |
datetime |
Data di inizio | |||
date_ |
datetime |
Data di fine | |||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
display_ |
varchar2 |
Nome visualizzato | |||
duration_ |
varchar2 |
Requested (Days/Hours) | Field allowing to see the leave request duration in days or hours depending on the leave_type_request_unit | ||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
numeric |
Total Overtime | |||
first_ |
varchar2 |
This area is automatically filled by the user who validate the time off | |||
first_ |
varchar2 |
This area is automatically filled by the user who validate the time off | |||
has_ |
boolean |
Has Message | |||
has_ |
boolean |
Has Stress Day | |||
holiday_ |
varchar2 |
||||
holiday_ |
varchar2 |
||||
holiday_ |
varchar2 |
||||
holiday_ |
varchar2 |
||||
holiday_ |
varchar2 |
Allocation Mode | By Employee: Allocation/Request for individual Employee, By Employee Tag: Allocation/Request for group of employees in category | ||
id |
int32 |
ID | |||
is_ |
boolean |
Hatched | |||
is_ |
boolean |
Striked | |||
leave_ |
varchar2 |
Take Time Off in | |||
leave_ |
boolean |
Supporting Document | |||
linked_ |
varchar2 |
||||
manager_ |
varchar2 |
||||
manager_ |
varchar2 |
||||
meeting_ |
varchar2 |
||||
meeting_ |
varchar2 |
||||
message_ |
int32 |
Numero di allegati | |||
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 |
Numero di azioni | 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 | |||
notes |
varchar2 |
Reasons | |||
number_ |
numeric |
Duration (Days) | Number of days of the time off request.Used in the calculation.To manually correct the duration, use this field. | ||
number_ |
numeric |
Duration in days | Number of days of the time off request according to your working schedule.Used for interface. | ||
number_ |
numeric |
Duration in hours | Number of hours of the time off request according to your working schedule.Used for interface. | ||
number_ |
varchar2 |
Number Of Hours Text | |||
overtime_ |
boolean |
Overtime Deductible | |||
overtime_ |
varchar2 |
||||
overtime_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
payslip_ |
varchar2 |
Payslip State | |||
private_ |
varchar2 |
Time Off Description | |||
report_ |
varchar2 |
HR Comments | |||
request_ |
datetime |
Request Start Date | |||
request_ |
varchar2 |
Date Period Start | |||
request_ |
datetime |
Request End Date | |||
request_ |
varchar2 |
A un'ora da | |||
request_ |
varchar2 |
Hour to | |||
request_ |
boolean |
Half Day | |||
request_ |
boolean |
Custom Hours | |||
second_ |
varchar2 |
This area is automatically filled by the user who validate the time off with second level (If time off type need second validation) | |||
second_ |
varchar2 |
This area is automatically filled by the user who validate the time off with second level (If time off type need second validation) | |||
state |
varchar2 |
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_ |
varchar2 |
||||
supported_ |
int32 |
Supported Attachment Ids Count | |||
timesheet_ |
varchar2 |
||||
tz |
varchar2 |
Tz | |||
tz_ |
boolean |
Tz Mismatch | |||
user_ |
varchar2 |
Related user name for the resource to manage its access. | |||
user_ |
varchar2 |
Related user name for the resource to manage its access. | |||
validation_ |
varchar2 |
Validation Type | |||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: