This page (revision-25) was last changed on 26-Nov-2021 10:22 by mmcfarland

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
25 26-Nov-2021 10:22 5 KB mmcfarland to previous
24 26-Nov-2021 10:22 5 KB mmcfarland to previous | to last
23 26-Nov-2021 10:22 5 KB mmcfarland to previous | to last
22 26-Nov-2021 10:22 5 KB mmcfarland to previous | to last
21 26-Nov-2021 10:22 5 KB mmcfarland to previous | to last

Page References

Incoming links Outgoing links
TR_OT_LEAVE
TR_OT_LEAVE

Version management

Difference between version and

At line 1 changed 17 lines
OT LEAVE - Overtime Leave
Time Rule Overview
The propose of this rule is to apply overtime in days with leaves.
Depending on the time that should be replaced, it will apply the Leave OT time code for leave time or Regular OT time code for regular time.
In order for this time rule to work properly there must be at least two instances of this time rule defined in IDWR. Each instance will have different apply time code sets; one to apply the rule to the overtime codes and the second to apply the overtime to the regular time codes.
Requirements / Features
Time Rule Type Code: OT LEAVE
Additional Info
Frequency
predefined as ‘Every Day’
Apply time code set required
Example
The employee is scheduled from 5:00 am - 5:00pm
5:00 am - 9:00 am Work
9:00 am - 3:00pm Leave
3:00 pm - 5:00pm Work
There are 8 hour bands for OT. In this case, the hours that qualify for Leave OT will be 1:00pm - 05:00pm.
!!!OT LEAVE - Overtime Leave
!!Time Rule Overview
This time rule will apply overtime on days with Leaves. It will apply the Leave OT time code for leave time or the Regular OT time code for regular time, depending on the type of time that should be replaced.
At line 19 changed 2 lines
2 hours of leave 1:00pm -3:00pm This should be replaced by Leave OT
2 hours of work 3:00pm - 5:00pm This should be replaced by Regular OT
In order for this time rule to work properly, there must be at least two instances of this time rule defined in [IDWR]. Each instance will have different Apply Time Code Sets defined; one to apply the rule to the overtime time codes, and the second to apply the overtime to the regular time codes. See example below.
At line 22 changed 6 lines
The example needs the following set up:
The Apply time code set is mandatory in this time rule case. The sequence is important.
Abbreviations:
TR - time rule
TCS - time code set
TC - time code
!!Requirements / Features
*Time Rule Type Code: OT LEAVE
At line 29 changed 5 lines
TR Sequence Target TCS Apply TCS TC
OT Leave 1 LEAVE OT
(LV, REG, MEAL) LEAVE Lv OT
OT Leave 2 LEAVE OT REG
(LV, REG, MEAL, LV OT) REG OT
!!Additional Info
Frequency predefined as Every Day
At line 35 changed 5 lines
This new rule will work similarly with OT Daily (it will be applied from the end of the day).
The difference from OTDaily :
When we apply the rule, if the record that qualifies is not included in an Apply TCS, the hour to be applied will be reduced by the hours corresponding to that record
Example of how it works:
(HoursToBeApplied = 4 starting form 13:00):
Example:\\
The employee is scheduled from 5:00 am - 5:00pm
\\ 5:00 am - 9:00 am - Work
\\ 9:00 am - 3:00 pm - Leave
\\ 3:00 pm - 5:00 pm - Work
At line 41 changed 2 lines
e.g. Sequence #1 Sequence #2
1. Regular at the end
\\There are 8 hour bands for OT. \\In this example, the hours that qualify for overtime are 1:00 pm - 05:00 pm.
At line 44 changed 2 lines
0500 1100 Lv
1100 1700 Reg
|2 hours of leave|1:00 pm - 3:00 pm |This will be replaced by Leave OT
|2 hours of work|3:00 pm - 5:00 pm |This will be replaced by Regular OT
At line 47 changed 4 lines
The last record does not qualify
(is not in Apply TCS )
HoursToBeApplied = 4- 6 = -2
(so nothing to apply)
The example above requires the following set up:\\
At line 52 changed 5 lines
Results after apply:
0500 1100 Lv
1100 1700 Reg Regular at the end
0500 1100 Lv
1100 1700 Reg
The [Apply Time Code Set|DTCS_ID_APPLY] field is mandatory in this example. The sequence is important.
The abbreviations:
\\TR - time rule
\\TCS - time code set
\\TC - time code
At line 58 changed 2 lines
The last record qualifies
HoursToBeApplied = 4
||TR|| Sequence|| Target TCS || Apply TCS|| TC
|OT Leave| 1| LEAVE OT (LV, REG, MEAL)| LEAVE| LV OT
|OT Leave| 2| LEAVE OT REG (LV, REG, MEAL, LV OT)| REG| OT
At line 61 changed 7 lines
Results after apply:
0500 1100 Lv
1100 1300 Reg
1300 1700 OT
2. Leave at the end
0500 1100 Reg
1100 1700 Lv
This time rule works similarly with [OT Daily|TR_OT_DAILY] in that it will be applied from the end of the day.
At line 69 changed 2 lines
The last record qualifies
HoursToBeApplied = 4
The difference from [OT Daily|TR_OT_DAILY] :
When the rule is applied, if the record that qualifies is not included in the [Apply Time Code Set|DTCS_ID_APPLY], the hours to be applied will be reduced by the hours corresponding to that record.
At line 72 changed 6 lines
Results after apply:
0500 1100 Reg
1100 1300 Lv
1300 1700 Lv OT Leave at the end
0500 1100 Reg
1100 1700 Lv
Example of how it works:
(Hours To Be Applied = 4 starting from 13:00):
At line 79 changed 3 lines
Results after applying Sequence #1: 0500 1100 Reg
1100 1300 Lv
1300 1700 Lv OT
||e.g.|| Sequence #1|| Sequence #2
|1.|Regular at the end\\ \\0500 1100 Lv \\1100 1700 Reg\\ \\The last record does not qualify\\ (not defined in Apply TCS)\\Hours To Be Applied = 4- 6 = -2\\(so nothing to apply)\\ \\Results after apply:\\0500 1100 Lv\\1100 1700 Reg|Regular at the end\\0500 1100 Lv\\1100 1700 Reg\\ \\The last record qualifies Hours To Be Applied = 4\\ \\Results after apply:\\0500 1100 Lv\\1100 1300 Reg\\1300 1700 OT
|2.|Leave at the end\\0500 1100 Reg\\1100 1700 Lv\\ \\The last record qualifies\\Hours To Be Applied = 4\\ \\Results after apply:\\0500 1100 Reg\\1100 1300 Lv\\1300 1700 Lv OT\\ \\Regular and Leave qualify\\0500 0900 Reg\\0900 1500 Lv\\1500 1700 Reg\\ \\The last record does not qualify (not defined in Apply TCS)\\Hours To Be Applied = 4- 2 = 2\\ \\Results after applying:\\0500 0900 Reg\\0900 1300 Lv\\1300 1500 Lv OT\\1500- 1700 Reg|Leave at the end\\0500 1100 Reg\\1100 1700 Lv \\ \\Results after applying Sequence #1:\\0500 1100 Reg\\1100 1300 Lv\\1300 1700 Lv OT\\ \\Hours To Be Applied = 4\\Last record does not qualify\\ Hours To Be Applied = 4 - 2 = 2\\ \\Next record does not qualify\\Hours To Be Applied = 2 - 2 = 0\\ \\Results after apply Sequence #2:\\0500 1100 Reg\\1100 1300 Lv\\1300 1700 Lv OT\\ \\Regular and Leave qualify\\0500 0900 Reg\\0900 1500 Lv\\1500 1700 Reg\\ \\The last record does not qualify (not defined in Apply TCS)\\Hours To Be Applied=4- 2=2\\ \\Results after applying Sequence #1:\\0500 0900 Reg\\0900 1300 Lv\\1300 1500 Lv OT\\1500- 1700 Reg\\ \\Hours To Be Applied = 4\\Last record qualifies\\Hours To Be Applied = 4 - 2 = 2\\Next record does not qualify Hours To Be Applied = 2 - 2 =0\\ \\Results after applying Sequence #2:\\0500 0900 Reg\\0900 1300 Lv\\1300 1500 Lv OT\\1500- 1700 OT
| |Regular and Meal qualify similar to sequence #1 but Meal will not be replaced|
| |Leave and meal qualify similar to sequence #2 but Meal will not be replaced|
| |Leave, regular and meal qualify similar to sequence # 3 but the meal will not be replaced.|
At line 83 changed 2 lines
HoursToBeApplied = 4
Last record does not qualify HoursToBeApplied = 4 - 2 =2
!!Implementation
||[Cycle|CYCLE_NUMBER]||[Frequency|FREQUENCY]||[Seq|SEQUENCE]||[Time Rule Type|TIME_RULE_TYPE_TEXT]||[Band|QUALIFYING_BAND]||[From|FROM_CLOCK_TIME]||[To|TO_CLOCK_TIME]||[Value|VALUE]||[Day|DAY_OF_WEEK]||[Time Code|TIME_CODE_VALUE]||[Premium|PREMIUM_CODE]||[Target Time Code Set|TARGET_TIME_CODE_SET]|| [Apply Time Code Set|APPLY_TIME_CODE_SET]||[Action|TIME_RULE_ACTION]
| |Every Day|1140| |No|No|No|No|Allowed|Allowed|Allowed|Required|Required|Add/Replace
At line 86 removed 2 lines
Next record does not qualify
HoursToBeApplied = 2 - 2 =0
At line 89 removed 47 lines
Results after apply Sequence #2: 0500 1100 Reg
1100 1300 Lv
1300 1700 Lv OT
Regular and Leave qualify
0500 0900 Reg
0900 1500 Lv
1500 1700 Reg
The last record does not qualify (is not in Apply TCS )
HoursToBeApplied = 4- 2 = 2
Results after applying:
0500 0900 Reg
0900 1300 Lv
1300 1500 Lv OT
1500- 1700 Reg Regular and Leave qualify
0500 0900 Reg
0900 1500 Lv
1500 1700 Reg
The last record does not qualify (is not in Apply TCS )
HoursToBeApplied = 4- 2 = 2
Results after appling Sequence #1: 0500 0900 Reg
0900 1300 Lv
1300 1500 Lv OT
1500- 1700 Reg
HoursToBeApplied = 4
Last record qualifies
HoursToBeApplied = 4 - 2 =2
Next record does not qualify HoursToBeApplied = 2 - 2 =0
Results after applying Sequence #2: 0500 0900 Reg
0900 1300 Lv
1300 1500 Lv OT
1500- 1700 OT
Regular and Meal qualify Similar #1 but Meal will not be replaced
Leave and meal qualify
Similar #2 but Meal will not be replaced
Leave, regular and meal qualify Similar to sequence # 3 but the meal will not be replaced.
Implementation
Band From To Value Day Time Code Premium Action Time Code Set Apply Time Code Set
0 No No No Allowed Yes Yes Add/Replace Required Required
At line 138 changed 3 lines
TR Sequence Target TCS Apply TCS TC
OT Leave 1 LEAVE OT LEAVE LVOT
OT Leave 2 LEAVE OT REG REG OT
||TR|| Sequence|| Target TCS|| Apply TCS|| TC
|OT Leave| 1| LEAVE OT| LEAVE| LVOT
|OT Leave| 2| LEAVE OT REG| REG| OT
At line 144 changed 5 lines
TR Sequence Target TCS Apply TCS TC
OT Leave 1 Vac OT Vac Vac OT
OT Leave 2 Sick OT Sick Sick OT
OT Leave 3 LEAVE OT REG REG OT
OT Daily(with bands) 4 REG OT
||TR|| Sequence|| Target TCS|| Apply TCS|| TC
|OT Leave| 1| Vac OT| Vac| Vac OT
|OT Leave| 2| Sick OT | Sick| Sick OT
|OT Leave| 3| LEAVE OT REG| REG| OT
|OT Daily(with bands)| 4| REG| | OT
----
![Notes|Edit:Internal.TR_OT_LEAVE]
[{InsertPage page='Internal.TR_OT_LEAVE' default='Click to create a new notes page'}]
This page (revision-25) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop