challenge: Odoo itgen_odoo_challenge
read only per partition
- Catalog:
Odoo - Schema:
gamification - Label: itgen_odoo_challenge
Gamification Challenge
Can only retrieve data.
Summary
Gamification challenge
Set of predifined objectives assigned to people with rules for recurrence and
rewards
If 'user_ids' is defined and 'period' is different than 'one', the set will
be assigned to the users for each period (eg: every 1st of each month if
'monthly' is selected)
Table Columns
The columns of the table challenge 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 |
Appears in | Define the visibility of the challenge through menus | ||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
description |
varchar2 |
Description | |||
display_ |
varchar2 |
Display Name | |||
end_ |
datetime |
End Date | The day a new challenge will be automatically closed. If no periodicity is set, will use this date as the goal end date. | ||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
invited_ |
varchar2 |
||||
last_ |
datetime |
Last Report Date | |||
line_ |
varchar2 |
List of goals that will be set | |||
manager_ |
varchar2 |
||||
manager_ |
varchar2 |
||||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
name |
varchar2 |
Challenge Name | |||
next_ |
datetime |
Next Report Date | |||
period |
varchar2 |
Periodicity | Period of automatic goal assignment. If none is selected, should be launched manually. | ||
remind_ |
int32 |
Non-updated manual goals will be reminded after | Never reminded if no value or zero is specified. | ||
report_ |
varchar2 |
Report Frequency | |||
report_ |
varchar2 |
Group that will receive a copy of the report in addition to the user | |||
report_ |
varchar2 |
Group that will receive a copy of the report in addition to the user | |||
report_ |
varchar2 |
||||
report_ |
varchar2 |
||||
reward_ |
boolean |
Reward Bests if not Succeeded? | |||
reward_ |
varchar2 |
||||
reward_ |
varchar2 |
||||
reward_ |
varchar2 |
||||
reward_ |
varchar2 |
||||
reward_ |
boolean |
Reward as soon as every goal is reached | With this option enabled, a user can receive a badge only once. The top 3 badges are still rewarded only at the end of the challenge. | ||
reward_ |
varchar2 |
||||
reward_ |
varchar2 |
||||
reward_ |
varchar2 |
||||
reward_ |
varchar2 |
||||
start_ |
datetime |
Start Date | The day a new challenge will be automatically started. If no periodicity is set, will use this date as the goal start date. | ||
state |
varchar2 |
State | |||
user_ |
int32 |
# Users | |||
user_ |
varchar2 |
User domain | |||
user_ |
varchar2 |
||||
visibility_ |
varchar2 |
Display Mode | |||
website_ |
varchar2 |
Website communication history | |||
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: