invantive documentation
Invantive Support ForumsLog In / Sign Up

appraisal: Odoo itgen_odoo_appraisal

read only per partition

  • Catalog: Odoo
  • Schema: hr
  • Label: itgen_odoo_appraisal

Employee Appraisal

Can only retrieve data.

Table Columns

The columns of the table appraisal 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
appraisal_plan_posted boolean Appraisal Plan Posted
assessment_note varchar2 This field is not visible to the Employee.
assessment_note_label varchar2 This field is not visible to the Employee.
avatar_128 varbinary Avatar 128
avatar_1920 varbinary Avatar
can_see_employee_publish boolean Can See Employee Publish
can_see_manager_publish boolean Can See Manager Publish
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
date_close datetime Appraisal Date Date of the appraisal, automatically updated when the appraisal is Done or Cancelled.
date_final_interview datetime Final Interview
department_id varchar2
department_id_label varchar2
display_name varchar2 Display Name
employee_appraisal_count int32 Appraisal Count
employee_autocomplete_ids varchar2
employee_feedback varchar2 Employee Feedback
employee_feedback_published boolean Employee Feedback Published
employee_feedback_template varchar2 Employee Feedback Template
employee_id varchar2
employee_id_label varchar2
employee_user_id varchar2 Related user name for the resource to manage its access.
employee_user_id_label varchar2 Related user name for the resource to manage its access.
has_message boolean Has Message
id int32 ID
image_128 varbinary Image 128
image_1920 varbinary Image
is_appraisal_manager boolean Is Appraisal Manager
is_implicit_manager boolean Is Implicit Manager
last_appraisal_date datetime Last Appraisal Date The date of the last appraisal
last_appraisal_id varchar2
last_appraisal_id_label varchar2
manager_feedback varchar2 Manager Feedback
manager_feedback_published boolean Manager Feedback Published
manager_feedback_template varchar2 Manager Feedback Template
manager_ids varchar2
manager_user_ids varchar2
meeting_count_display varchar2 Meeting Count
meeting_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
my_activity_date_deadline datetime My Activity Deadline
note varchar2 Private Note The content of this note is not visible by the Employee.
show_employee_feedback_full boolean Show Employee Feedback Full
show_manager_feedback_full boolean Show Manager Feedback Full
skill_ids varchar2
state varchar2 Status
uncomplete_goals_count int32 Uncomplete Goals Count
waiting_feedback boolean Waiting Feedback from Employee/Managers
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: