Exists Override Condition

The Exists Override Condition limits the execution of certain rules to situations in which specific overrides have been applied to a timesheet. For example, you can trigger the Unauthorize Rule any time a manager has manually applied a holiday override. The condition lets you identify timesheets on which a particular override has been applied.

Parameters In

Name Type Description Example
Override Types String The override types that the condition checks for. Defaults to all override types.
Note: The Override Types lookup gets its values from the VL_OVERRIDE_TYPE view. By default, this view contains all core overrides. If your implementation has one or more custom overrides, be sure to include them in this view. You can do this manually from the back-end (with sufficient database permissions) or from the front-end using the Table Localization feature. For details, see the Infor Workforce Management Internationalization Guide.
Employee Holiday
Range String The date range within which the condition checks for the specified override types. Defaults to the Day option. Today
Period String Used in conjunction with the Range parameter.

Determines whether the condition checks the present range (for example, today), the previous range (for example, yesterday), or the next range (for example, tomorrow). Defaults to This option.

This
Ignore Override End Date Boolean When this option is not selected (default), the condition checks to see if the override's start and end date both fall within the defined range.

When this option is selected, the condition only checks to see if the override start date falls within the range. For example, this can be helpful when you want to check if a permanent employee override started within the defined range.

Not selected
Eligible Users String Applies the condition to certain types of users. Can be filtered to apply:
  • All: All overrides are eligible. This is the default.
  • Role: Only check overrides applied by users who fulfill a role (or roles) on a team
  • Self: Only check overrides where a user has applied an override to their own timesheet.
All
User Type String Used in conjunction with the Eligible Users parameter; this parameter is required when the Role option is selected.

The roles for which the condition applies. If the Self or All options are selected in the Eligible Users parameter, this value is ignored.

Supervisor
New Value Token Name String Checks for a specific field within the override's "new value" data. HOL_NAME
New Value Token Values String The specific value to check for in association with the token name as specified in the New Value Token Name parameter. The list can have multiple values. The condition returns true if the new value name is set to any of these new values. CHRISTMAS, THANKSGIVING
Exact Match Boolean When this option is not selected, the condition performs a SQL LIKE pattern match. This is the default behavior.

When this option is selected, the condition returns true if the override value is an exact match to any of the values specified in the New Value Token Values parameter.

If the values being compared are numeric, then the condition formats the values to 2 decimal places before checking for an exact match. For example, if the override value is 15.0 and the value specified in the New Value Token Values parameter is 15, the condition will return true.

Not selected
Comment String A specific comment text to check for in the override comment field (OVR_COMMENT). The value is not case-sensitive. The parameter checks for %value% (instead of equals). Generated by MVS
Occurrences Integer The number of overrides to search for. Defaults to 1. 2
Operator String The operator to use in conjunction with the Occurrences parameter. Defaults to >=. >=

Example: Check for two holiday overrides in current pay period

Name Value
Override Types Employee Holiday
Range Period
Period This
Eligible Users All
User Type
New Value Token Name
New Value Token Values
Comment
Occurrences 2
Operator >=

Example: Check for holiday override by supervisor

Name Value
Override Types Employee Holiday
Range Today
Period This
Eligible Users Role
User Type Supervisor
New Value Token Name
New Value Token Values
Comment
Occurrences
Operator