> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Sign-Off process definition

> Schema reference for the PROCESSDEFINITION table in Atoti Sign-Off, with column names, types, and descriptions for sign-off process definition records.

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.                                                                                                                                                                                           |

<Note>
  * 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.
</Note>