Time Offset Flag Transformation

Overview

This transformation adds a new field which contains a calculated offset flag based on a provided source field.

This offset flag describes whether the source time is greater than, less than or equal to the current executing service time (or null).

Use Cases

The time offset flag transformation can be used to accomplish the following:

  • Setting a new field for use in processing where the time of day is significant, such as HR processing or advanced workflows

Prerequisites

This transformation requires a date or timestamp field in the adapter schema to offset.

Contribution

This transformation adds a new string field populated with the calculated flag.


Configuration

The time offset flag transformation requires the following by way of configuration:


Attribute

Description

Offset Field

The field containing the date or timestamp to offset.

Destination Field

The field to put the flag after transformation.

Time Offset

The value to offset the source value from. If this is a date, it is offset from midnight of the start of that day.

Equal Flag Value

Flag value to set if the current process date is equal to the source column. Defaults to null.

Greater Flag Value

Flag value to set if the current process date is greater than the source column. Defaults to null.

Lesser Flag Value

Flag value to set if the current process date is lesser than the source column. Defaults to null.

Null Flag Value

Flag value to set if the source column is null. Defaults to null.

The above configuration takes a field TerminationDate and flags a new field Terminated with a True or False value if the time has been reached, signifying further processing may need to take place.

Change Processing

During the change detection process, a change will be flagged for an entity if the Offset Field has been updated. Changes will also occur for entities based on their Offset Field, such that their flag will update automatically.

Is this article helpful for you?