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