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
WF_ITEM_ATTRIBUTES
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
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_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
No comments:
Post a Comment