Process reference
Applies to: CELONIS 4.7
Description
Process reference functions can be used to reference the case table or configured activity columns based on an expression.
These operators are useful when working with data models with multiple activity/case tables.
Case table reference
CASE_TABLE returns a reference to the case table corresponding to the provided activity table column. If no argument is provided, the default case table is referenced.
Activity table column reference
Those functions allow to refer to the essential columns of activity tables in the data model without using the exact activity table or column names. If an activity table column is passed as an argument, the respective column of the corresponding activity table is referenced. If no argument is provided, the respective column of the default activity table is referenced. We provide the following functions for each of the essential activity table columns:
ACTIVITY_COLUMN returns a reference to the activity column
CASE_ID_COLUMN returns a reference to the case column
END_TIMESTAMP_COLUMN returns a reference to the end timestamp column
TIMESTAMP_COLUMN returns a reference to the timestamp column