Oracle Work Flow Table Information
Following are the most frequently used tables in Oracle WorkFlow
The WF_ITEM_TYPES table defines an item that is transitioning through a workflow process.
Important Columns:
NAME (PK),
PROTECT_LEVEL,
CUSTOM_LEVEL,
PERSISTENCE_TYPE
The WF_ITEM_ATTRIBUTES table stores definitions of attributes
associated with a process. Each row includes the sequence in which the
attribute is used as well as the format of the attribute data.
Important Columns:
ITEM_TYPE (PK),
NAME (PK),
SEQUENCE,
TYPE,
PROTECT_LEVEL,
CUSTOM_LEVEL
WF_ACTIVITIES table stores the definition of an activity. Activities can be processes, notifications, functions or folders.
Important Columns:
ITEM_TYPE (PK),
NAME (PK),
VERSION(PK),
TYPE, RERUN,
EXPAND_ROLE,
PROTECT_LEVEL,
CUSTOM_LEVEL,
BEGIN_DATE,
RROR_ITEM_TYPE,
RUNNABLE_FLAG
The WF_ACTIVITY_ATTRIBUTES table defines attributes which behave as
parameters for an activity. Activity attributes are only used by
function activities.Examples of valid attribute types are DATE,
DOCUMENT, FORM, ITEMATTR, LOOKUP, and VARCHAR2.
Important Columns:
ACTIVITY_ITEM_TYPE (PK),
ACTIVITY_NAME (PK),
ACTIVITY_VERSION (PK),
NAME (PK),
SEQUENCE,
TYPE,
VALUE_TYPE,
PROTECT_LEVEL,
CUSTOM_LEVEL
WF_MESSAGES contains the definitions of messages which may be sent out as notifications.
Important Columns:
TYPE (PK),
NAME (PK),
PROTECT_LEVEL,
CUSTOM_LEVEL
WF_NOTIFICATION_ATTRIBUTES
holds rows created for attributes of a notification. When each new
notification is created, a notification attribute row is created for
each message attribute in the message definition. Initially, the values
of the notification attributes are set to the default values specified
in the message attribute definition.
WF_ITEMS is the run time table for workflow processes. Each row defines one work item within the system.
Important Columns:
ITEM_TYPE (PK),
ITEM_KEY (PK),
ROOT_ACTIVITY,
ROOT_ACTIVITY_VERSION,
BEGIN_DATE
The WF_ITEM_ACTIVITY_STATUSES TABLE is the runtime table for a work
item. Each row includes the start and end date, result code, and any
error information an activity generates.
Important Columns:
ITEM_TYPE (PK),
ITEM_KEY (PK),
PROCESS_ACTIVITY (PK)
The WF_ITEM_ACTIVITY_STATUSES_H table stores the history of the WF_ITEM_ACTIVITY_STATUSES table.
Important Columns:
ITEM_TYPE,
ITEM_KEY,
PROCESS_ACTIVITY
WF_PROCESS_ACTIVITIES stores the data for an activity within a specific process.
PROCESS_ITEM_TYPE,
PROCESS_NAME,
PROCESS_VERSION,
ACTIVITY_ITEM_TYPE,
ACTIVITY_NAME,
INSTANCE_ID (PK),
INSTANCE_LABEL,
PERFORM_ROLE_TYPE,
PROTECT_LEVEL,
CUSTOM_LEVEL
The WF_ACTIVITY_TRANSITIONS table defines the transitions from one
activity to another in a process. Each row includes the activities at
the beginning and end of the transition, as well as the result code and
physical location of the transition in the process window.
Important Columns:
FROM_PROCESS_ACTIVITY (PK),
RESULT_CODE (PK),
TO_PROCESS_ACTIVITY (PK),
PROTECT_LEVEL,
CUSTOM_LEVEL
The WF_ACTIVITY_ATTR_VALUES table contains the data for the activity
attributes. Each row includes the process activity id and the associated
value for the attribute.
Important Columns:
PROCESS_ACTIVITY_ID (PK),
NAME (PK),
VALUE_TYPE,
PROTECT_LEVEL,
CUSTOM_LEVEL
No comments:
Post a Comment