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 3 lines
!!!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.
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.
At line 5 changed one line
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.
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
At line 7 changed 2 lines
!!Requirements / Features
*Time Rule Type Code: OT LEAVE
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
At line 10 changed 2 lines
!!Additional Info
Frequency predefined as Every Day
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 13 changed 5 lines
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
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):
At line 19 changed one line
\\There are 8 hour bands for OT. \\In this example, the hours that qualify for overtime are 1:00 pm - 05:00 pm.
e.g. Sequence #1 Sequence #2
1. Regular at the end
At line 21 changed 2 lines
|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
0500 1100 Lv
1100 1700 Reg
At line 24 changed one line
The example above requires the following set up:\\
The last record does not qualify
(is not in Apply TCS )
HoursToBeApplied = 4- 6 = -2
(so nothing to apply)
At line 26 changed 5 lines
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
Results after apply:
0500 1100 Lv
1100 1700 Reg Regular at the end
0500 1100 Lv
1100 1700 Reg
At line 32 changed 3 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
The last record qualifies
HoursToBeApplied = 4
At line 36 changed one line
This time rule works similarly with [OT Daily|TR_OT_DAILY] in that it will be applied from the end of the day.
Results after apply:
0500 1100 Lv
1100 1300 Reg
1300 1700 OT
2. Leave at the end
0500 1100 Reg
1100 1700 Lv
At line 38 changed 2 lines
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.
The last record qualifies
HoursToBeApplied = 4
At line 41 changed 2 lines
Example of how it works:
(Hours To Be Applied = 4 starting from 13:00):
Results after apply:
0500 1100 Reg
1100 1300 Lv
1300 1700 Lv OT Leave at the end
0500 1100 Reg
1100 1700 Lv
At line 44 changed 6 lines
||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.|
Results after applying Sequence #1: 0500 1100 Reg
1100 1300 Lv
1300 1700 Lv OT
At line 51 changed 3 lines
!!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
HoursToBeApplied = 4
Last record does not qualify HoursToBeApplied = 4 - 2 =2
At line 86 added 2 lines
Next record does not qualify
HoursToBeApplied = 2 - 2 =0
At line 56 changed one line
General set up example
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
At line 58 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
The last record does not qualify (is not in Apply TCS )
HoursToBeApplied = 4- 2 = 2
At line 62 changed one line
The multiple type of leaves set up will be something like below
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
At line 64 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
The last record does not qualify (is not in Apply TCS )
HoursToBeApplied = 4- 2 = 2
At line 112 added 4 lines
Results after appling Sequence #1: 0500 0900 Reg
0900 1300 Lv
1300 1500 Lv OT
1500- 1700 Reg
At line 71 changed 3 lines
----
![Notes|Edit:Internal.TR_OT_LEAVE]
[{InsertPage page='Internal.TR_OT_LEAVE' default='Click to create a new notes page'}]
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
General set up example
TR Sequence Target TCS Apply TCS TC
OT Leave 1 LEAVE OT LEAVE LVOT
OT Leave 2 LEAVE OT REG REG OT
The multiple type of leaves set up will be something like below
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
This page (revision-25) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop