KWFL_APPROVAL_RECIPIENTS

This table stores a row for each user authorized to vote on a multi-voter approval step. The rows are inserted into this table when the step first becomes Eligible. The rows are then updated with the result value chosen by the user, or the new approval recipient if the user chose to delegate his/her vote.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KWFL_APPROVAL_RECIPIENTS	APPROVAL_RECIPIENT_ID	DELEGATED_TO_RECIPIENT_ID
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KWFL_STEP_TRANSACTIONS	STEP_TRANSACTION_ID	STEP_TRANSACTION_ID
KNTA_USERS	USER_ID	USER_ID

Column Descriptions

Column Name	Null?	Data Type	Description
APPROVAL_RECIPIENT_ID	NOT NULL	NUMBER	System-generated identifier
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
CREATION_DATE	NOT NULL	DATE	Date record was created
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
STEP_TRANSACTION_ID	NULLABLE	NUMBER	Identifies the approval step transaction to which this approval recipient row belongs.
USER_ID	NOT NULL	NUMBER	Identifies the user authorized to vote for the given approval step transaction
DELEGATED_FLAG	NOT NULL	VARCHAR2(1)	Specifies whether the user has delegated his vote to another user
DELEGATED_TO_RECIPIENT_ID	NULLABLE	NUMBER	Identifies the approval recipient row inserted when this user delegated his vote. This is a key into this same table.
RESULT_VALUE	NULLABLE	VARCHAR2(200)	Specifies the hidden result value chosen by this user
VISIBLE_RESULT_VALUE	NULLABLE	VARCHAR2(200)	Specifies the displayed result value chosen by the user

Indexes

Index Name	Index Type	Sequence	Column Name
KWFL_APPROVAL_RECIPIENTS_N1	NONUNIQUE	1	STEP_TRANSACTION_ID
KWFL_APPROVAL_RECIPIENTS_N1	NONUNIQUE	2	USER_ID
KWFL_APPROVAL_RECIPIENTS_N2	NONUNIQUE	1	USER_ID
KWFL_APPROVAL_RECIPIENTS_N3	NONUNIQUE	1	DELEGATED_TO_RECIPIENT_ID
KWFL_APPROVAL_RECIPIENTS_U1	UNIQUE	1	APPROVAL_RECIPIENT_ID

Sequences

Sequence Name	Sequence Type
KWFL_APPROVAL_RECIPIENTS_S	APPROVAL_RECIPIENT_ID