FUN_WF_PARTICIPANTS

Details

Schema: FUSION
Object owner: FUN
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
FUN_WF_PARTICIPANTS_PK	PARTICIPANT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PARTICIPANT_ID	NUMBER		18	Yes	Participant identifier and primary key.
STAGE_ID	NUMBER		18	Yes	Foreign key reference to FUN_WF_STAGES table.
PARENT_PARTICIPANT_ID	NUMBER		18		Parent participant identifier to represent the participants in a sequential order.
GROUP_ID	NUMBER		18		Identifier that the participants are at the same level and in parallel to each other.
PARENT_GROUP_ID	NUMBER		18		Parent participant group identifier to represent the participant group in a sequential order.
PARTICIPANT_KEY	VARCHAR2	512		Yes	Participant key as represented in the resource bundle.
PARTICIPANT_NAME	VARCHAR2	1000		Yes	Participant name on the BPM worklist application.
PARTICIPANT_TYPE_CODE	VARCHAR2	64		Yes	Type of the participant. Valid values are serial, parallel, single, and FYI.
IGNORE_PARTICIPANT_FLAG	VARCHAR2	1		Yes	Indicates whether the participant is ignored.
VOTE_OUTCOME_CODE	VARCHAR2	512			Outcome of the approval process when the minimum voting percentage has been achieved. This is only applicable to parallel type participants.
VOTE_PERCENTAGE	VARCHAR2	512			Minimum voting percentage to be achieved for making approval decision on the task. This is only applicable to parallel type participants.
DEFAULT_OUTCOME_CODE	VARCHAR2	512			Default outcome of the approval process when the minimum voting percentage has been achieved. This is only applicable to parallel type participants.
OUTCOME_TRIGGER_POLICY	VARCHAR2	512			Policy that decides when to trigger the voting outcome. This could be when minimum voting percentage is met or when all the votes are received. This is only applicable to parallel type participants.
SKIP_RULE	VARCHAR2	1000			Rule to specify when the whole participant evaluation can be skipped during runtime.
RULESET_NAME	VARCHAR2	512		Yes	Name of the rule set within the participant.
RULESET_DESCRIPTION	VARCHAR2	1000			Description of the rule set defined within a participant.
RULESET_START_DATE	TIMESTAMP				Effective start date of the rule set in DB timezone.
RULESET_END_DATE	TIMESTAMP				Effective end date of the rule set in DB timezone.
RULESET_ACTIVE_FLAG	VARCHAR2	1		Yes	Value to indicate whether ruleset is active or not.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
FUN_WF_PARTICIPANTS	fun_wf_stages	STAGE_ID
fun_wf_rules	fun_wf_participants	PARTICIPANT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
FUN_WF_PARTICIPANTS_FK1	Non Unique	Default	STAGE_ID
FUN_WF_PARTICIPANTS_PK	Unique	Default	PARTICIPANT_ID