Calc Group Rate Settings panel (CALC_GROUP_RATE table)

This table (Maintenance > Payroll Settings > Calc Group > Details) contains prioritized records, which are examined one by one in ascending order. When a set of conditions is met, the rate is applied according to the parameter values.

Parameter Description
Cgr Name The name for the calculation group rate setting.
Cgr Desc Extended description for the calculation group rate setting.
Calcgrp Id The calculation group to which the rate definition applies.
Cgr Priority Order in which the conditions are evaluated. Lower numbers are evaluated first. If multiple conditions are applicable, the rate with the highest number priority is applied.

For example, suppose a rate of 5.00 with a priority of 3 and a rate of 6.00 both meet the rule's conditions. In this case the rule applies the rate of 6.00.
Cgr Effective Date The date from when this record is effective.
Cgr Rate Type Can be one of these values:
  • ABSOLUTE: The specified value represents the actual rate and will overrule prior rates that were determined.
  • INCREMENTAL: The specified value is added or subtracted to the rate that was calculated previously (for example, -1).
  • PERCENTAGE: The percentage is applied to the previously calculated rate and the rate will be decreased (negative percentage) or increased (positive percentage). For example, -20 with rate 10 will set the rate to 10 - 2 = 8.
  • PIECE: The rate is applied based on the docket piece rate.
  • JOB: The rate is applied based on job rate.
Cgr Rate Value The actual rate value as per the specified rate type.
Cgr Rate Mode Select one of these values:
  • GREATEST: Use the greater of the base or the calculated rate.
  • LEAST: Use the smaller of the base or the calculated rate.
  • AS_IS: Use the calculated rate (default).
Cgr Scheduled Select the days on which the logic is applied. You can select one of these values:
  • SCHEDULED
  • UNSCHEDULED
  • ALL

ALL is the default.
Cgr Shift To Check Select whether to use the actual scheduled shift (Actual) or the default scheduled shift (Default) when comparing the shift against the list that is defined above.

If left blank, then Actual is the default.

Cgr Shift Names Specify the shift names the condition applies to. Leave blank for all.
Cgr Shiftpat Names Specify the shift pattern names the condition applies to. Leave blank for all.
Cgr Shift Must Start Before Defines the time before which the shift must start for the premium to apply.
Cgr Shift Must Start After When set, defines the time after which the shift must start for the premium to apply.

The Cgr Shift Must Start After parameter is evaluated by taking the hours after midnight for the scheduled start and the parameter value and then comparing the two values. For example, 07:00 is after 06:00, but 01:00 is not after 23:00.

Cgr Shift Must End Before Defines the time before which the shift must end for the premium to apply.
Cgr Shift Must End After Defines the time after which the shift must end for the premium to apply.
Cgr Tcode Names Specify the time code names the condition applies to. Leave blank for all.
Cgr Htype Names Specify the hour type names the condition applies to. Leave blank for all.
Cgr Job Names Specify the job names the condition applies to. Leave blank for all.
Cgr Dept Names Specify the department names the condition applies to. Leave blank for all.
Cgr Dock Names Specify the docket names the condition applies to. Leave blank for all.
Cgr Proj Names Specify the project names the condition applies to. Leave blank for all.
Cgr Must Work Minutes Restricts premiums based on whether the employee worked at least this number of minutes during scheduled/all times. Cgr Must Work Minutes values end with S, %S, T, or %T.
  • If the value ends with S, the value is calculated based on worked minutes in the scheduled time. For example, if employees are scheduled from 10:00 to 18:00, but actually work 15:00 to 20:00, they do not receive a premium since they worked 180 minutes in eight hours of schedule time.
  • If the value ends with %S, the value is calculated as a percentage of the actual shift for the day. For example, if 50%S, employees must work greater than 50% of their default schedule duration.
  • If the value ends with %T, the value is calculated as a percentage of the worked time between the Cgr Must Work Mins Start and Cgr Must Work Mins End parameters. For example, if 50%T, the sum of work minutes between 10:00 and 18:00 must be greater than 50% of all worked minutes.
  • If the value ends with T, the value is calculated as worked time minutes between the Cgr Must Work Mins Start and Cgr Must Work Mins End parameters. For example, if 240T, the sum of worked minutes between 10:00 and 18:00 must be greater than 240 minutes.
Cgr Mwmin Tcodes Used only if the Cgr Must Work Minutes value ends with %T or T.
Cgr Mwmin Htypes Used only if the Cgr Must Work Minutes value ends with %T or T.
Cgr Must Work Mins Start Used only if the Cgr Must Work Minutes value ends with %T or T.
Cgr Must Work Mins End Used only if the Cgr Must Work Minutes value ends with %T or T.
Cgr Condition An open string where the condition can be built based on work detail and work summary UDF and flag fields. Such tokens are delimited with commas and ANDed.

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 WRKS_FLAG1, specify wrksFlag1.

For example, wrkdUdf1=GUARD,wrksFlag1=Y will be satisfied if wrkd_udf1 equals GUARD AND wrks_flag1= Y on the work date.

Supported fields are wrkd_udf1...10, wrkd_flag1...5, wrks_udf1...10, and wrks_flag1...10.

Cgr DaytypIds When defined, indicates which days to apply the rate definition. For example, FIRST DAY OFF applies the rate if the day is the employee's first day off.