Content Comparison

...

• IF a rule exists on this line

• ELSE if no rules above match, use this result

• $value_type value type name

• $empty special handler for empty values

• == equals

• != does not equal

• AND links multiple conditions

• THEN result follows

• + concatenate with another value type or text

...

• Standard fields

  • date

  • finish_time

  • from_date

  • hourly_rate

  • hourly_rate_adjusted

  • pdrst_hours

  • hours

  • job_notes

  • rate_autoselect

  • rate_type

  • rate_type_text

  • role

  • start_time

  • start_time__finish_time

  • to_date

  • total

  • unit_rate

  • units

  • units_autoselect

  • unpaid_break

  • row_split

  • submitted_late

  • unpaid_break_start_times

  • unpaid_break_end_times

  • multiplier

• Association fields

  • clientabsence__code

  • clientabsence__costing_codeclient_namecomment

  • absence__location_name

  • block__codes

  • block_namelocation__costing_code

  • locationblock_name__names

  • block_name__task_name

  • blockclient__code

  • client__costing_code

  • blockclient__division

  • client__subdivision

  • client_name__location_name__taskblock_name

  • costing_code

  • costing_code__task_code

  • task_categoryemployee__division

  • employee__codeemail

  • taskemployee_category_full_name

  • taskemployee_code_recruitment_codetype

  • taskemployee_code_staff_nameid

  • employee__emailsubdivision

  • employee__groups

  • job__leader__full_name

  • employee__recruitment_type

  • employee__staff_id

  • employee__division

  • employee__subdivision

  • employee__groupslocation__costing_code

  • location__division

  • location__subdivision

  • location_name__block_name__task_name

  • task_category__code

  • task_category__name

  • task_code__code

  • task_code__name

• Costs

  • base_cost

  • topups_cost

  • pdrst_cost

  • pay_performance_bonus_cost

    • Proportion of total performance bonus earned, applied to this timesheet

  • performance_bonus

    • Performance of the timesheet. Useful for per-timesheet performance comparisons.

    • Positive when unit rate (converted to hourly) is above hourly rate.

    • Negative when unit rate (converted to hourly) is below hourly rate.

  • foreign_cost

  • additional_cost

  • overtime_cost

  • total_cost

  • cost_per_unit

• Other fields

  • custom_logic

  • row_name

  • row_type

...

• row_type will be one of:

  • summary

  • timesheet_entry

  • absence

• row_name can be one of:

  • paid_rest_break

  • topup

  • contract_hours

  • hourly_hours

  • performance_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

  • minimum_earnings_topup

  • pay_performance_summary

  • performance_bonus

  • absence_hours

...

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)

Example 4

IF $location__division != $empty THEN $location__division
IF $client__division != $empty THEN $client__division
IF $row_type == timesheet_entry THEN No Division

1. If the row has a Location Division, then return its name

2. If the row has a Client Division, then return its name

3. If the row is a timesheet entry return the text “No division”

4. Otherwise, return nothing