CSO_REPUTATION_REWARD

This table contains the reputation model reward points for user activities.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_REPUTATION_REWARD_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments	Status
ADMIN_POINTS	NUMBER			Number of points awarded to admin users for this activity.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP		Yes	Date record was last modified in repository.
ADMIN_FLOAT_MUTIPLIER	NUMBER			Float Multiplier to be applied to admin users' reward. Usually used for case links points.
ADMIN_INT_MUTIPLIER	NUMBER			Int Multiplier to be applied to admin users' rewards. Usually used for ratings.
FLOAT_MUTIPLIER	NUMBER			Float Multiplier to be applied to web users' reward. Usually used for case links points.
INT_MUTIPLIER	NUMBER			Int Multiplier to be applied to web users' rewards. Usually used for ratings.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
REFERENCE_KEY	VARCHAR2	100	Yes	This is the reference key identifier for this object.
REPUTATION_ID	VARCHAR2	32	Yes	This is the GUID reference to the reputationconfig object.
TYPE	NUMBER			This is the type of this reward.
CATEGORY	NUMBER			The category of this reward. 10 - Content, 20 - Discussion Boards.
USER_POINTS	NUMBER			Number of points awarded to web users for this activity.
SEED_DATA_SOURCE	VARCHAR2	512		Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.	Obsolete

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_REPUTATION_REWARD	cso_reputation_config	REPUTATION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_REPUTATION_REWARD_N1	Non Unique	Default	REPUTATION_ID
CSO_REPUTATION_REWARD_U1	Unique	Default	RECORD_ID