# work_entry HR Work Entry - 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 `work_entry` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active` | `boolean` | Active | ☐ | | | `attendance_id_label` | `string` | | ☐ | | | `attendance_id` | `string` | | ☐ | | | `color` | `int32` | Color | ☐ | | | `company_id_label` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `conflict` | `boolean` | Conflicts | ☐ | | | `contract_id_label` | `string` | | ☐ | | | `contract_id` | `string` | | ☐ | | | `create_date` | `datetime` | Created on | ☐ | | | `create_uid_label` | `string` | | ☐ | | | `create_uid` | `string` | | ☐ | | | `date_start` | `datetime` | From | ☑ | | | `date_stop` | `datetime` | To | ☐ | | | `department_id_label` | `string` | | ☐ | | | `department_id` | `string` | | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `duration` | `decimal` | Period | ☐ | | | `employee_id_label` | `string` | | ☐ | | | `employee_id` | `string` | | ☐ | | | `id` | `int32` | ID | ☐ | | | `leave_id_label` | `string` | | ☐ | | | `leave_id` | `string` | | ☐ | | | `leave_state` | `string` | Status | ☐ | The status is set to 'To Submit', when a time off request is created. The status is 'To Approve', when time off request is confirmed by user. The status is 'Refused', when time off request is refused by manager. The status is 'Approved', when time off request is approved by manager. | | `name` | `string` | Name | ☑ | | | `planning_slot_id_label` | `string` | | ☐ | | | `planning_slot_id` | `string` | | ☐ | | | `state` | `string` | State | ☐ | | | `work_entry_source` | `string` | Work Entry Source | ☐ | Defines the source for work entries generation Working Schedule: Work entries will be generated from the working hours below. Attendances: Work entries will be generated from the employee's attendances. (requires Attendance app) Planning: Work entries will be generated from the employee's planning. (requires Planning app) | | `work_entry_type_id_label` | `string` | | ☐ | | | `work_entry_type_id` | `string` | | ☐ | | | `write_date` | `datetime` | Last Updated on | ☐ | | | `write_uid_label` | `string` | | ☐ | | | `write_uid` | `string` | | ☐ | |