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 |