Share this page
KWFL_WORKFLOW_STEPS
Each row contains the definition of a workflow step, which is represented by a workflow step figure in the workflow builder screen. A workflow step is based on a decision, condition, or execution. The source and destination environments may be defined for a step, which are in general used to define where from and to objects are migrated. When the workflow step becomes enabled, it may change the assigned user or group of an Request (for Demand Management) or for a Package (for Deployment Management).
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KENV_ENVIRONMENTS |
ENVIRONMENT_ID |
DEST_ENVIRONMENT_ID |
|
KENV_ENV_GROUPS |
ENV_GROUP_ID |
DEST_ENV_GROUP_ID |
|
KWFL_WORKFLOWS_NLS |
WORKFLOW_ID |
DEFAULT_CHILD_PKG_WF_ID |
|
KWFL_WORKFLOWS_NLS |
WORKFLOW_ID |
STEP_SOURCE_ID |
|
KENV_ENV_GROUPS |
ENV_GROUP_ID |
SOURCE_ENV_GROUP_ID |
|
KNTA_REF_RELATIONSHIPS_NLS |
REF_RELATIONSHIP_ID |
REF_RELATIONSHIP_ID |
|
KCRT_REQUEST_TYPES_NLS |
REQUEST_TYPE_ID |
DEFAULT_CHILD_REQ_RT_ID |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
KWFL_VERIFICATION_TEMP |
WORKFLOW_ID |
WORKFLOW_ID |
|
KWFL_CONDITIONS |
CONDITION_ID |
STEP_SOURCE_ID |
|
KWFL_WORKFLOWS_NLS |
WORKFLOW_ID |
WORKFLOW_ID |
|
KNTA_PARAMETER_SET_CONTEXTS |
PARAMETER_SET_CONTEXT_ID |
USER_DATA_SET_CONTEXT_ID |
|
KWFL_EXECUTIONS_NLS |
EXECUTION_ID |
STEP_SOURCE_ID |
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KWFL_WORKFLOW_PARAMETERS_NLS |
WORKFLOW_PARAMETER_ID |
RESULT_WORKFLOW_PARAMETER_ID |
|
KWFL_APPROVALS_NLS |
APPROVAL_ID |
STEP_SOURCE_ID |
|
KNTA_USERS |
USER_ID |
PARENT_ASSIGNED_TO_USER_ID |
|
KENV_ENVIRONMENTS |
ENVIRONMENT_ID |
SOURCE_ENVIRONMENT_ID |
|
KNTA_SECURITY_GROUPS_NLS |
SECURITY_GROUP_ID |
PARENT_ASSIGNED_TO_GROUP_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
WORKFLOW_STEP_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 |
|
WORKFLOW_ID |
NOT NULL |
NUMBER |
Workflow ID of the containing workflow |
|
STEP_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
Defined by lookup STEP_TYPE ('APPROVAL', 'CONDITION', 'EXECUTION', or 'WORKFLOW') |
|
STEP_SOURCE_ID |
NULLABLE |
NUMBER |
ID of the approval, condition, execution, or workflow. |
|
RESULT_WORKFLOW_PARAMETER_ID |
NULLABLE |
NUMBER |
ID of the workflow parameter where the result is stored into |
|
PRODUCT_SCOPE_CODE |
NOT NULL |
VARCHAR2(30) |
Defined by lookup PRODUCT_SCOPE_TYPE |
|
PARENT_ASSIGNED_TO_USER_ID |
NULLABLE |
NUMBER |
When set, sets the assigned-to user for a request or package when this step becomes eligible |
|
PARENT_ASSIGNED_TO_GROUP_ID |
NULLABLE |
NUMBER |
When set, sets the assigned-to group for a request or package when this step becomes eligible |
|
PARENT_STATUS |
NULLABLE |
VARCHAR2(30) |
When set, sets the status of a request or package when this step becomes eligible |
|
SOURCE_ENVIRONMENT_ID |
NULLABLE |
NUMBER |
Defines the source environment, only used for executions |
|
SOURCE_ENV_GROUP_ID |
NULLABLE |
NUMBER |
Defines the source environment group, only used for executions |
|
DEST_ENVIRONMENT_ID |
NULLABLE |
NUMBER |
Defines the destination environment, only used for executions |
|
DEST_ENV_GROUP_ID |
NULLABLE |
NUMBER |
Defines the destination environment group, only used for executions |
|
OM_ARCHIVE_FLAG |
NULLABLE |
VARCHAR2(1) |
When 'Y' and the migrated object is an AOL object type, Object*Migrator will archive the object |
|
AVERAGE_LEAD_TIME |
NULLABLE |
NUMBER |
In days. Purely informational |
|
STEP_NAME |
NOT NULL |
VARCHAR2(80) |
By default the same name as the name of the step source, but user can override it to something else. |
|
JUMP_RECEIVE_LABEL_CODE |
NULLABLE |
VARCHAR2(30) |
Defines the label for the jump and receive steps. Jump/Receive can be performed if the steps have same label. |
|
DESCRIPTION |
NULLABLE |
VARCHAR2(240) |
Description of the workflow |
|
INFORMATION_URL |
NULLABLE |
VARCHAR2(200) |
Defines the URL where the 'hint' can be found for a step. When selected, the hint is displayed in the status tabs for relevant entities. |
|
REQUEST_TYPE_LIST |
NULLABLE |
VARCHAR2(200) |
Defines the list of request types that can be used to create a request using the 'Create_Request' execution command. If left blank, all the request types will be available to create a request. |
|
ACTION_BUTTON_LABEL |
NULLABLE |
VARCHAR2(80) |
When set, this text is used on the Action button on the Package, Request status panel. When blank the step name is used for the label. |
|
SORT_ORDER |
NOT NULL |
NUMBER |
Each step can have a unique sort order between 1 and the total number of workflow steps for one workflow. This determines the display sequence on Package, request status tabs. |
|
ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
Only enabled workflow steps can have incoming transitions. |
|
DISPLAY_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
Determines whether the step will be displayed always, never or on active only. |
|
DRAW_CENTER_POS |
NULLABLE |
VARCHAR2(30) |
X and Y coordinates of the workflow step icon when drawn by the workflow builder |
|
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 |
Constant 1212 |
|
USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
|
VISIBLE_USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
|
PERCENT_COMPLETE |
NULLABLE |
NUMBER |
When set, sets the percent complete of a request to this value when this step becomes eligible |
|
RELEASE_IS_REQUIRED_FLAG |
NOT NULL |
VARCHAR2(1) |
When set to 'Y' a valid release should be entered while taking action on this step. |
|
STEP_TIMEOUT_TYPE |
NULLABLE |
VARCHAR2(50) |
Timeout type. Could be a constant or token. |
|
STEP_TIMEOUT_VALUE |
NULLABLE |
VARCHAR2(200) |
Numeric value for timeout |
|
STEP_TIMEOUT_UNIT_CODE |
NULLABLE |
VARCHAR2(30) |
Time out units. Could be minutes, hours, days, and so on |
|
USE_SOURCE_TIMEOUT_FLAG |
NOT NULL |
VARCHAR2(1) |
When this column is set to 'Y' the timeout properties of the step source is used. |
|
ALLOWED_CHILD_PKG_WF_LIST |
NULLABLE |
VARCHAR2(200) |
A KNTA_MULTI.Multi_Delimiter separated list of package workflow identifiers that are allowed to be chosen for packages spawned by this workflow step |
|
DEFAULT_CHILD_PKG_WF_ID |
NULLABLE |
NUMBER |
Identifier for default package workflow to be chosen for packages spawned by this workflow step |
|
DEFAULT_CHILD_REQ_RT_ID |
NULLABLE |
NUMBER |
Identifier for default request type to be chosen for requests spawned by this workflow step |
|
REF_RELATIONSHIP_ID |
NULLABLE |
NUMBER |
Identifier for the referenced relationship for the newly spawned entity |
|
STEP_AUTH_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
Indicate the type of authorization is required for this creation step |
|
NORMAL_BACKGROUND_COLOR |
NULLABLE |
VARCHAR2(20) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
ASSIGNED_TO_USER_TOKEN |
NULLABLE |
VARCHAR2(500) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
ASSIGNED_TO_GROUP_TOKEN |
NULLABLE |
VARCHAR2(500) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
DEFINITION_LANGUAGE |
NOT NULL |
VARCHAR2(40) |
Definition language |
|
REFERENCE_CODE |
NOT NULL |
VARCHAR2(200) |
Reference code |
| USE_IN_MOBILE_FLAG | NOT NULL | VARCHAR2(1) | Whether or not the workflow step is available to be acted on in PPM for Mobile |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KWFL_WORKFLOW_STEPS_N1 |
NONUNIQUE |
1 |
WORKFLOW_ID |
|
KWFL_WORKFLOW_STEPS_N1 |
NONUNIQUE |
2 |
SORT_ORDER |
|
KWFL_WORKFLOW_STEPS_N2 |
NONUNIQUE |
1 |
STEP_SOURCE_ID |
|
KWFL_WORKFLOW_STEPS_N2 |
NONUNIQUE |
2 |
STEP_TYPE_CODE |
|
KWFL_WORKFLOW_STEPS_NLS_N3 |
NONUNIQUE |
1 |
WORKFLOW_ID |
|
KWFL_WORKFLOW_STEPS_NLS_N3 |
NONUNIQUE |
2 |
ENABLED_FLAG |
|
KWFL_WORKFLOW_STEPS_NLS_N3 |
NONUNIQUE |
3 |
WORKFLOW_STEP_ID |
|
KWFL_WORKFLOW_STEPS_NLS_U2 |
NONUNIQUE |
1 |
WORKFLOW_STEP_ID |
|
KWFL_WORKFLOW_STEPS_NLS_U2 |
NONUNIQUE |
2 |
ENABLED_FLAG |
|
KWFL_WORKFLOW_STEPS_U1 |
UNIQUE |
1 |
WORKFLOW_STEP_ID |
|
SYS_C005199976 |
UNIQUE |
1 |
REFERENCE_CODE |
Sequences
This table does not use any Sequences.
