---
title: "employee_base (Odoo)"
description: "itgen_odoo_employee_base"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.hr.employee_base
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.hr.employee_base
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# employee_base: Odoo itgen_odoo_employee_base

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `hr`
- Label: itgen_odoo_employee_base

Basic Employee

Can only retrieve data.

## Summary

The base model, which is implicitly inherited by all models.

## Table Columns

The columns of the table `employee_base` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | 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 | [ ] |  |  |
| `badge_ids` | `varchar2` |  | [ ] |  | All employee badges, linked to the employee either directly or through the user |
| `child_all_count` | `int32` | Indirect Subordinates Count | [ ] |  |  |
| `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` |  | [ ] |  |  |
| `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 |
| `employee_type` | `varchar2` | Employee Type | [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. |
| `goal_ids` | `varchar2` |  | [ ] |  |  |
| `has_badges` | `boolean` | Has Badges | [ ] |  |  |
| `hr_icon_display` | `varchar2` | Hr Icon Display | [ ] |  |  |
| `hr_presence_state` | `varchar2` | Hr Presence State | [ ] |  |  |
| `is_absent` | `boolean` | Absent Today | [ ] |  |  |
| `job_id` | `varchar2` |  | [ ] |  |  |
| `job_id_label` | `varchar2` |  | [ ] |  |  |
| `job_title` | `varchar2` | Job Title | [ ] |  |  |
| `last_activity` | `datetime` | Last Activity | [ ] |  |  |
| `last_activity_time` | `varchar2` | Last Activity Time | [ ] |  |  |
| `last_appraisal_id` | `varchar2` |  | [ ] |  |  |
| `last_appraisal_id_label` | `varchar2` |  | [ ] |  |  |
| `leave_date_from` | `datetime` | From Date | [ ] |  |  |
| `leave_date_to` | `datetime` | To Date | [ ] |  |  |
| `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` | Work Mobile | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `parent_id` | `varchar2` |  | [ ] |  |  |
| `parent_id_label` | `varchar2` |  | [ ] |  |  |
| `parent_user_id` | `varchar2` |  | [ ] |  | Related user name for the resource to manage its access. |
| `parent_user_id_label` | `varchar2` |  | [ ] |  | Related user name for the resource to manage its access. |
| `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` |  | [ ] |  |  |
| `show_hr_icon_display` | `boolean` | Show Hr Icon Display | [ ] |  |  |
| `show_leaves` | `boolean` | Able to see Remaining Time Off | [ ] |  |  |
| `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` |  | [ ] |  |  |
| `work_contact_id` | `varchar2` |  | [ ] |  |  |
| `work_contact_id_label` | `varchar2` |  | [ ] |  |  |
| `work_email` | `varchar2` | Work Email | [ ] |  |  |
| `work_location_id` | `varchar2` |  | [ ] |  |  |
| `work_location_id_label` | `varchar2` |  | [ ] |  |  |
| `work_phone` | `varchar2` | Work Phone | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

