---
title: "contract_employee_report (Odoo)"
description: "itgen_odoo_contract_employee_report"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.hr.contract_employee_report
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.hr.contract_employee_report
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# contract_employee_report: Odoo itgen_odoo_contract_employee_report

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `hr`
- Label: itgen_odoo_contract_employee_report

Contract and Employee Analysis Report

Can only retrieve data.

## Table Columns

The columns of the table `contract_employee_report` 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 |
|---|---|---|:---:|---|---|
| `age_sum` | `numeric` | Duration Contract | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `contract_id` | `varchar2` |  | [ ] |  |  |
| `contract_id_label` | `varchar2` |  | [ ] |  |  |
| `count_employee_exit` | `int32` | # Departure Employee | [ ] |  |  |
| `count_new_employee` | `int32` | # New Employees | [ ] |  |  |
| `date` | `datetime` | Date | [ ] |  |  |
| `date_end_contract` | `datetime` | Date Last Contract Ended | [ ] |  |  |
| `department_id` | `varchar2` |  | [ ] |  |  |
| `department_id_label` | `varchar2` |  | [ ] |  |  |
| `departure_reason_id` | `varchar2` |  | [ ] |  |  |
| `departure_reason_id_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `employee_id` | `varchar2` |  | [ ] |  |  |
| `employee_id_label` | `varchar2` |  | [ ] |  |  |
| `end_date_months` | `int32` | Months of last date of this month since 01/01/1970 | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `start_date_months` | `int32` | Months of first date of this month since 01/01/1970 | [ ] |  |  |
| `wage` | `numeric` | Wage | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

