invantive documentation
Invantive Support ForumsLog In / Sign Up

employee_public: Odoo itgen_odoo_employee_public

read only per partition

  • Catalog: Odoo
  • Schema: hr
  • Label: itgen_odoo_employee_public

Public Employee

Can only retrieve data.

Table Columns

The columns of the table employee_public 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
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
child_all_count int32 Indirect Subordinates Count
child_ids varchar2
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
create_date datetime Create Date
create_uid varchar2
create_uid_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
display_name varchar2 Display Name
employee_id varchar2
employee_id_label varchar2
employee_skill_ids varchar2
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.
expense_manager_id varchar2
expense_manager_id_label varchar2
first_contract_date datetime First Contract Date
goal_ids varchar2
has_badges boolean Has Badges
hours_today numeric Hours Today
hr_icon_display varchar2 Hr Icon Display
hr_presence_state varchar2 Hr Presence State
id int32 ID
image_1024 varbinary Image 1024
image_128 varbinary Image 128
image_1920 varbinary Image
image_256 varbinary Image 256
image_512 varbinary Image 512
is_absent boolean Absent Today
is_subordinate boolean Is Subordinate
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
last_attendance_id varchar2
last_attendance_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
mobility_card varchar2 Mobility Card
name varchar2 Name
parent_id varchar2
parent_id_label varchar2
parent_user_id varchar2
parent_user_id_label varchar2
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
resume_line_ids varchar2
show_hr_icon_display boolean Show Hr Icon Display
show_leaves boolean Able to see Remaining Time Off
subordinate_ids varchar2 Direct and indirect subordinates
timesheet_manager_id varchar2 User responsible of timesheet validation. Should be Timesheet Manager.
timesheet_manager_id_label varchar2 User responsible of timesheet validation. Should be Timesheet Manager.
total_overtime numeric Total Overtime
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
user_partner_id varchar2 Partner-related data of the user
user_partner_id_label varchar2 Partner-related data of the user
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
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: