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