Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: