/
Wage Codes

Wage Codes

When a Timesheet Batch runs, it will retrieve the relevant information from the Service Appointment and run the rules detailed in the tables below to populate the Wage_Code__c field on Time Sheet Entry records:

Wage Code

Rule Name

Conditions

Notes

Wage Code

Rule Name

Conditions

Notes

1

Day Shift - Monday to Friday

  • Day = Monday to Friday

  • SchedStartTime > 6:00am

    • and/or

  • SchedEndTime = or < 8:00pm

Generate one row with Wage Code = 1

20

Afternoon Shift - Monday to Friday

  • Day = Monday to Friday

  • 12:00am =< SchedEndTime > 8:00pm

Generate one row with Wage Code = 20

2

Night Shift - Monday to Friday

  • Day = Monday to Friday

  • SchedEndTime > 12:00am

    • or

  • SchedStartTime < 6:00am

Generate one row with Wage Code = 2

3

Saturday

  • Day = Saturday

Generate new row with Wage Code = 3 for all hours worked on Saturday

5

Sunday

  • Day = Sunday

Generate new row with Wage Code = 5 for all hours worked on Sunday

6

Public Holiday

  • Day = Public Holiday

Generate new row with Wage Code = 6 for all hours worked on a Public Holiday. These are configured in SetupHolidays

8

Sleepover - Monday to Friday

  • Day = Monday to Friday

  • Support Item Number = 01_010_0107_1_1

Generate new row with Wage Code = 8 for Quantity of WOLI Product = 01_010_0107_1_1 OR SO001

9

Sleepover - Saturday and Sunday

  • Day = Saturday and Sunday

  • Support Item Number = 01_010_0107_1_1

Generate new row with Wage Code = 9 for Quantity of WOLI Product = 01_010_0107_1_1 OR SO001

15

Sleepover - Public Holiday

  • Day = Public Holiday

  • Support Item Number = 01_010_0107_1_1

Generate new row with Wage Code = 15 for Quantity of WOLI Product = 01_010_0107_1_1 OR SO001

Sleepover Shifts:

For the three Sleepover shifts identified in the above table, these have standard hourly rates. We want to create custom settings for these hourly rates that will be brought into the Timesheet CSV:

  • Sleepover - Monday to Friday = 16.15

  • Sleepover - Saturday and Sunday = 18.41

  • Sleepover - Public Holiday = 20.03


 

Related content

Time Sheet Entry Record
Time Sheet Entry Record
More like this
Time Sheet Entry & Invoice Line Item Data Flow
Time Sheet Entry & Invoice Line Item Data Flow
More like this
CCS - Time Sheet Entry & Invoice Line Item Data Flow
CCS - Time Sheet Entry & Invoice Line Item Data Flow
More like this
WOLI & TSE Updates
WOLI & TSE Updates
More like this
MyForce Glossary: Data model
MyForce Glossary: Data model
More like this
DCR - Time Sheet Entry & Invoice Line Item Data Flow
DCR - Time Sheet Entry & Invoice Line Item Data Flow
More like this