invantive documentation
Invantive Support ForumsLog In / Sign Up

goal: Odoo itgen_odoo_goal

read only per partition

  • Catalog: Odoo
  • Schema: gamification
  • Label: itgen_odoo_goal

Gamification Goal

Can only retrieve data.

Summary

Goal instance for a user

An individual goal for a user on a specified time period

Table Columns

The columns of the table goal 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
challenge_id varchar2 Challenge that generated the goal, assign challenge to users to generate goals with a value in this field.
challenge_id_label varchar2 Challenge that generated the goal, assign challenge to users to generate goals with a value in this field.
closed boolean Closed goal
completeness numeric Completeness
computation_mode varchar2 Computation Mode Define how the goals will be computed. The result of the operation will be stored in the field 'Current'.
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
current numeric Current Value
definition_condition varchar2 Definition Condition A goal is considered as completed when the current value is compared to the value to reach
definition_description varchar2 Definition Description
definition_display varchar2 Display Mode
definition_id varchar2
definition_id_label varchar2
definition_suffix varchar2 Suffix The currency and suffix field
display_name varchar2 Display Name
end_date datetime End Date
id int32 ID
last_update datetime Last Update In case of manual goal, reminders are sent if the goal as not been updated for a while (defined in challenge). Ignored in case of non-manual goal or goal not linked to a challenge.
line_id varchar2
line_id_label varchar2
remind_update_delay int32 Remind delay The number of days after which the user assigned to a manual goal will be reminded. Never reminded if no value is specified.
start_date datetime Start Date
state varchar2 State
target_goal numeric To Reach
to_update boolean To update
user_id varchar2
user_id_label varchar2
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: