Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: hr > Tables

employee

Employee

Catalog: Odoo

Schema: hr

Documentation:

 

NB: Any field only available on the model hr.employee (i.e. not on the

hr.employee.public model) should have `groups="hr.group_hr_user"` on its

definition to avoid being prefetched when the user hasn't access to the

hr.employee model. Indeed, the prefetch loads the data for all the fields

that are available according to the group defined on them.

 

The data in this table is partitioned per value of the column.

This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.

Table Columns

The columns of the table employee are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

active

boolean

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_label

string

 

 

activity_calendar_event_id

string

 

 

activity_date_deadline

datetime

Next Activity Deadline

 

activity_exception_decoration

string

Activity Exception Decoration

Type of the exception activity on record.

activity_exception_icon

string

Icon

Icon to indicate an exception activity.

activity_ids

string

 

 

activity_state

string

Activity State

Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities.

activity_summary

string

Next Activity Summary

 

activity_type_icon

string

Activity Type Icon

Font awesome icon e.g. fa-tasks

activity_type_id_label

string

 

 

activity_type_id

string

 

 

activity_user_id_label

string

 

 

activity_user_id

string

 

 

additional_note

string

Additional Note

 

address_home_id_label

string

 

Enter here the private address of the employee, not the one linked to your company.

address_home_id

string

 

Enter here the private address of the employee, not the one linked to your company.

address_id_label

string

 

 

address_id

string

 

 

allocation_count

decimal

Total number of days allocated.

 

allocation_display

string

Allocation Display

 

allocation_remaining_display

string

Allocation Remaining Display

 

allocations_count

int32

Total number of allocations

 

applicant_id

string

 

 

appraisal_count

int32

Appraisal Count

 

appraisal_ids

string

 

 

attendance_ids

string

 

 

attendance_state

string

Attendance Status

 

avatar_1024

byte[]

Avatar 1024

 

avatar_128

byte[]

Avatar 128

 

avatar_1920

byte[]

Avatar

 

avatar_256

byte[]

Avatar 256

 

avatar_512

byte[]

Avatar 512

 

badge_ids

string

 

All employee badges, linked to the employee either directly or through the user

bank_account_id_label

string

 

Employee bank account to pay salaries

bank_account_id

string

 

Employee bank account to pay salaries

barcode

string

Badge ID

ID used for employee identification.

birthday

datetime

Date of Birth

 

calendar_mismatch

boolean

Calendar Mismatch

 

car_ids

string

 

 

category_ids

string

 

 

certificate

string

Certificate Level

 

child_all_count

int32

Indirect Subordinates Count

 

child_ids

string

 

 

children

int32

Number of Dependent Children

 

coach_id_label

string

 

Select the "Employee" who is the coach of this employee.The "Coach" has no specific rights or responsibilities by default.

coach_id

string

 

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_country_code

string

Country Code

The ISO country code in two chars. You can use this field for quick search.

company_country_id_label

string

 

 

company_country_id

string

 

 

company_id_label

string

 

 

company_id

string

 

 

contract_id_label

string

 

Current contract of the employee

contract_id

string

 

Current contract of the employee

contract_ids

string

 

 

contract_warning

boolean

Contract Warning

 

contracts_count

int32

Contract Count

 

country_id_label

string

 

 

country_id

string

 

 

country_of_birth_label

string

 

 

country_of_birth

string

 

 

courses_completion_text

string

Courses Completion Text

 

create_date

datetime

Created on

 

create_uid_label

string

 

 

create_uid

string

 

 

currency_id_label

string

 

 

currency_id

string

 

 

current_leave_id_label

string

 

 

current_leave_id

string

 

 

current_leave_state

string

Current Time Off Status

 

default_planning_role_id_label

string

 

Role that will be selected by default when creating a shift for this employee.This role will also have precedence over the other roles of the employee when planning orders.

default_planning_role_id

string

 

Role that will be selected by default when creating a shift for this employee.This role will also have precedence over the other roles of the employee when planning orders.

department_id_label

string

 

 

department_id

string

 

 

departure_date

datetime

Departure Date

 

departure_description

