SHIFT_PATTERN_MASS_RECALC_EMPIDS_SQL

This registry parameter defines the SQL statement used by the shift pattern mass recalculation to choose the employees that are affected by the fix.

Description:

This registry parameter specifies a SELECT statement that chooses employees using their employee identifiers (EMP_ID). Shift patterns are recalculated for the selected employees when the mass recalculation controlled by the SHIFT_PATTERN_MASS_RECALC_ON_OPEN registry parameter takes place.

For example, this SQL statement selects all employees that have shift records in the EMP_SCHD_DTL_LAYER table:

select distinct emp_id from EMP_SCHD_DTL_LAYER

Valid Values:

An SQL SELECT statement

Default Value:

blank

Location:

system/modules/scheduleOptimization

Effective:

6.1.6.2002, 6.2.1.3