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