string

Additional Information

 

departure_reason_id_label

string

 

 

departure_reason_id

string

 

 

direct_badge_ids

string

 

Badges directly linked to the employee

display_name

string

Display Name

 

document_count

int32

Document Count

 

documents_share_id_label

string

 

 

documents_share_id

string

 

 

driving_license

byte[]

Driving License

 

emergency_contact

string

Contact Name

 

emergency_phone

string

Contact Phone

 

employee_cars_count

int32

Cars

 

employee_skill_ids

string

 

 

employee_token

string

Security Token

 

employee_type

string

Employee Type

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.

equipment_count

int32

Equipment Count

 

equipment_ids

string

 

 

expense_manager_id_label

string

 

Select the user responsible for approving "Expenses" of this employee.If empty, the approval is done by an Administrator or Approver (determined in settings/users).

expense_manager_id

string

 

Select the user responsible for approving "Expenses" of this employee.If empty, the approval is done by an Administrator or Approver (determined in settings/users).

first_contract_date

datetime

First Contract Date

 

flexible_hours

boolean

Flexible Hours

 

gender

string

Gender

 

goal_ids

string

 

 

has_badges

boolean

Has Badges

 

has_message

boolean

Has Message

 

has_work_permit

byte[]

Work Permit

 

hourly_cost

decimal

Hourly Cost

 

hours_last_month_display

string

Hours Last Month Display

 

hours_last_month

decimal

Hours Last Month

 

hours_today

decimal

Hours Today

 

hr_icon_display

string

Hr Icon Display

 

hr_presence_state

string

Hr Presence State

 

id_card

byte[]

ID Card Copy

 

id

int32

ID

 

identification_id

string

Identification No

 

image_1024

byte[]

Image 1024

 

image_128

byte[]

Image 128

 

image_1920

byte[]

Image

 

image_256

byte[]

Image 256

 

image_512

byte[]

Image 512

 

internet_invoice

byte[]

Internet Subscription Invoice

 

is_absent

boolean

Absent Today

 

is_address_home_a_company

boolean

The employee address has a company linked

 

is_subordinate

boolean

Is Subordinate

 

job_id_label

string

 

 

job_id

string

 

 

job_title

string

Job Title

 

km_home_work

int32

Home-Work Distance

 

lang

string

Lang

All the emails and documents sent to this contact will be translated in this language.

last_activity_time

string

Last Activity Time

 

last_activity

datetime

Last Activity

 

last_appraisal_date

datetime

Last Appraisal Date

The date of the last appraisal

last_appraisal_id_label

string

 

 

last_appraisal_id

string

 

 

last_attendance_id_label

string

 

 

last_attendance_id

string

 

 

last_check_in

datetime

Check In

 

last_check_out

datetime

Check Out

 

last_validated_timesheet_date

datetime

Last Validated Timesheet Date

 

leave_date_from

datetime

From Date

 

leave_date_to

datetime

To Date

 

leave_manager_id_label

string

 

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

string

 

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

decimal

Number of Time Off

 

license_plate

string

License Plate

 

marital

string

Marital Status

 

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.

message_attachment_count

int32

Attachment Count

 

message_follower_ids

string

 

 

message_has_error_counter

int32

Number of errors

Number of messages with delivery error

message_has_error

boolean

Message Delivery error

If checked, some messages have a delivery error.

message_has_sms_error

boolean

SMS Delivery error

If checked, some messages have a delivery error.

message_ids

string

 

 

message_is_follower

boolean

Is Follower

 

message_main_attachment_id_label

string

 

 

message_main_attachment_id

string

 

 

message_needaction_counter

int32

Number of Actions

Number of messages which requires an action

message_needaction

boolean

Action Needed

If checked, new messages require your attention.

message_partner_ids

string

 

 

mobile_invoice

byte[]

Mobile Subscription Invoice

 

mobile_phone

string

Work Mobile

 

mobility_card

string

Mobility Card

 

my_activity_date_deadline

datetime

My Activity Deadline

 

name

string

Employee Name

 

newly_hired_employee

boolean

Newly hired employee

 

next_appraisal_date

