Share this page

# KWFL_APPROVALS

The term "Approval" has changed to "Decision", but the schema still uses the older term. A decision is represented by one row in this table. Workflow steps can be of three types: decisions, conditions, and executions.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_VALIDATIONS_NLS | VALIDATION_ID | RESULT_VALIDATION_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_PARAMETER_SET_CONTEXTS | PARAMETER_SET_CONTEXT_ID | USER_DATA_SET_CONTEXT_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
APPROVAL_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
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
APPROVAL_NAME | NOT NULL | VARCHAR2(100) | Name of the approval, which is also the default name of the defining workflow steps.
DESCRIPTION | NULLABLE | VARCHAR2(240) | A description of the approval.
PRODUCT_SCOPE_CODE | NOT NULL | VARCHAR2(30) | Defined by lookup type PRODUCT_SCOPE_TYPE, and is either "AI", "RI", or "ALL".
RESULT_VALIDATION_ID | NOT NULL | NUMBER | Defines the possible values for the workflow step
TIMEOUT_VALUE | NULLABLE | NUMBER | Number of time units, given in TIMEOUT_UNIT_CODE, for the approval to timeout.
TIMEOUT_UNIT_CODE | NULLABLE | VARCHAR2(30) | Unit of time for the Timeout of the approval. Can be "Minutes", "Hours", "Days", "Weeks", or "Weekdays". Defaults to "Days".
APPROVALS_REQUIRED_CODE | NOT NULL | VARCHAR2(30) | Defined by the lookup type APPROVALS_REQUIRED.
ICON_NAME | NULLABLE | VARCHAR2(80) | Name of the GIF or JPG file that resides in the "icons" directory on the server which will be used to display this approval in the layout of the workflow.
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Only enabled approvals can be used to create workflow steps
SOURCE_TYPE_CODE | NULLABLE | VARCHAR2(30) | For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on).
SOURCE | NULLABLE | VARCHAR2(100) | For records that have been updated by an interface or migrator, provides additional information about the source of the external update.
USER_DATA_SET_CONTEXT_ID | NULLABLE | NUMBER | Parameter set context identifier for the user data fields
USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
DEFINITION_LANGUAGE | NULLABLE | VARCHAR2(40) | Language in which this approval/decision was created
REFERENCE_CODE | NOT NULL | VARCHAR2(200) | Reference code. Equals to that of LOC table.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KWFL_APPROVALS_U1 | UNIQUE | 1 | APPROVAL_ID
KWFL_APPROVALS_U2 | UNIQUE | 1 | APPROVAL_NAME
SYS_C005199761 | UNIQUE | 1 | REFERENCE_CODE

## Sequences

Sequence Name | Sequence Type
--- | ---
KWFL_APPROVALS_S | APPROVAL_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: