Skip to main content

Celonis Product Documentation

Process Reference
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 and case tables. For example, they can be used to reference the corresponding case table for every activity table in the data model, or to reference standard activity table columns from a combined activity table generated with MERGE_EVENTLOG.

Process 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 returns a reference to the activity table corresponding to the provided activity table column. If no argument is provided, the default activity 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: