Share this page
KWFL_WORKFLOWS
This table stores the header information for a workflow definition, such as workflow name, description, and associated product scope.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KWFL_WORKFLOWS_NLS |
WORKFLOW_ID |
DEFAULT_CHILD_PKG_WF_ID |
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KCRT_REQUEST_TYPES_NLS |
REQUEST_TYPE_ID |
DEFAULT_CHILD_REQ_RT_ID |
|
KWFL_WORKFLOW_STEPS_NLS |
WORKFLOW_STEP_ID |
FIRST_WORKFLOW_STEP_ID |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
KWFL_WORKFLOW_STEPS_NLS |
WORKFLOW_STEP_ID |
REOPEN_STEP_ID |
|
KNTA_VALIDATIONS_NLS |
VALIDATION_ID |
RESULT_VALIDATION_ID |
|
KNTA_PARAMETER_SET_CONTEXTS |
PARAMETER_SET_CONTEXT_ID |
USER_DATA_SET_CONTEXT_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
WORKFLOW_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 |
|
WORKFLOW_NAME |
NOT NULL |
VARCHAR2(150) |
Name of the workflow |
|
DESCRIPTION |
NULLABLE |
VARCHAR2(240) |
Description of the workflow |
|
PRODUCT_SCOPE_CODE |
NOT NULL |
VARCHAR2(30) |
Either 'AI' for Deployment Management, 'RI' for Demand Management or 'ALL' for all |
|
FIRST_WORKFLOW_STEP_ID |
NULLABLE |
NUMBER |
ID of the workflow step that will be enabled when the workflow is instantiated |
|
REOPEN_STEP_ID |
NULLABLE |
NUMBER |
ID of the workflow step that will be enabled when the workflow is reopened |
|
RESTRICT_OBJECTS_FLAG |
NULLABLE |
VARCHAR2(1) |
When set to 'Y', all new object types are restricted from this workflow |
|
FORCE_APP_CODE_FLAG |
NOT NULL |
VARCHAR2(1) |
If 'Y', Forces the user to select an app code for the object when adding a request line. |
|
RESTRICT_WORKFLOWS_FLAG |
NULLABLE |
VARCHAR2(1) |
When set to 'Y', all new workflows are restricted from this workflow |
|
ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
Only enabled workflows can be used for new issues or change requests |
|
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 1211 |
|
USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
|
VISIBLE_USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
|
SUB_WORKFLOW_FLAG |
NOT NULL |
VARCHAR2(1) |
This flag indicates if the workflow is a subworkflow. |
|
RESULT_VALIDATION_ID |
NULLABLE |
NUMBER |
In case of subworkflows, this validation will define the transitions coming out of the subworkflow step. |
|
ICON_NAME |
NULLABLE |
VARCHAR2(80) |
In case of subworkflows, the subworkflow step will be displayed with this icon. |
|
USE_IN_RELEASE_DIST_FLAG |
NOT NULL |
VARCHAR2(1) |
This column is applicable only for Package Workflows. A package sub-workflow can be included in a Distribution workflow only when this column is set to 'Y' (Yes). |
|
DEFAULT_CHILD_PKG_WF_ID |
NULLABLE |
NUMBER |
Identifier for the default package workflow for packages that are spawned by this workflow |
|
DEFAULT_CHILD_REQ_RT_ID |
NULLABLE |
NUMBER |
Identifier for the default request type for requests that are spawned by this workflow |
|
RESTRICT_CHILD_REQ_RTS_FLAG |
NULLABLE |
VARCHAR2(1) |
When set to 'Y', all new request types are restricted from this workflow |
|
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 steps of the workflow are available to be acted on in PPM for Mobile |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KWFL_WORKFLOWS_NLS_U3 |
NONUNIQUE |
1 |
WORKFLOW_ID |
|
KWFL_WORKFLOWS_NLS_U3 |
NONUNIQUE |
2 |
SUB_WORKFLOW_FLAG |
|
KWFL_WORKFLOWS_U1 |
UNIQUE |
1 |
WORKFLOW_ID |
|
KWFL_WORKFLOWS_U2 |
UNIQUE |
1 |
WORKFLOW_NAME |
|
SYS_C005199903 |
UNIQUE |
1 |
REFERENCE_CODE |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
KWFL_WORKFLOWS_S |
WORKFLOW_ID |
