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:
|
| Day To Check | Drop-down | Specifies the work date that the condition checks. Select Yesterday, Today, or Tomorrow. |
Example
If an employee's 'Emp_Status' is 'A' with a Emp_Shftpat_offset value of 1, then the expression "empShftPatOffSet>0","empStatus=A" is satisfied. The employee's status is active with a shift offset greater than 0.