---
title: "employee_public (Odoo)"
description: "itgen_odoo_employee_public"
language: it
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/odoo/Odoo.hr.employee_public
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.hr.employee_public
updated: 2026-11-18T01:03:19Z
license: https://documentation.invantive.eu/it/
---

# employee_public: Odoo itgen_odoo_employee_public

`read only` `per partition`

- Catalogo: `Odoo`
- Schema: `hr`
- Etichetta: itgen_odoo_employee_public

Public Employee

È possibile solo recuperare i dati.

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `employee_public`. 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 | [ ] |  |  |
| `address_id` | `varchar2` |  | [ ] |  |  |
| `address_id_label` | `varchar2` |  | [ ] |  |  |
| `allocation_count` | `numeric` | Total number of days allocated. | [ ] |  |  |
| `allocation_display` | `varchar2` | Allocation Display | [ ] |  |  |
| `allocation_remaining_display` | `varchar2` | Allocation Remaining Display | [ ] |  |  |
| `allocations_count` | `int32` | Total number of allocations | [ ] |  |  |
| `attendance_state` | `varchar2` | Attendance Status | [ ] |  |  |
| `avatar_1024` | `varbinary` | Avatar 1024 | [ ] |  |  |
| `avatar_128` | `varbinary` | Avatar 128 | [ ] |  |  |
| `avatar_1920` | `varbinary` | Avatar | [ ] |  |  |
| `avatar_256` | `varbinary` | Avatar 256 | [ ] |  |  |
| `avatar_512` | `varbinary` | Avatar 512 | [ ] |  |  |
| `badge_ids` | `varchar2` |  | [ ] |  | All employee badges, linked to the employee either directly or through the user |
| `child_all_count` | `int32` | Indirect Subordinates Count | [ ] |  |  |
| `child_ids` | `varchar2` |  | [ ] |  |  |
| `coach_id` | `varchar2` |  | [ ] |  | Select the "Employee" who is the coach of this employee.The "Coach" has no specific rights or responsibilities by default. |
| `coach_id_label` | `varchar2` |  | [ ] |  | Select the "Employee" who is the coach of this employee.The "Coach" has no specific rights or responsibilities by default. |
| `color` | `int32` | Color Index | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Data di creazione | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `current_leave_state` | `varchar2` | Current Time Off Status | [ ] |  |  |
| `department_id` | `varchar2` |  | [ ] |  |  |
| `department_id_label` | `varchar2` |  | [ ] |  |  |
| `direct_badge_ids` | `varchar2` |  | [ ] |  | Badges directly linked to the employee |
| `display_name` | `varchar2` | Nome visualizzato | [ ] |  |  |
| `employee_id` | `varchar2` |  | [ ] |  |  |
| `employee_id_label` | `varchar2` |  | [ ] |  |  |
| `employee_skill_ids` | `varchar2` |  | [ ] |  |  |
| `employee_type` | `varchar2` | Tipo di dipendente | [x] |  | The employee type.Although the primary purpose may seem to categorize employees, this field has also an impact in the Contract History.Only Employee type is supposed to be under contract and will have a Contract History. |
| `expense_manager_id` | `varchar2` |  | [ ] |  |  |
| `expense_manager_id_label` | `varchar2` |  | [ ] |  |  |
| `first_contract_date` | `datetime` | First Contract Date | [ ] |  |  |
| `goal_ids` | `varchar2` |  | [ ] |  |  |
| `has_badges` | `boolean` | Has Badges | [ ] |  |  |
| `hours_today` | `numeric` | Hours Today | [ ] |  |  |
| `hr_icon_display` | `varchar2` | Hr Icon Display | [ ] |  |  |
| `hr_presence_state` | `varchar2` | Hr Presence State | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `image_1024` | `varbinary` | Image 1024 | [ ] |  |  |
| `image_128` | `varbinary` | Image 128 | [ ] |  |  |
| `image_1920` | `varbinary` | Image | [ ] |  |  |
| `image_256` | `varbinary` | Image 256 | [ ] |  |  |
| `image_512` | `varbinary` | Image 512 | [ ] |  |  |
| `is_absent` | `boolean` | Absent Today | [ ] |  |  |
| `is_subordinate` | `boolean` | Is Subordinate | [ ] |  |  |
| `job_id` | `varchar2` |  | [ ] |  |  |
| `job_id_label` | `varchar2` |  | [ ] |  |  |
| `job_title` | `varchar2` | Professione | [ ] |  |  |
| `last_activity` | `datetime` | Ultima attività | [ ] |  |  |
| `last_activity_time` | `varchar2` | Last Activity Time | [ ] |  |  |
| `last_appraisal_id` | `varchar2` |  | [ ] |  |  |
| `last_appraisal_id_label` | `varchar2` |  | [ ] |  |  |
| `last_attendance_id` | `varchar2` |  | [ ] |  |  |
| `last_attendance_id_label` | `varchar2` |  | [ ] |  |  |
| `leave_date_from` | `datetime` | Dalla data | [ ] |  |  |
| `leave_date_to` | `datetime` | Fino ad oggi | [ ] |  |  |
| `leave_manager_id` | `varchar2` |  | [ ] |  | Select the user responsible for approving "Time Off" of this employee.If empty, the approval is done by an Administrator or Approver (determined in settings/users). |
| `leave_manager_id_label` | `varchar2` |  | [ ] |  | Select the user responsible for approving "Time Off" of this employee.If empty, the approval is done by an Administrator or Approver (determined in settings/users). |
| `leaves_count` | `numeric` | Number of Time Off | [ ] |  |  |
| `member_of_department` | `boolean` | Member of department | [ ] |  | Whether the employee is a member of the active user's department or one of it's child department. |
| `mobile_phone` | `varchar2` | Cellulare lavoro | [ ] |  |  |
| `mobility_card` | `varchar2` | Mobility Card | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `parent_id` | `varchar2` |  | [ ] |  |  |
| `parent_id_label` | `varchar2` |  | [ ] |  |  |
| `parent_user_id` | `varchar2` |  | [ ] |  |  |
| `parent_user_id_label` | `varchar2` |  | [ ] |  |  |
| `related_contact_ids` | `varchar2` |  | [ ] |  |  |
| `related_contacts_count` | `int32` | Number of related contacts | [ ] |  |  |
| `remaining_leaves` | `numeric` | Remaining Paid Time Off | [ ] |  | Total number of paid time off allocated to this employee, change this value to create allocation/time off request.Total based on all the time off types without overriding limit. |
| `resource_calendar_id` | `varchar2` |  | [ ] |  |  |
| `resource_calendar_id_label` | `varchar2` |  | [ ] |  |  |
| `resource_id` | `varchar2` |  | [ ] |  |  |
| `resource_id_label` | `varchar2` |  | [ ] |  |  |
| `resume_line_ids` | `varchar2` |  | [ ] |  |  |
| `show_hr_icon_display` | `boolean` | Show Hr Icon Display | [ ] |  |  |
| `show_leaves` | `boolean` | Able to see Remaining Time Off | [ ] |  |  |
| `subordinate_ids` | `varchar2` |  | [ ] |  | Direct and indirect subordinates |
| `timesheet_manager_id` | `varchar2` |  | [ ] |  | User responsible of timesheet validation.Should be Timesheet Manager. |
| `timesheet_manager_id_label` | `varchar2` |  | [ ] |  | User responsible of timesheet validation.Should be Timesheet Manager. |
| `total_overtime` | `numeric` | Total Overtime | [ ] |  |  |
| `tz` | `varchar2` | Timezone | [ ] |  | This field is used in order to define in which timezone the resources will work. |
| `user_id` | `varchar2` |  | [ ] |  |  |
| `user_id_label` | `varchar2` |  | [ ] |  |  |
| `user_partner_id` | `varchar2` |  | [ ] |  | Partner-related data of the user |
| `user_partner_id_label` | `varchar2` |  | [ ] |  | Partner-related data of the user |
| `work_contact_id` | `varchar2` |  | [ ] |  |  |
| `work_contact_id_label` | `varchar2` |  | [ ] |  |  |
| `work_email` | `varchar2` | Email di lavoro | [ ] |  |  |
| `work_location_id` | `varchar2` |  | [ ] |  |  |
| `work_location_id_label` | `varchar2` |  | [ ] |  |  |
| `work_phone` | `varchar2` | Telefono di lavoro | [ ] |  |  |
| `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:

- [Odoo](/it/release-notes/drivers?driver=odoo)
