employee_public |
Public Employee
Catalog: Odoo
Schema: hr
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_public are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
active |
boolean |
Active |
☐ |
|
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 |
☐ |
|
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 |
child_all_count |
int32 |
Indirect Subordinates Count |
☐ |
|
child_ids |
string |
|
☐ |
|
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_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
create_date |
datetime |
Create Date |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
current_leave_state |
string |
Current Time Off Status |
☐ |
|
department_id_label |
string |
|
☐ |
|
department_id |
string |
|
☐ |
|
direct_badge_ids |
string |
|
☐ |
Badges directly linked to the employee |
display_name |
string |
Display Name |
☐ |
|
employee_id_label |
string |
|
☐ |
|
employee_id |
string |
|
☐ |
|
employee_skill_ids |
string |
|
☐ |
|
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. |
expense_manager_id_label |
string |
|
☐ |
|
expense_manager_id |
string |
|
☐ |
|
first_contract_date |
datetime |
First Contract Date |
☐ |
|
goal_ids |
string |
|
☐ |
|
has_badges |
boolean |
Has Badges |
☐ |
|
hours_today |
decimal |
Hours Today |
☐ |
|
hr_icon_display |
string |
Hr Icon Display |
☐ |
|
hr_presence_state |
string |
Hr Presence State |
☐ |
|
id |
int32 |
ID |
☐ |
|
image_1024 |
byte[] |
Image 1024 |
☐ |
|
image_128 |
byte[] |
Image 128 |
☐ |
|
image_1920 |
byte[] |
Image |
☐ |
|
image_256 |
byte[] |
Image 256 |
☐ |
|
image_512 |
byte[] |
Image 512 |
☐ |
|
is_absent |
boolean |
Absent Today |
☐ |
|
is_subordinate |
boolean |
Is Subordinate |
☐ |
|
job_id_label |
string |
|
☐ |
|
job_id |
string |
|
☐ |
|
job_title |
string |
Job Title |
☐ |
|
last_activity_time |
string |
Last Activity Time |
☐ |
|
last_activity |
datetime |
Last Activity |
☐ |
|
last_appraisal_id_label |
string |
|
☐ |
|
last_appraisal_id |
string |
|
☐ |
|
last_attendance_id_label |
string |
|
☐ |
|
last_attendance_id |
string |
|
☐ |
|
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 |
☐ |
|
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 |
string |
Work Mobile |
☐ |
|
mobility_card |
string |
Mobility Card |
☐ |
|
name |
string |
Name |
☐ |
|
parent_id_label |
string |
|
☐ |
|
parent_id |
string |
|
☐ |
|
parent_user_id_label |
string |
|
☐ |
|
parent_user_id |
string |
|
☐ |
|
related_contact_ids |
string |
|
☐ |
|
related_contacts_count |
int32 |
Number of related contacts |
☐ |
|
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 |
|
☐ |
|
show_hr_icon_display |
boolean |
Show Hr Icon Display |
☐ |
|
show_leaves |
boolean |
Able to see Remaining Time Off |
☐ |
|
subordinate_ids |
string |
|
☐ |
Direct and indirect subordinates |
timesheet_manager_id_label |
string |
|
☐ |
User responsible of timesheet validation. Should be Timesheet Manager. |
timesheet_manager_id |
string |
|
☐ |
User responsible of timesheet validation. Should be Timesheet Manager. |
total_overtime |
decimal |
Total Overtime |
☐ |
|
tz |
string |
Timezone |
☐ |
This field is used in order to define in which timezone the resources will work. |
user_id_label |
string |
|
☐ |
|
user_id |
string |
|
☐ |
|
user_partner_id_label |
string |
|
☐ |
Partner-related data of the user |
user_partner_id |
string |
|
☐ |
Partner-related data of the user |
work_contact_id_label |
string |
|
☐ |
|
work_contact_id |
string |
|
☐ |
|
work_email |
string |
Work Email |
☐ |
|
work_location_id_label |
string |
|
☐ |
|
work_location_id |
string |
|
☐ |
|
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