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_ |
varchar2 |
Challenge that generated the goal, assign challenge to users to generate goals with a value in this field. | |||
challenge_ |
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_ |
varchar2 |
Computation Mode | Define how the goals will be computed. The result of the operation will be stored in the field 'Current'. | ||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
current |
numeric |
Current Value | |||
definition_ |
varchar2 |
Definition Condition | A goal is considered as completed when the current value is compared to the value to reach | ||
definition_ |
varchar2 |
Definition Description | |||
definition_ |
varchar2 |
Display Mode | |||
definition_ |
varchar2 |
||||
definition_ |
varchar2 |
||||
definition_ |
varchar2 |
Suffix | The currency and suffix field | ||
display_ |
varchar2 |
Display Name | |||
end_ |
datetime |
End Date | |||
id |
int32 |
ID | |||
last_ |
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_ |
varchar2 |
||||
line_ |
varchar2 |
||||
remind_ |
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_ |
datetime |
Start Date | |||
state |
varchar2 |
State | |||
target_ |
numeric |
To Reach | |||
to_ |
boolean |
To update | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: