invantive documentation
Forum di supporto InvantiveAccedi / Registrati

leave: Odoo itgen_odoo_leave

read only per partition

  • Catalogo: Odoo
  • Schema: hr
  • Etichetta: itgen_odoo_leave

Time Off

È possibile solo recuperare i dati.

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_employee boolean Employee Active If the active field is set to False, it will allow you to hide the resource record without removing it.
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
all_employee_ids varchar2
attachment_ids varchar2
can_approve boolean Can Approve
can_cancel boolean Can Cancel
can_reset boolean Can reset
category_id varchar2 Category of Employee
category_id_label varchar2 Category of Employee
color int32 Color The color selected here will be used in every screen with the time off type.
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
date_from datetime Data di inizio
date_to datetime Data di fine
department_id varchar2
department_id_label varchar2
display_name varchar2 Nome visualizzato
duration_display varchar2 Requested (Days/Hours) Field allowing to see the leave request duration in days or hours depending on the leave_type_request_unit
employee_company_id varchar2
employee_company_id_label varchar2
employee_id varchar2
employee_id_label varchar2
employee_ids varchar2
employee_overtime numeric Total Overtime
first_approver_id varchar2 This area is automatically filled by the user who validate the time off
first_approver_id_label varchar2 This area is automatically filled by the user who validate the time off
has_message boolean Has Message
has_stress_day boolean Has Stress Day
holiday_allocation_id varchar2
holiday_allocation_id_label varchar2
holiday_status_id varchar2
holiday_status_id_label varchar2
holiday_type 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_hatched boolean Hatched
is_striked boolean Striked
leave_type_request_unit varchar2 Take Time Off in
leave_type_support_document boolean Supporting Document
linked_request_ids varchar2
manager_id varchar2
manager_id_label varchar2
meeting_id varchar2
meeting_id_label varchar2
message_attachment_count int32 Numero di allegati
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Numero di azioni Number of messages which requires an action
message_partner_ids varchar2
mode_company_id varchar2
mode_company_id_label varchar2
multi_employee boolean Multi Employee Holds whether this allocation concerns more than 1 employee
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Description
notes varchar2 Reasons
number_of_days numeric Duration (Days) Number of days of the time off request.Used in the calculation.To manually correct the duration, use this field.
number_of_days_display numeric Duration in days Number of days of the time off request according to your working schedule.Used for interface.
number_of_hours_display numeric Duration in hours Number of hours of the time off request according to your working schedule.Used for interface.
number_of_hours_text varchar2 Number Of Hours Text
overtime_deductible boolean Overtime Deductible
overtime_id varchar2
overtime_id_label varchar2
parent_id varchar2
parent_id_label varchar2
payslip_state varchar2 Payslip State
private_name varchar2 Time Off Description
report_note varchar2 HR Comments
request_date_from datetime Request Start Date
request_date_from_period varchar2 Date Period Start
request_date_to datetime Request End Date
request_hour_from varchar2 A un'ora da
request_hour_to varchar2 Hour to
request_unit_half boolean Half Day
request_unit_hours boolean Custom Hours
second_approver_id 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_approver_id_label 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_attachment_ids varchar2
supported_attachment_ids_count int32 Supported Attachment Ids Count
timesheet_ids varchar2
tz varchar2 Tz
tz_mismatch boolean Tz Mismatch
user_id varchar2 Related user name for the resource to manage its access.
user_id_label varchar2 Related user name for the resource to manage its access.
validation_type varchar2 Validation Type
website_message_ids varchar2 Website communication history
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: