Worked N Minutes Condition
com.workbrain.app.ta.conditions.WorkedNMinutes
The Worked N Minutes Condition determines whether the employee has worked N minutes within a given time code, hour type, and expression constraint for the current work date.
For example, you can use this condition to determine if an employee has worked 240 minutes with the time code WRK, the hour type not UNPAID, and the department DEPTA for the current work date. This condition queries the employee’s schedule to determine whether the employee has worked a specified number of minutes, within a given time code, hour type, and expression constraint for the current work date.
Parameters In
| Name | Type | Description | Example |
|---|---|---|---|
| WorkMinutes | Integer | The number of minutes to check for. | 480 |
| TcodeNameList | String | The list of time codes that is used to calculate worked
minutes.
If a value is not supplied, all time codes are used. |
WRK |
| TcodeInclusive | String | Format: TRUE/FALSE (default is TRUE)
If TRUE, the time code-name list (TcodeNameList) is inclusive. If FALSE, the time code-name list is not inclusive. |
TRUE |
| HtypeNameList | String | The list of hour types that is used to calculate worked
minutes.
If a value is not supplied, all hour types are used. |
UNPAID |
| HtypeInclusive | String | Format: TRUE/FALSE (default is TRUE)
If TRUE, the hour type name list (HtypeNameList) is inclusive. If FALSE, the hour type name list is not inclusive. |
FALSE |
| ExpressionString | String | Specify a comma-delimited, quote-enclosed string of
employee table fields. The string is case-sensitive. Specify column names in lower case, except for the first letter to the right of the underscore. Also, remove the underscores from the column name. For the column emp_status, specify empStatus. Dates must be supplied in SQL_TIMESTAMP_FORMAT, which are yyyy-MM-dd, yyyy-MM-dd HH:mm:ss, HH:mm:ss, and yyyy-MM-dd HH:mm. For values that are supplied in HH:mm:ss format, date comparison is made based on day fraction minutes. Supported operators are =, !=, <>, <, <=, >, >=, [CONTAINS], [IN](item1;item2;item3), [NOT_IN](item1;item2;item3), [IS_EMPTY], and [IS_NOT_EMPTY]. For [IS_EMPTY] and [IS_NOT_EMPTY], the second operand is not required and is ignored. Supported data types are Number, date, and string. The condition returns FALSE if the expression string is not formatted properly, the attributes do not exist, or the types are not compatible. |
"wrkdDeptName=DEPTA", " wrkdJobName <> JOBA" |
| DetailPremium | String | Whether Details (D) or Premiums (P) or all will be considered in summation (no value). | D |
| StartDayOfTheWeek | String | If supplied, sums the minutes since the start day of the week that is supplied. | Mon |
| Operator | String | Compares the specified value with the total worked minutes as calculated by the condition configuration values. | > (greater than)
>= (equal or greater than) = (equal to) <> (not equal to) <= (less than or equal < (less than) |
Example
In this condition, an employee must work 500 minutes with the time code WRK (time code is inclusive) and the hour type UAT (hour type is not inclusive). Also, the employee must work in department A, with job A.
| Name | Value |
|---|---|
| WorkMinutes | 500 |
| TcodeNameList | WRK |
| TcodeInclusive | TRUE |
| HtypeNameList | UAT |
| HtypeInclusive | FALSE |
| ExpressionString | "wrkdDeptName= DEPTA", "wrkdJobName= JOBA" |