Is Operative Transformation

Overview

This transformation adds a new is operative flag field to the adapter schema, with a value of the calculated flag.

The added field indicates if the current time is between two date or time-stamp fields. If these are timestamps, then the current time must be exactly between these timestamps. If the fields are dates, then the current time must be after the start of the day of the start time, and before the end of the day for the end time.

Use Cases

The is operative transformation can be used to accomplish the following:

  • Flagging whether or not an employee is currently active with the company based on their position information
  • Noting if an employee is currently on leave or exercising another time based entitlement
  • Specifying if a user is currently within their active working hours for the day

Prerequisites

This transformation requires at least one date or time-stamp field.

Contribution

This transformation adds a new string field containing the calculated is operative flag.

Configuration

The is operative transformation requires the following by way of configuration:


Attribute Description
Target The attribute to contain the flag after generation.
Start The date/timestamp attribute which is the start of the operative period.
End The date/timestamp attribute which is the end of the operative period.
Operative Flag Value Value to place in the Target attribute if the processing date is between the Start and End attributes
Not Operative Flag Value Value to place in the Target attribute if the processing date is not between the Start and End attributes
Local Specifies whether to use local time instead of UTC when comparing the current time with the start/end dates For instance, in Brisbane, Australia, this would result in a time-stamp of of 10 hours later.
Inclusive Whether to include the end date in the calculation.
Null End Valid Specifies whether a end date of null is valid when comparing. If checked, all values past the start date will be considered operative.

The above configuration sets a basic field named IsOperative which will be set to Active if the employee is currently employed based on their PositionStartDate and TerminationDate (or if they have not had an TerminationDate set), and Inactive if not.

Change Processing

During the change detection process, a change will be flagged if the current time falls in the specified operative range.

Is this article helpful for you?