# contract_history Contract history - 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 `contract_history` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active_employee` | `boolean` | Active Employee | ☐ | | | `activity_state` | `string` | Activity State | ☐ | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | | `analytic_account_id_label` | `string` | | ☐ | | | `analytic_account_id` | `string` | | ☐ | | | `company_country_id_label` | `string` | | ☐ | | | `company_country_id` | `string` | | ☐ | | | `company_id_label` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `contract_count` | `int32` | # Contracts | ☐ | | | `contract_id_label` | `string` | | ☐ | | | `contract_id` | `string` | | ☐ | | | `contract_ids` | `string` | | ☐ | | | `contract_type_id_label` | `string` | | ☐ | | | `contract_type_id` | `string` | | ☐ | | | `country_code` | `string` | Country Code | ☐ | The ISO country code in two chars. You can use this field for quick search. | | `currency_id_label` | `string` | | ☐ | | | `currency_id` | `string` | | ☐ | | | `date_end` | `datetime` | End Date | ☐ | | | `date_hired` | `datetime` | Hire Date | ☐ | | | `date_start` | `datetime` | Start Date | ☐ | | | `department_id_label` | `string` | | ☐ | | | `department_id` | `string` | | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `employee_id_label` | `string` | | ☐ | | | `employee_id` | `string` | | ☐ | | | `hr_responsible_id_label` | `string` | | ☐ | | | `hr_responsible_id` | `string` | | ☐ | | | `id` | `int32` | ID | ☐ | | | `is_under_contract` | `boolean` | Is Currently Under Contract | ☐ | | | `job_id_label` | `string` | | ☐ | | | `job_id` | `string` | | ☐ | | | `name` | `string` | Contract Name | ☐ | | | `payslips_count` | `int32` | # Payslips | ☐ | | | `resource_calendar_id_label` | `string` | | ☐ | | | `resource_calendar_id` | `string` | | ☐ | | | `salary_attachment_count` | `string` | Salary Attachment Count | ☐ | | | `sign_request_ids` | `string` | | ☐ | | | `standard_calendar_id_label` | `string` | | ☐ | | | `standard_calendar_id` | `string` | | ☐ | | | `state` | `string` | Status | ☐ | | | `structure_type_id_label` | `string` | | ☐ | | | `structure_type_id` | `string` | | ☐ | | | `time_credit` | `boolean` | Credit time | ☐ | This is a credit time contract. | | `under_contract_state` | `string` | Contractual Status | ☐ | | | `wage_type` | `string` | Wage Type | ☐ | | | `wage` | `decimal` | Wage | ☐ | Employee's monthly gross wage. | | `work_time_rate` | `decimal` | Work time rate | ☐ | Work time rate versus full time working schedule. |