Versions Compared

Version Old Version 2 New Version 3
Changes made by

James Barnsley

James Barnsley

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • row_type will be one of:

    • summary

    • timesheet_entry

  • row_name can be one of:

    • paid_rest_break

    • topup

    • contract_hours

    • total_hours

    • ordinary_hours

    • overtime_hours

      • If multiple overtime rates, then these will be in the format overtime_hours_RATE, for example overtime_hours_2.0

    • days_worked

    • pay_contract_summary 

    • agreed_hours_topup

Examples

Example 1

Code Block
IF $row_type == summary THEN $hours

  • If the row is a summary row, then return the row’s $hours

  • Example result

    Result: “1.25”

Example 2

Code Block
IF $unit_rate == 1.5 THEN piece rate+_+$unit_rate

  • If the row’s unit rate is 1.5, then concatenate text with

    unit rate

    “unit rate”

  • Example result: “piece rate_1.5”

Example 3

Code Block
IF $row_name == topup THEN

...

 $total
IF $row_name == paid_rest_break THEN

...

 $hours
IF $row_type == timesheet_entry AND $rate_type == contract THEN $unit_

...

rate
ELSE $hourly_rate

  1. If the row is the top-up summary row, then return the total value ($total); otherwise

  2. If the row is the paid breaks summary row, then return the number of hours ($hours); otherwise

  3. If the row is a contract timesheet entry, then return the unit rate ($unit_rate); otherwise

  4. Return the hourly rate ($hourly_rate)