Sign-Off process definition

Table name: PROCESSDEFINITION

Column	Key	Type	Description
ID		long	The database ID for version.
LIVEFROM		timestamp	The beginning of live range for the object version.
LIVETO		timestamp	The End of the live range for the object version (null if the range has no end).
VALIDFROM	Y	date	Beginning date (inclusive) for which this definition object applies.
VALIDTO		date	Ending date (exclusive) for which this definition object applies (may be null).
NAME	Y	string	The name of the sign-off process.
CATEGORY		string
DESCRIPTION		string	A freeform description of the sign-off process.
DOMAIN		string
FILTERS		list of string	The list of filters that specify the data being signed-off, separated by a semi-column. Each filter has the format hierarchy@dimension\|operator\|member in level 1\|member in level 2\|…\|member in level N. Example: BookHierarchy@Organization\|EQUALS\|Global Markets\|Equities\|Cash Equities;Desks@Booking\|EQUALS\|Equities*
KPIS		list of string
WORKFLOWPROPERTIES		list of string	The list of configuration properties that can be used in the workflow process. These are available as variables to the process definition. Each property has the format name:value.
WORKFLOWTYPE		string	The alias for the Activiti workflow process definition that is used to manage the sign-off process.
SERVERNAME		string	The name of the application server to which the process definition is related. Used to generate the URLs for calls to RESTful services in the application server.

All lists are delimited by semicolons.
The sign-off process definitions are “bi-temporal”: they have two time dimensions. The “live range” determines which version of the object is live. The “valid range” describes which as-of date the definition applies to. When creating sign-off process instances, the as-of date for the process instance must lie inside the valid range of the process definition.

⌘I