Is Employee Property Generic Condition

com.workbrain.app.ta.conditions.IsEmployeePropertyGenericCondition

The Is Employee Property Generic Condition is used to query the employee data as of the specified work date. The criteria are provided in an expression string parameter using employee fields in a comma-delimited, quote-enclosed string.

For example, to determine if an employee is in the calculation group UNION1, has an active status, and was hired prior to January 1, 1980, use this expression string parameter:

"empCalcgrpName=UNION1","empStatus=A","empHireDate<1980-01-01 00:00:00"

Other examples for using this condition could be to determine:

  • If an employee’s pay group name is PAYGRPTEST as of a specific date
  • If an employee hired before 1980-01-01 has a status that is not active as of this work date
  • If an employee is 18 as of the calculation date ("empAge>=18”)

Parameters In

Name Type Description Example
Expression String String A comma-delimited, quote-enclosed string of fields of a table, where each condition is ANDed.

Fields of tables are referenced by taking underscore (_) from field names and capitalizing what comes after the underscores. For example, emp_flag1 =>empFlag1.

Supported operators are =, !=, <>, <, <=, >, >=, [CONTAINS], [IN](item1;item2;item3), [NOT_IN](item1;item2;item3), [IS_EMPTY], and [IS_NOT_EMPTY].

For the work summary table, an expression could be:

"empFlag1=Y","empVal1!=XX"

This expression is true if these conditions are met:

  • emp_flag1 = Y AND emp_VAL1 <> XX
  • "empVal20[IN](green;brown)"
  • "empAge<18"
Day To Check Drop-down Specifies the work date that the condition checks. Select Yesterday, Today, or Tomorrow.