invantive documentation
Invantive Support ForumsLog In / Sign Up

department: Odoo itgen_odoo_department

read only per partition

  • Catalog: Odoo
  • Schema: hr
  • Label: itgen_odoo_department

Department

Can only retrieve data.

Table Columns

The columns of the table department 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
absence_of_today int32 Absence by Today
active boolean Active
allocation_to_approve_count int32 Allocation to Approve
appraisals_to_process_count int32 Appraisals to Process
child_ids varchar2
color int32 Color Index
company_id varchar2
company_id_label varchar2
complete_name varchar2 Complete Name
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
custom_appraisal_templates boolean Custom Appraisal Templates
display_name varchar2 Display Name
employee_feedback_template varchar2 Employee Feedback Template
expected_employee int32 Expected Employee
expense_sheets_to_approve_count int32 Expenses Reports to Approve
has_message boolean Has Message
id int32 ID
jobs_ids varchar2
leave_to_approve_count int32 Time Off to Approve
manager_feedback_template varchar2 Manager Feedback Template
manager_id varchar2
manager_id_label varchar2
master_department_id varchar2
master_department_id_label varchar2
member_ids varchar2
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
name varchar2 Department Name
new_applicant_count int32 New Applicant
new_hired_employee int32 New Hired Employee
note varchar2 Note
parent_id varchar2
parent_id_label varchar2
parent_path varchar2 Parent Path
plan_ids varchar2
plans_count int32 Plans Count
total_employee int32 Total Employee
website_message_ids varchar2 Website communication history
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: