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
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.
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
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 Set; 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.
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 15 changed 4 lines
5:00 am - 9:00 am - Work
9:00 am - 3:00 pm - Leave
3:00 pm - 5:00 pm - 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 20 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 23 changed 6 lines
The example needs the following set up:\\
The [Apply Time Code Set|DTCS_ID_APPLY] 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 24 added 8 lines
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
At line 31 changed one line
|OT Leave| 1| LEAVE OT (LV, REG, MEAL)| LEAVE| Lv OT
|OT Leave| 1| LEAVE OT (LV, REG, MEAL)| LEAVE| LV OT
At line 34 changed one line
This new rule will work similarly with [OT Daily|TR_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 37 changed one line
When we apply the rule, if the record that qualifies is not included in an [Apply Time Code Set|DTCS_ID_APPLY], the hour to be applied will be reduced by the hours corresponding to that record
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 40 changed one line
(HoursToBeApplied = 4 starting form 13:00):
(Hours To Be Applied = 4 starting from 13:00):
At line 43 changed 5 lines
|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\\ \\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|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\\ \\The last record does not qualify (is not in Apply TCS)\\HoursToBeApplied=4- 2=2\\ \\Results after applying 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.|
|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 50 changed 2 lines
||[Band|QUALIFYING_BAND]||[From|FROM_CLOCK_TIME]||[To|TO_CLOCK_TIME] ||[Value|TIME_RULE_VALUE]||[Day Of Week |DAY_OF_WEEK]||[Time Code|TIME_CODE]||[Premium |PREMIUM_CODE]||[Action|TIME_RULE_ACTION]||[Targeted Time Code Sets |DTCS_ID_TARGET]||[Apply Time Code Sets|DTCS_ID_APPLY]
|0|No|No|No|Allowed|Yes|Yes|Add/Replace|Required|Required
||[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 55 added one line
This page (revision-25) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop