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_ |
varchar2 |
||||
address_ |
varchar2 |
||||
allocation_ |
numeric |
Total number of days allocated. | |||
allocation_ |
varchar2 |
Allocation Display | |||
allocation_ |
varchar2 |
Allocation Remaining Display | |||
allocations_ |
int32 |
Total number of allocations | |||
attendance_ |
varchar2 |
Attendance Status | |||
avatar_ |
varbinary |
Avatar 1024 | |||
avatar_ |
varbinary |
Avatar 128 | |||
avatar_ |
varbinary |
Avatar | |||
avatar_ |
varbinary |
Avatar 256 | |||
avatar_ |
varbinary |
Avatar 512 | |||
badge_ |
varchar2 |
All employee badges, linked to the employee either directly or through the user | |||
child_ |
int32 |
Indirect Subordinates Count | |||
child_ |
varchar2 |
||||
coach_ |
varchar2 |
Select the "Employee" who is the coach of this employee. The "Coach" has no specific rights or responsibilities by default. | |||
coach_ |
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_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Create Date | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
current_ |
varchar2 |
Current Time Off Status | |||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
direct_ |
varchar2 |
Badges directly linked to the employee | |||
display_ |
varchar2 |
Display Name | |||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
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_ |
varchar2 |
||||
expense_ |
varchar2 |
||||
first_ |
datetime |
First Contract Date | |||
goal_ |
varchar2 |
||||
has_ |
boolean |
Has Badges | |||
hours_ |
numeric |
Hours Today | |||
hr_ |
varchar2 |
Hr Icon Display | |||
hr_ |
varchar2 |
Hr Presence State | |||
id |
int32 |
ID | |||
image_ |
varbinary |
Image 1024 | |||
image_ |
varbinary |
Image 128 | |||
image_ |
varbinary |
Image | |||
image_ |
varbinary |
Image 256 | |||
image_ |
varbinary |
Image 512 | |||
is_ |
boolean |
Absent Today | |||
is_ |
boolean |
Is Subordinate | |||
job_id |
varchar2 |
||||
job_ |
varchar2 |
||||
job_ |
varchar2 |
Job Title | |||
last_ |
datetime |
Last Activity | |||
last_ |
varchar2 |
Last Activity Time | |||
last_ |
varchar2 |
||||
last_ |
varchar2 |
||||
last_ |
varchar2 |
||||
last_ |
varchar2 |
||||
leave_ |
datetime |
From Date | |||
leave_ |
datetime |
To Date | |||
leave_ |
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_ |
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_ |
numeric |
Number of Time Off | |||
member_ |
boolean |
Member of department | Whether the employee is a member of the active user's department or one of it's child department. | ||
mobile_ |
varchar2 |
Work Mobile | |||
mobility_ |
varchar2 |
Mobility Card | |||
name |
varchar2 |
Name | |||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
related_ |
varchar2 |
||||
related_ |
int32 |
Number of related contacts | |||
remaining_ |
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_ |
varchar2 |
||||
resource_ |
varchar2 |
||||
resource_ |
varchar2 |
||||
resource_ |
varchar2 |
||||
resume_ |
varchar2 |
||||
show_ |
boolean |
Show Hr Icon Display | |||
show_ |
boolean |
Able to see Remaining Time Off | |||
subordinate_ |
varchar2 |
Direct and indirect subordinates | |||
timesheet_ |
varchar2 |
User responsible of timesheet validation. Should be Timesheet Manager. | |||
timesheet_ |
varchar2 |
User responsible of timesheet validation. Should be Timesheet Manager. | |||
total_ |
numeric |
Total Overtime | |||
tz |
varchar2 |
Timezone | This field is used in order to define in which timezone the resources will work. | ||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
user_ |
varchar2 |
Partner-related data of the user | |||
user_ |
varchar2 |
Partner-related data of the user | |||
work_ |
varchar2 |
||||
work_ |
varchar2 |
||||
work_ |
varchar2 |
Work Email | |||
work_ |
varchar2 |
||||
work_ |
varchar2 |
||||
work_ |
varchar2 |
Work Phone | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: