| Previous | Next |  | Contents | Index | Glossary

## WF_ITEM_ACTIVITY_STATUSES_V

This view contains denormalized information about a workflow process and its activities' statuses. Use this view to create custom queries and reports on the status of a particular item or process. The column descriptions of the view are as follows:

     Name                            Null?    Type

     ------------------------------- -------- ----

     ROW_ID                                   ROWID

     SOURCE                                   CHAR(1)

     ITEM_TYPE                                VARCHAR2(8)

     ITEM_TYPE_DISPLAY_NAME                   VARCHAR2(80)

     ITEM_TYPE_DESCRIPTION                    VARCHAR2(240)

     ITEM_KEY                                 VARCHAR2(240)

     USER_KEY                                 VARCHAR2(240)

     ITEM_BEGIN_DATE                          DATE

     ITEM_END_DATE                            DATE

     ACTIVITY_ID                              NUMBER

     ACTIVITY_LABEL                           VARCHAR2(30)

     ACTIVITY_NAME                            VARCHAR2(30)

     ACTIVITY_DISPLAY_NAME                    VARCHAR2(80)

     ACTIVITY_DESCRIPTION                     VARCHAR2(240)

     ACTIVITY_TYPE_CODE                       VARCHAR2(8)

     ACTIVITY_TYPE_DISPLAY_NAME               VARCHAR2(80)

     EXECUTION_TIME                           NUMBER

     ACTIVITY_BEGIN_DATE                      DATE

     ACTIVITY_END_DATE                        DATE

     ACTIVITY_STATUS_CODE                     VARCHAR2(8)

     ACTIVITY_STATUS_DISPLAY_NAME             VARCHAR2(80)

     ACTIVITY_RESULT_CODE                     VARCHAR2(30)

     ACTIVITY_RESULT_DISPLAY_NAME             VARCHAR2(4000)

     ASSIGNED_USER                            VARCHAR2(30)

     ASSIGNED_USER_DISPLAY_NAME               VARCHAR2(4000)

     NOTIFICATION_ID                          NUMBER

     OUTBOUND_QUEUE_ID                        RAW(16)

     ERROR_NAME                               VARCHAR2(30)

     ERROR_MESSAGE                            VARCHAR2(2000)

     ERROR_STACK                              VARCHAR2(4000)

| Previous | Next |  | Contents | Index | Glossary