XM_DOCUMENT_ACTIVITY

Entity Name XM_DOCUMENT_ACTIVITY
Entity Type Independent
Definition This table identifies all possible workflow activities in the application. An activity represents a state where an action can be performed on a document. Valid activities vary by customer, but all the valid activities include a create activity. The create activity can be used to describe the activity that a document is in. You can apply filters to display documents in an activity only.

Attributes

Attribute Datatype Width Definition
ACTIVITY_ID Integer 7 The primary key identifying this activity.
ACTIVITY_NUMBER Integer 3 The activity number for this activity. These are the valid values for the activity number INTEGER Y:
  • 10 (create)
  • 20 (manager review)
  • 25 (executive review)
  • 30 (accounting review)
  • 35 (charge code manager review)
  • 40 (payroll)
  • 50 (archive)
  • 60 (destroy)
  • 70 (import create)
  • 998 (routing)
  • 999 (miscellaneous)
ACTIVITY_VIEW Varchar 24
CHANGE_TIMESTAMP DateTime 23
DESCRIPTION Varchar 57 A description of the activity.
DISPLAY_NAME Varchar 33 A human readable name for this activity.
INTERNAL_NAME Varchar 29
lastModified DateTime 24
VariationID Integer 13
ACTIVE_STATUS Varchar 4