RPT_DIM_WORKFLOW_STEPS

This is a materialized view on top of KWFL_WORKFLOW_STEPS_NLS and KWFL_WORKFLOWS_NLS tables, representing the relationship between enabled workflow steps and workflows that theses steps belong to.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

STEP_ID NOT NULL NUMBER ID of the workflow step
STEP_NAME NOT NULL VARCHAR2(80) Name of the workflow step
WORKFLOW_NAME NOT NULL VARCHAR2(150) Name of the workflow the workflow step belongs to

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_DIM_WORKFLOW_STEPS_N11

NONUNIQUE

1

STEP_ID

RPT_DIM_WORKFLOW_STEPS_N12

NONUNIQUE

1

STEP_NAME

Sequences

This table uses no sequences.