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