datetime

Next Appraisal Date

The date of the next appraisal is computed by the appraisal plan's dates (first appraisal + periodicity).

notes

string

Notes

 

ongoing_appraisal_count

int32

Ongoing Appraisal Count

 

overtime_ids

string

 

 

parent_id_label

string

 

 

parent_id

string

 

 

parent_user_id_label

string

 

Related user name for the resource to manage its access.

parent_user_id

string

 

Related user name for the resource to manage its access.

passport_id

string

Passport No

 

payslip_count

int32

Payslip Count

 

permit_no

string

Work Permit No

 

phone

string

Private Phone

 

pin

string

PIN

PIN used to Check In/Out in the Kiosk Mode of the Attendance application (if enabled in Configuration) and to change the cashier in the Point of Sale application.

place_of_birth

string

Place of Birth

 

planning_role_ids

string

 

Roles that the employee can fill in. When creating a shift for this employee, only the shift templates for these roles will be displayed.Similarly, only the open shifts available for these roles will be sent to the employee when the schedule is published.Additionally, the employee will only be assigned orders for these roles (with the default planning role having precedence over the other ones).Leave empty for the employee to be assigned shifts regardless of the role.

private_car_plate

string

Private Car Plate

If you have more than one car, just separate the plates by a space.

private_email

string

Private Email

 

registration_number

string

Registration Number of the Employee

 

related_contact_ids

string

 

 

related_contacts_count

int32

Number of related contacts

 

related_partner_id_label

string

 

 

related_partner_id

string

 

 

remaining_leaves

decimal

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_label

string

 

 

resource_calendar_id

string

 

 

resource_id_label

string

 

 

resource_id

string

 

 

resume_line_ids

string

 

 

salary_attachment_count

int32

Salary Attachment Count

 

salary_attachment_ids

string

 

 

show_hr_icon_display

boolean

Show Hr Icon Display

 

show_leaves

boolean

Able to see Remaining Time Off

 

sign_request_count

int32

Sign Request Count

 

sign_request_ids

string

 

 

sim_card

byte[]

SIM Card Copy

 

sinid

string

SIN No

Social Insurance Number

skill_ids

string

 

 

slip_ids

string

 

 

spouse_birthdate

datetime

Spouse Birthdate

 

spouse_complete_name

string

Spouse Complete Name

 

ssnid

string

SSN No

Social Security Number

study_field

string

Field of Study

 

study_school

string

School

 

subordinate_ids

string

 

Direct and indirect subordinates

subscribed_courses

string

 

 

timesheet_manager_id_label

string

 

Select the user responsible for approving "Timesheet" of this employee.If empty, the approval is done by a Timesheets > Administrator or a Timesheets > User: all timesheets (as determined in the users settings).

timesheet_manager_id

string

 

Select the user responsible for approving "Timesheet" of this employee.If empty, the approval is done by a Timesheets > Administrator or a Timesheets > User: all timesheets (as determined in the users settings).

total_overtime

decimal

Total Overtime

 

tz

string

Timezone

This field is used in order to define in which timezone the resources will work.

uncomplete_goals_count

int32

Uncomplete Goals Count

 

user_id_label

string

 

Related user name for the resource to manage its access.

user_id

string

 

Related user name for the resource to manage its access.

user_partner_id_label

string

 

Partner-related data of the user

user_partner_id

string

 

Partner-related data of the user

vehicle

string

Company Vehicle

 

visa_expire

datetime

Visa Expire Date

 

visa_no

string

Visa No

 

website_message_ids

string

 

Website communication history

work_contact_id_label

string

 

 

work_contact_id

string

 

 

work_email

string

Work Email

 

work_location_id_label

string

 

 

work_location_id

string

 

 

work_permit_expiration_date

datetime

Work Permit Expiration Date

 

work_permit_scheduled_activity

boolean

Work Permit Scheduled Activity

 

work_phone

string

Work Phone

 

write_date

datetime

Last Updated on

 

write_uid_label

string

 

 

write_uid

string

 

 

 

01-03-2023 15:29 Version 22.1.135-BETA+3826

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer