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 3 changed one line
The propose of this rule is to apply overtime in days with leaves.
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 5 changed one line
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 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 7 removed 2 lines
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.
At line 9 added one line
At line 12 changed 4 lines
Frequency
*predefined as ‘Every Day’
*Apply time code set required
Example\\
Frequency predefined as Every Day
Example:\\
At line 17 changed 4 lines
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.
\\ 5:00 am - 9:00 am - Work
\\ 9:00 am - 3:00 pm - Leave
\\ 3:00 pm - 5:00 pm - Work
At line 22 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
\\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 25 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
|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 32 changed 2 lines
|TR| Sequence| Target TCS | Apply TCS| TC
|OT Leave| 1| LEAVE OT (LV, REG, MEAL)| LEAVE| Lv OT
The example above requires the following set up:\\
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
||TR|| Sequence|| Target TCS || Apply TCS|| TC
|OT Leave| 1| LEAVE OT (LV, REG, MEAL)| LEAVE| LV OT
At line 36 changed one line
This new rule will work similarly with OT Daily (it will be applied from the end of the day).
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 38 changed 2 lines
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
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 42 changed one line
(HoursToBeApplied = 4 starting form 13:00):
(Hours To Be Applied = 4 starting from 13:00):
At line 44 changed 46 lines
|e.g.| Sequence #1| Sequence #2
|1.|Regular at the end \\
0500 1100 Lv \\
1100 1700 Reg\\
The last record does not qualify
(is not in Apply TCS )
HoursToBeApplied = 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
HoursToBeApplied = 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 \\
HoursToBeApplied = 4 \\ \\
Results after apply: \\
0500 1100 Reg \\
1100 1300 Lv \\
1300 1700 Lv OT| 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\\ \\
HoursToBeApplied = 4 \\
Last record does not qualify HoursToBeApplied = 4 - 2 = 2\\ \\
Next record does not qualify \\
HoursToBeApplied = 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
||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 91 changed 2 lines
The last record does not qualify (is not in Apply TCS )
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 94 removed 8 lines
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 103 removed 27 lines
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 132 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 138 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