workflow常用表

solaris: AMETEK_ERRORED_OEOL_WORKFLOW

/usr/dt/bin/dtwm &Wofkflow Tables List

W F_ITEM_TYPES:

T he WF_ITEM_TYPES table defines an item that is transitioning through a workflow process.

N AME (PK), PROTECT_LEVEL, CUSTOM_LEVEL, PERSISTENCE_TYPE

W F_ITEM_ATTRIBUTES:

T he 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.

I TEM_TYPE (PK), NAME (PK), SEQUENCE, TYPE, PROTECT_LEVEL, CUSTOM_LEVEL

W F_ACTIVITIES:

W F_ACTIVITIES table stores the definition of an activity. Activities can be processes, notifications, functions or folders.

I TEM_TYPE (PK), NAME (PK), VERSION (PK), TYPE, RERUN, EXPAND_ROLE, PROTECT_LEVEL, CUSTOM_LEVEL, BEGIN_DATE, ERROR_ITEM_TYPE, RUNNABLE_FLAG

W F_ACTIVITY_ATTRIBUTES:

T he 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.

A CTIVITY_ITEM_TYPE (PK), ACTIVITY_NAME (PK), ACTIVITY_VERSION (PK), NAME (PK), SEQUENCE, TYPE, VALUE_TYPE, PROTECT_LEVEL, CUSTOM_LEVEL

W F_MESSAGES:

W F_MESSAGES contains the definitions of messages which may be sent out as notifications.

T YPE (PK), NAME (PK), PROTECT_LEVEL, CUSTOM_LEVEL

W F_MESSAGE_ATTRIBUTES:

W F_MESSAGE_ATTRIBUTES contains message attribute definitions.

W F_NOTIFICATIONS:

W F_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.

W F_NOTIFICATION_ATTRIBUTES:

W F_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

d efinition. Initially, th

e values o

f the notification attributes are set to the default values specified in the message attribute definition.

WF_ITEMS:

W F_ITEMS is the runtime table for workflow processes. Each row defines one work item within the system.

I TEM_TYPE (PK), ITEM_KEY (PK), ROOT_ACTIVITY, ROOT_ACTIVITY_VERSION, BEGIN_DATE

W F_ITEM_ACTIVITY_STATUSES:

T he 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.

I TEM_TYPE (PK), ITEM_KEY (PK), PROCESS_ACTIVITY (PK)

W F_ITEM_ACTIVITY_STATUSES_H:

T he WF_ITEM_ACTIVITY_STATUSES_H table stores the history of the WF_ITEM_ACTIVITY_STATUSES table.

I TEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY

W F_PROCESS_ACTIVITIES:

W F_PROCESS_ACTIVITIES stores the data for an activity within a specific process.

P ROCESS_ITEM_TYPE, PROCESS_NAME, PROCESS_VERSION, ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, INSTANCE_ID (PK), INSTANCE_LABEL, PERFORM_ROLE_TYPE, PROTECT_LEVEL, CUSTOM_LEVEL

W F_ACTIVITY_TRANSITIONS:

T he 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

p hysical location of the transition in the process window.

F ROM_PROCESS_ACTIVITY (PK), RESULT_CODE (PK), TO_PROCESS_ACTIVITY (PK),

PROTECT_LEVEL,CUSTOM_LEVEL

W F_ACTIVITY_ATTR_VALUES:

T he 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.

P ROCESS_ACTIVITY_ID (PK), NAME (PK), VALUE_TYPE, PROTECT_LEVEL,

C USTOM_LEVEL