Oracle Workflow – Tables Description and usage

WF_ITEM_TYPES

The WF_ITEM_TYPES table defines an item that is transitioning through a
workflow process. NAME (PK), PROTECT_LEVEL, CUSTOM_LEVEL,
PERSISTENCE_TYPE

select display_name from wf_item_types_vl where name='HXCEMP';


WF_ITEM_ATTRIBUTES

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. ITEM_TYPE (PK), NAME (PK),
SEQUENCE, TYPE, PROTECT_LEVEL, CUSTOM_LEVEL



WF_ACTIVITIES

WF_ACTIVITIES table stores the definition of an activity. Activities can be
processes, notifications, functions or folders.ITEM_TYPE (PK), NAME (PK), VERSION(PK), TYPE, RERUN, EXPAND_ROLE, PROTECT_LEVEL,
CUSTOM_LEVEL, BEGIN_DATE, RROR_ITEM_TYPE, RUNNABLE_FLAG



WF_ACTIVITY_ATTRIBUTES
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.
ACTIVITY_ITEM_TYPE (PK), ACTIVITY_NAME (PK),
ACTIVITY_VERSION (PK), NAME (PK), SEQUENCE, TYPE, VALUE_TYPE,
PROTECT_LEVEL, CUSTOM_LEVEL


WF_MESSAGES
WF_MESSAGES contains the definitions of messages which may be sent out as
notifications. TYPE (PK), NAME (PK), PROTECT_LEVEL, CUSTOM_LEVEL

WF_MESSAGE_ATTRIBUTES
WF_MESSAGE_ATTRIBUTES contains message attribute definitions.

WF_NOTIFICATIONS

WF_NOTIFICATIONS holds the runtime information about a specific instance
of a sent message. A new row is created in the table each time a message is sent.


WF_NOTIFICATION_ATTRIBUTES

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

WF_ITEMS is the runtime table for workflow processes. Each row defines one
work item within the system. ITEM_TYPE (PK), ITEM_KEY (PK),
ROOT_ACTIVITY, ROOT_ACTIVITY_VERSION, BEGIN_DATE


WF_ITEM_ACTIVITY_STATUSES

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. ITEM_TYPE (PK), ITEM_KEY (PK),
PROCESS_ACTIVITY (PK)


WF_ITEM_ACTIVITY_STATUSES_H

The WF_ITEM_ACTIVITY_STATUSES_H table stores the history of the
WF_ITEM_ACTIVITY_STATUSES table. ITEM_TYPE, ITEM_KEY,
PROCESS_ACTIVITY

WF_PROCESS_ACTIVITIES

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


WF_ACTIVITY_TRANSITIONS

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. FROM_PROCESS_ACTIVITY (PK),
RESULT_CODE (PK), TO_PROCESS_ACTIVITY (PK),
PROTECT_LEVEL,CUSTOM_LEVEL

WF_ACTIVITY_ATTR_VALUES

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. PROCESS_ACTIVITY_ID (PK), NAME (PK), VALUE_TYPE,
PROTECT_LEVEL, CUSTOM_LEVEL