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).
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
This transformation requires a date or timestamp field in the adapter schema to offset.
This transformation adds a new string field populated with the calculated flag.
The time offset flag transformation requires the following by way of configuration:
The field containing the date or timestamp to offset.
The field to put the flag after transformation.
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.
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.
Customer support service by UserEcho