invantive documentation
Invantive Support ForumsLog In / Sign Up

contract: Odoo itgen_odoo_contract

read only per partition

  • Catalog: Odoo
  • Schema: hr
  • Label: itgen_odoo_contract

Employee Contract

Can only retrieve data.

Table Columns

The columns of the table contract 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
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
analytic_account_id varchar2
analytic_account_id_label varchar2
calendar_changed boolean Calendar Changed Whether the previous or next contract has a different schedule or not
calendar_mismatch boolean Calendar Mismatch
company_country_id varchar2
company_country_id_label varchar2
company_id varchar2
company_id_label varchar2
contract_type_id varchar2
contract_type_id_label varchar2
contract_wage numeric Contract Wage
contracts_count int32 Contract Count
country_code varchar2 Country Code The ISO country code in two chars. You can use this field for quick search.
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
date_end datetime End Date End date of the contract (if it's a fixed-term contract).
date_generated_from datetime Generated From
date_generated_to datetime Generated To
date_start datetime Start Date
department_id varchar2
department_id_label varchar2
display_name varchar2 Display Name
employee_id varchar2
employee_id_label varchar2
first_contract_date datetime First Contract Date
full_time_required_hours numeric Fulltime Hours Number of hours to work to be considered as fulltime.
has_message boolean Has Message
hourly_wage numeric Hourly Wage Employee's hourly gross wage.
hours_per_week numeric Hours per Week
hr_responsible_id varchar2 Person responsible for validating the employee's contracts.
hr_responsible_id_label varchar2 Person responsible for validating the employee's contracts.
id int32 ID
is_fulltime boolean Is Full Time
job_id varchar2
job_id_label varchar2
kanban_state varchar2 Kanban State
last_generation_date datetime Last Generation Date
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Contract Reference
notes varchar2 Notes
payslips_count int32 # Payslips
permit_no varchar2 Work Permit No
resource_calendar_id varchar2 Employee's working schedule.
resource_calendar_id_label varchar2 Employee's working schedule.
schedule_pay varchar2 Scheduled Pay Defines the frequency of the wage payment.
sign_request_count int32 Sign Request Count
sign_request_ids varchar2
standard_calendar_id varchar2
standard_calendar_id_label varchar2
state varchar2 Status Status of the contract
structure_type_id varchar2
structure_type_id_label varchar2
time_credit boolean Part Time
time_credit_type_id varchar2 The work entry type used when generating work entries to fit full time working schedule.
time_credit_type_id_label varchar2 The work entry type used when generating work entries to fit full time working schedule.
trial_date_end datetime End of Trial Period End date of the trial period (if there is one).
visa_expire datetime Visa Expire Date
visa_no varchar2 Visa No
wage numeric Wage Employee's monthly gross wage.
wage_type varchar2 Wage Type
website_message_ids varchar2 Website communication history
work_entry_source varchar2 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_time_rate numeric Work time rate Work time rate versus full time working schedule.
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: