invantive documentation
Invantive Support ForumsLog In / Sign Up

employee: Odoo itgen_odoo_employee

read only per partition

  • Catalog: Odoo
  • Schema: hr
  • Label: itgen_odoo_employee

Employee

Can only retrieve data.

Summary

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.

Table Columns

The columns of the table employee 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 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
additional_note varchar2 Additional Note
address_home_id varchar2 Enter here the private address of the employee, not the one linked to your company.
address_home_id_label varchar2 Enter here the private address of the employee, not the one linked to your company.
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
applicant_id varchar2
appraisal_count int32 Appraisal Count
appraisal_ids varchar2
attendance_ids varchar2
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
bank_account_id varchar2 Employee bank account to pay salaries
bank_account_id_label varchar2 Employee bank account to pay salaries
barcode varchar2 Badge ID ID used for employee identification.
birthday datetime Date of Birth
calendar_mismatch boolean Calendar Mismatch
car_ids varchar2
category_ids varchar2
certificate varchar2 Certificate Level
child_all_count int32 Indirect Subordinates Count
child_ids varchar2
children int32 Number of Dependent Children
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_country_code varchar2 Country Code The ISO country code in two chars. You can use this field for quick search.
company_country_id varchar2
company_country_id_label varchar2
company_id varchar2
company_id_label varchar2
contract_id varchar2 Current contract of the employee
contract_id_label varchar2 Current contract of the employee
contract_ids varchar2
contract_warning boolean Contract Warning
contracts_count int32 Contract Count
country_id varchar2
country_id_label varchar2
country_of_birth varchar2
country_of_birth_label varchar2
courses_completion_text varchar2 Courses Completion Text
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
current_leave_id varchar2
current_leave_id_label varchar2
current_leave_state varchar2 Current Time Off Status
default_planning_role_id varchar2 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_label varchar2 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 varchar2
department_id_label varchar2
departure_date datetime Departure Date
departure_description varchar2 Additional Information
departure_reason_id varchar2
departure_reason_id_label varchar2
direct_badge_ids varchar2 Badges directly linked to the employee
display_name varchar2 Display Name
document_count int32 Document Count
documents_share_id varchar2
documents_share_id_label varchar2
driving_license varbinary Driving License
emergency_contact varchar2 Contact Name
emergency_phone varchar2 Contact Phone
employee_cars_count int32 Cars
employee_skill_ids varchar2
employee_token varchar2 Security Token
employee_type varchar2 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 varchar2
expense_manager_id varchar2 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_label varchar2 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 varchar2 Gender
goal_ids varchar2
has_badges boolean Has Badges
has_message boolean Has Message
has_work_permit varbinary Work Permit
hourly_cost numeric Hourly Cost
hours_last_month numeric Hours Last Month
hours_last_month_display varchar2 Hours Last Month Display
hours_today numeric Hours Today
hr_icon_display varchar2 Hr Icon Display
hr_presence_state varchar2 Hr Presence State
id int32 ID
id_card varbinary ID Card Copy
identification_id varchar2 Identification No
image_1024 varbinary Image 1024
image_128 varbinary Image 128
image_1920 varbinary Image
image_256 varbinary Image 256
image_512 varbinary Image 512
internet_invoice varbinary 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 varchar2
job_id_label varchar2
job_title varchar2 Job Title
km_home_work int32 Home-Work Distance
lang varchar2 Lang All the emails and documents sent to this contact will be translated in this language.
last_activity datetime Last Activity
last_activity_time varchar2 Last Activity Time
last_appraisal_date datetime Last Appraisal Date The date of the last appraisal
last_appraisal_id varchar2
last_appraisal_id_label varchar2
last_attendance_id varchar2
last_attendance_id_label varchar2
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 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
license_plate varchar2 License Plate
marital varchar2 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 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 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
mobile_invoice varbinary Mobile Subscription Invoice
mobile_phone varchar2 Work Mobile
mobility_card varchar2 Mobility Card
my_activity_date_deadline datetime My Activity Deadline
name varchar2 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 varchar2 Notes
ongoing_appraisal_count int32 Ongoing Appraisal Count
overtime_ids varchar2
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.
passport_id varchar2 Passport No
payslip_count int32 Payslip Count
permit_no varchar2 Work Permit No
phone varchar2 Private Phone
pin varchar2 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 varchar2 Place of Birth
planning_role_ids varchar2 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 varchar2 Private Car Plate If you have more than one car, just separate the plates by a space.
private_email varchar2 Private Email
registration_number varchar2 Registration Number of the Employee
related_contact_ids varchar2
related_contacts_count int32 Number of related contacts
related_partner_id varchar2
related_partner_id_label varchar2
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
salary_attachment_count int32 Salary Attachment Count
salary_attachment_ids varchar2
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 varchar2
sim_card varbinary SIM Card Copy
sinid varchar2 SIN No Social Insurance Number
skill_ids varchar2
slip_ids varchar2
spouse_birthdate datetime Spouse Birthdate
spouse_complete_name varchar2 Spouse Complete Name
ssnid varchar2 SSN No Social Security Number
study_field varchar2 Field of Study
study_school varchar2 School
subordinate_ids varchar2 Direct and indirect subordinates
subscribed_courses varchar2
timesheet_manager_id varchar2 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_label varchar2 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 numeric Total Overtime
tz varchar2 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 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.
user_partner_id varchar2 Partner-related data of the user
user_partner_id_label varchar2 Partner-related data of the user
vehicle varchar2 Company Vehicle
visa_expire datetime Visa Expire Date
visa_no varchar2 Visa No
website_message_ids varchar2 Website communication history
work_contact_id varchar2
work_contact_id_label varchar2
work_email varchar2 Work Email
work_location_id varchar2
work_location_id_label varchar2
work_permit_expiration_date datetime Work Permit Expiration Date
work_permit_scheduled_activity boolean Work Permit Scheduled Activity
work_phone varchar2 Work Phone
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

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