Share this page

# KENV_GROUP_EXEC_RESULTS

This table stores the destination environments where the environment group execution has successfully migrated to. This information will be used by the next run of the same workflow step to determine if we need to migrate to all the environments in the destination environment group or just part of it.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KENV_ENVIRONMENTS | ENVIRONMENT_ID | SOURCE_ID
KWFL_STEP_TRANSACTIONS | STEP_TRANSACTION_ID | STEP_TRANSACTION_ID
KENV_ENVIRONMENTS | ENVIRONMENT_ID | SUCCEEDED_DEST_ENV_ID
KWFL_WORKFLOWS_NLS | WORKFLOW_STEP_ID | WORKFLOW_STEP_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
GROUP_EXEC_RESULT_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
SOURCE_TABLE | NOT NULL | VARCHAR2(30) | Name of the table that stores the entity initiating this environment group execution (for example, KDLV_PACKAGE_LINES, KCRT_REQUESTS, KREL_DIST_LINE_INSTANCES)
SOURCE_ID | NOT NULL | NUMBER | Primary key value in the SOURCE_TABLE (for example, the value for a PACKAGE_LINE_ID, REQUEST_ID, or DIST_LINE_INSTANCE_ID)
WORKFLOW_STEP_ID | NOT NULL | NUMBER | ID of the workflow step initiating this environment group execution.
STEP_TRANSACTION_ID | NOT NULL | NUMBER | ID of the workflow step transaction for this environment group execution.
SUCCEEDED_DEST_ENV_ID | NOT NULL | NUMBER | ID of an environment in the destination environment group to which the object has been successfully migrated.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KENV_GROUP_EXEC_RESULTS_U1 | UNIQUE | 1 | GROUP_EXEC_RESULT_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KENV_GROUP_EXEC_RESULTS_S | GROUP_EXEC_RESULT_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: