END_TIMESTAMP_COLUMN
Description
END_TIMESTAMP_COLUMN allows to refer the end timestamp column of an activity table in the data model without using the exact column name. If no end timestamp column is defined for the target activity table, the timestamp column is referenced.
Syntax
END_TIMESTAMP_COLUMN ( [ expression ] )
When an expression that involves a column of an activity table is passed as an argument, the end timestamp column of that activity table is referenced.
When no argument is passed, the end timestamp column of the default activity table is referenced.
When a table reference is passed as an argument, the end timestamp column of that activity table is referenced.
Examples
[1] In this example, the data model contains one activity table where an end timestamp column is specified. Using a column reference as the input expression, we refer to the END_TIMESTAMP column of the related activity table: | ||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
|
[2] In this example, the data model contains one activity table without an end timestamp column. In this scenario | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|
[3] In this example, the data model contains one activity table where an end timestamp column is specified. By passing no arguments to the | ||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
|
[4] In this example, the data model contains one activity table where an end timestamp column is specified. Using a table reference as the input expression, we refer to the END_TIMESTAMP column of the related activity table: | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|