Installing Recalculate Task components

Some of the Recalculate Task parameters require additional triggers and indices. These triggers and indices will create some processing overhead, but are required if you want the related features:

  • Business rule change and pending override recalculations require the addition of an index to OVERRIDE.
  • Job rate change recalculations require the addition of the TRG_JOBRATE_AU trigger to the JOB_RATE table. The trigger records updates into a CHANGE_HISTORY table. After the task runs, the trigger looks at all the changed job rates since the last run and invokes calculations based on the nature of the change.
  • Scheduled employees without clock activity (no show employees) and processed clock recalculations require the addition of an index to CLOCK_TRAN_PROCESSED.
  • Entitlement policy change recalculations require the addition of the TRG_ENTEMPPOLBR_AIUD trigger to the ENT_EMP_POLICY table. The trigger records updates into a CHANGE_HISTORY table. After the task runs, the trigger looks at all the changed ent_emp_policy records since the last run and invokes calculations based on the nature of the change.

Please contact your Infor support team for additional information on installing these components.