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

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

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
34 26-Nov-2021 10:22 23 KB kparrott to previous
33 26-Nov-2021 10:22 23 KB kparrott to previous | to last
32 26-Nov-2021 10:22 23 KB jlawler to previous | to last
31 26-Nov-2021 10:22 22 KB jlawler to previous | to last
30 26-Nov-2021 10:22 22 KB jlawler to previous | to last
29 26-Nov-2021 10:22 21 KB jlawler to previous | to last
28 26-Nov-2021 10:22 19 KB jlawler to previous | to last
27 26-Nov-2021 10:22 17 KB jlawler to previous | to last
26 26-Nov-2021 10:22 16 KB jlawler to previous | to last
25 26-Nov-2021 10:22 16 KB jlawler to previous | to last
24 26-Nov-2021 10:22 15 KB jlawler to previous | to last
23 26-Nov-2021 10:22 13 KB jlawler to previous | to last
22 26-Nov-2021 10:22 13 KB jlawler to previous | to last
21 26-Nov-2021 10:22 11 KB jlawler to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 16 removed 2 lines
\\
----
At line 23 changed 2 lines
\\
----
At line 28 changed one line
The Holidays Use Scheduled Hrs toggle only applies to the hours generated for the [Holiday Time Code|DTC_ID_LEAVE]. It does not extend to the [Worked Time Code|DTC_ID_WORK].
The Holidays Use Scheduled Hrs toggle only applies to the hours generated for the [Holiday Time Code|HOLIDAY_TIME_CODE]. It does not extend to the [Worked Time Code|WORKED_TIME_CODE].
At line 34 changed 2 lines
#Use the employee’s overridden Work Calendar scheduled hours per day if specified, otherwise
#Use the Work Rule’s Work Calendar scheduled hours per day if specified, otherwise
#Use the employee’s overridden Work Calendar scheduled hours per day if specified, otherwise
#Use the Work Rule’s Work Calendar scheduled hours per day if specified, otherwise
At line 40 changed one line
A holiday that falls on a non scheduled day (day off) will always use the assignment hours regardless if the Holiday’s Use Scheduled Hrs toggle is ON or OFF.
A holiday that falls on a non scheduled day (day off) will always use the assignment hours regardless if the Holiday’s Use Scheduled Hrs toggle is ON or OFF.
At line 45 removed one line
\\
At line 47 removed 7 lines
----
!!Holiday Time Rules
The following time rules can be used in conjunction with timesheet holiday processing:
* [Paid Holiday|PAID HOLIDAY]
* [Worked Holiday|TR_WORKED_HOLIDAY]
* [OT Holiday|TR_OT_HOLIDAY]
* [Offset Paid Holiday|OFFSET PAID HOL]
At line 55 removed one line
Time rules can be quite complex or quite simple depending on each client's needs. Time rules should be thoroughly tested before they are utilized in a production environment to ensure desired results.
At line 57 removed 267 lines
!Paid Holiday
*This time rule is based from a time scheduling requirement where the worked time is not always predictable i.e. shift patterns
*This rule will generate the paid holiday based on the actual time worked by the employee.
*To identify work on the day of a holiday, the rule will use the Work Holiday time code defined in IDHC, the time code specified in the DFT Time Code time rule or the target time code set if defined
*The only Observe On rule which this time rule respects is Holiday Date
*A time code is allowed in the definition but should be used only when you need to override the Holiday Time Code from IDHC. If you need to use Day Off Time Code you should not define the time code at the Time Rule level
*The Target Time Code Set may include the holiday Worked Time Code defined in IDHC or the one applied by Worked Holiday time rule or Default Time Code depending on each client’s particular need. If the target time code set is not defined, the Worked Time Code from IDHC or the time code from [Default Time Code|TR_DFLT_TIME_CODE] rule is used to identify if the employee worked on the holiday
*This time rule can be used to allow the holiday paid hours to exceed the assignment hours per day for part time employees.
*If the value is defined and is 1, then for part time employees who work on a holiday, the holiday time paid can exceed the hours defined at the assignment level and can be equal with work hours on a holiday.
||[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]||[Target Time Code Set|IDTCS]||[Apply Time Code Set|IDTCS]
|Number|No|No|1 = Allow\\ Exceed Assignment \\Hours for FTE < 1|No|Allowed|No|Add|Allowed|No
!Worked Holiday
This time rule will apply a holiday time code if the employee worked on the holiday
This is used when the time entries are generated from [UTTP], [UPAUTOFILL], or from Self Service where the employees are entering their time entries. These processes will not recognize when a holiday has fallen in the pay period, as a result this time rule is used to recognize when there is a holiday in the time period and to replace the regular work time code with the [Holiday Work time code|DTC_ID_WORK].
This time rule can be used to apply a holiday work time code to a portion of a shift when the shift crosses over midnight. This is done by specifying in [IDHC] the [Holiday Rule|HOLIDAY_RULE] - Partial Shifts Apply.
This time rule will also respect the [Start Time|HOLIDAY_START_TIME] in [IDHC] if specified. If a [Start Time|HOLIDAY_START_TIME] has been specified, the [Holiday Work time code|DTC_ID_WORK] will be invoked at that time.
The time rule should be set up in [IDWR] as shown below. See [Time Rule Improvements|TIME_RULE_IMPROVEMENTS] for additional information regarding [IDWR].
||[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]||[Target Time Code Set|IDTCS]||[Apply Time Code Set|IDTCS]
|Zero|No|No|No|No|Allowed|No|Replace|Allowed|Allowed
!OT Holiday
This time rule will apply overtime to a worked holiday
Applies overtime commencing with the holiday Start Time if defined in [IDHC], otherwise OT will commence when the shift starts.
This rule cannot be used for partial shifts. If clients with partial shifts require OT to be applied to a holiday they need to set up the [Worked Holiday|TR_WORKED_HOLIDAY] time rule as well as the [OT Daily|TR_OT_DAILY] time rule. They need to ensure the holiday worked time code is in the target time code set of the [OT Daily|TR_OT_DAILY] rule.
The time rule should be set up in [IDWR] as shown below. See [Time Rule Improvements|TIME_RULE_IMPROVEMENTS] for additional information regarding [IDWR].
||[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]||[Target Time Code Set|IDTCS]||[Apply Time Code Set|IDTCS]
|Zero|No|No|No|No|Allowed|No|Replace|Allowed|Allowed
!Offset Paid Holiday
*If a leave day is found immediately before or after a holiday then the employee will not be entitled to the holiday paid time, as a result the awarded holiday paid time will be offset by this rule
*Time Code should be the time code that is used when the holiday time is generated so that the Time Rule knows which Time Code is to be offset
*Target Time Code Set should contain the Work time codes so that it can help identify the work days
*Apply Time Code Set should contain the Leave time codes so it can help identify the leave days
*The timeframe to look back/forward from the holiday is by default 4 days. However, this can be overridden by defining the wanted number of days in the Value field in the time rule.
||[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]||[Target Time Code Set|IDTCS]||[Apply Time Code Set|IDTCS]
|Zero|No|No|Max # of days to\\ look back/forward,\\ default is 4 days|No|Allowed Holiday\\ Time TC|No|Replace|Allowed (Work Type\\ Time Codes)|Allowed (Leave Type\\ Time Codes)
\\
----
!!Work Time Generation in Time Sheets
The following table show how work time is generated using the different methods available in the work rule (IDWR) via the Obtain Details From option in the Status rules tab.
There are two processes in charge of determingin the Work Time Code:
# Scheduled Shifts(TSH)
# Time Sheet Entries (PTSE)
||Obtain Details From||Type||Process used to\\Generate\\ Work time||Scheduled Shifts\\TSH||Time Sheet Entries\\PTSE||Applies\\ Work Holiday \\Time Code
|TM - Hours Calendar|Hours|UEGTS|N/A|Work Time Projector|Yes
|TM - Shift Calendar|From/To|UEGTS|Work Time Projector|TSH|Yes
|TS - Shift Pattern|From/To|UTTP\\UTAUTOFILL|N/A|DFLT TC\\Time Rules|No
|TS - Event Sched|From/To|On the fly\\when station\\requirement\\is created|N/A|DFLT TC\\Time Rules|No
\\
----
!!!Examples of Time Sheet Holiday Processing
!!Hours Based Time Sheet Examples
Unless stated otherwise, the case is for a fulltime employee who has 12 hours scheduled time on their work calendar on the day of the holiday:
!Scenario 1
''This is the case where the employee is scheduled to work but will be taking the holiday off and will get full scheduled hours for the holiday.''
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Holiday Time code=HOLTIME(IDTC __Adjust Scheduled Time__ toggle is __OFF__) \\Worked Time Code = Null\\Day Off Time Code = Null
;Setup on IDWR:Holidays Use Sched Hrs=ON
;Results:0 Hours REG\\12 Hours HOLTIME (Holiday Leave)
!Scenario 2
''This is the case where the employee is scheduled to be working on the holiday and will need to be paid for the day worked plus the holiday. The employee will get full scheduled time for both''
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Holiday Time code=HOLBANK(IDTC __Adjust Scheduled Time__ toggle is __OFF__) \\Worked Time Code = HOLWORK\\Day Off Time Code = Null
;Setup on IDWR:Holidays Use Sched Hrs=ON
;Results:0 Hours REG\\12 Hours HOLBANK (Holiday Bank)\\12 Hours HOLWORK(Replacement for Regular Time)
!Scenario 3
''This is the case where the employee is scheduled to work but will be taking the holiday off and will get only 8 hours for the holiday.''
;Setup on IDHC:Hours Per Day = 8\\OT Factor=Null\\Holiday Time code=HOLTIME(IDTC __Adjust Scheduled Time__ toggle is __OFF__) \\Worked Time Code = Null\\Day Off Time Code = Null
;Setup on IDWR:Holidays Use Sched Hrs=ON
;Results:0 Hours REG\\8 Hours HOLTIME (Holiday Leave)
!Scenario 4
''This is the case where the employee is scheduled to work but is taking the holiday off. the employee must get 8 hrs for holiday and their excess of schedule time remaining in Regular.''
;Setup on IDHC:Hours Per Day = 8\\OT Factor=Null\\Holiday Time code=HOLTIME(IDTC __Adjust Scheduled Time__ toggle is __ON__) \\Worked Time Code = Null\\Day Off Time Code = Null
;Setup on IDWR:Holidays Use Sched Hrs=ON
;Results:4 Hours REG\\8 Hours HOLTIME (Holiday Leave)
!Scenario 5
''This is the case where the employee is scheduled to be working on the holiday and will receive 8 hours for the holiday and receive pay for working their full scheduled hours.''
;Setup on IDHC:Hours Per Day = 8\\OT Factor=Null\\Holiday Time code=HOLBANK(IDTC __Adjust Scheduled Time__ toggle is __OFF__) \\Worked Time Code = HOLWORK\\Day Off Time Code = Null
;Setup on IDWR:Holidays Use Sched Hrs=ON
;Results:0 Hours REG\\8 Hours HOLBANK (Holiday Bank)\\12 Hours HOLWORK(Replacement for Regular Time)
!Scenario 6
''This is the case where the employee is scheduled to be working on the holiday; therefore, they will need to ge 8 hours for the holiday, their excess of scheduled time is paid as regular and they also get their full scheduled hours for working the holiday.''
;Setup on IDHC:Hours Per Day = 8\\OT Factor=Null\\Holiday Time code=HOLBANK(IDTC __Adjust Scheduled Time__ toggle is __ON__) \\Worked Time Code = HOLWORK\\Day Off Time Code = Null
;Setup on IDWR:Holidays Use Sched Hrs=ON
;Results:4 Hours REG\\8 Hours HOLBANK (Holiday Bank)\\12 Hours HOLWORK (Replacement for Regular Time)
!Scenario 7
''This is the case where the employee is NOT scheduled to be workign on the holiday but the employee must be paid for the day on the date specified in the Holiday calendar.''
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Holiday Time code=HOLBANK(IDTC __Adjust Scheduled Time__ toggle is __ON__) \\Worked Time Code = HOLWORK (Will not be used on 'OFF' days)\\Observed On = HOLIDAY DATE\\Day Off Time Code = HOLOFF
;Setup on IDWR:Holidays Use Sched Hrs=ON
;Results:0 Hours REG\\8 Hours HOLOFF (Holiday Leave)
__Note:__ This will only work when the employees ahve time Generated by Day (On Work Rule, Status Rules Tab, Time Generation Rule is set to 'By Day with Time')
!Scenario 8
''This is the case where the employee only works part-time (FTE<1). The employee is to be paid for the number of hours on their assignment in the Hrs/Day field. Their schedule for the week is two -'8' hour days and one - '4' hour day. The holiday falls on teh 1st day, so the employee should only get their maximum of 4 hours for the holiday, not the 8 hours).''
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Holiday Time code=HOLBANK(IDTC __Adjust Scheduled Time__ toggle is __ON__) \\Worked Time Code = HOLWORK\\Day Off Time Code = Null
;Setup on IDWR:Holidays Use Sched Hrs=OFF
;Results:4 Hours REG (8-4=4)\\8 Hours HOLBANK(Holiday Bank)\\8 Hours HOLWORK(Replacement for Regular Time)
__Note:__ The HOLBANK time is taken from the employee's assignment HRS/DAY field to cap the number of hours the employee receives Holiday pay.
!Scenario 9
''This is the case where the employee only works part-time (FTE<1). The employee is to be paid for the number of hours on their assignment in the Hrs/Day field. Their schedule for the week is two - '8' hour days and one- '4' hour day. The holiday falls on the 1st day, so the employee should only get their maximum of 4 hours for the holiday (not 8).
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Holiday Time code=HOLBANK(IDTC __Adjust Scheduled Time__ toggle is __OFF__) \\Worked Time Code = HOLWORK\\Day Off Time Code = Null
;Setup on IDWR:Holidays Use Sched Hrs=OFF
;Results:0 Hours REG\\4 Hours HOLBANK (Holiday Leave)\\8 hOURS holwork(Replacement for Regular Time)
__Note:__ The HOLBANK time is taken from the employee's assignment HRS/DAY field to cap the number of hours the employee is paid Holiday.
!Scenario 10
''This is the case where a fulltime employee works 40 hrs/week with a schedule of 9 hrs, 9 hrs,m 9hrs, 9hrs and 4 hrs for the week. The holiday falls on the last day worked. The employee should get the daily average of 8 hours for the holiday.''
;Setup on IDHC:Hours Per Day = 8\\OT Factor=Null\\Holiday Time code=HOLBANK(IDTC __Adjust Scheduled Time__ toggle is __OFF__) \\Worked Time Code = HOLWORK\\Day Off Time Code = OFFBANK\\Observed on=Holiday Date
;Setup on IDWR:Holidays Use Sched Hrs=ON
;Results:0 Hours REG\\8 Hours HOLBANK (Holiday Bank for worked days)\\4 Hours HOLWORK (Replacement for regular time).
!Scenario 11
''This is the case where a fulltime employee works 40 hrs/week with a schedule of 9 hrs, 9 hrs,m 9hrs, 9hrs and 4 hrs for the week. The holiday falls on an 'off'day. The employee should get the daily average of 8 hours for the holiday.''
;Setup on IDHC:Hours Per Day = 8\\OT Factor=Null\\Holiday Time code=HOLBANK(IDTC __Adjust Scheduled Time__ toggle is __ON__) \\Worked Time Code = HOLWORK (will not be used on days off)\\Day Off Time Code = OFFBANK\\Observed on=Holiday Date
;Setup on IDWR:Holidays Use Sched Hrs=ON
;Results:0 Hours REG\\8 Hours OFFBANK (Alternate Holiday bank for 'Off'days))\\0 Hours HOLWORK (Replacement for regular time).
----
!!Shift Pattern Time Sheet Examples
Unless stated otherwise, the case is for a fulltime employee who is scheduled to work 8 hour shifts.
!Scenario 12
''This is the case where an employee is scheduled to work the holiday and will need to be paid for the day worked plus the holiday. the employee will get full schedule time for both.
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Holiday Time code=STAT HOL\\Worked Time Code = HOL WORK DAY\\Day Off Time Code = HOL DAY OFF
;Setup on IDWR:Holidays Use Sched Hrs=ON\\PAID HOLIDAY Time Rule - No Time Code specified at Time Rule level. Target Time Code Set targets REG TM and HOL WORK DAY\\WORKED HOLIDAY Time Rule = Time code at Time Rule level is HOL WORK DAY. Target Time Code Set targets REG TM
;Results: -8 Hours REG\\8 Hours STAT HOL\\8 Hours HOL WORK DAY
!Scenario 13
''This is the case where an employee is not scheduled to work the holiday. The employee will need to be given credit for the holiday, even though it falls on an OFF day. IDHC should be set up with a Day Off Time Code specified.''
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Holiday Time code=STAT HOL\\Worked Time Code = HOL WORK DAY\\Day Off Time Code = HOL DAY OFF
;Setup on IDWR:Holidays Use Sched Hrs=ON\\PAID HOLIDAY Time Rule - No Time Code specified at Time Rule level. Target Time Code Set targets REG TM and HOL WORK DAY\\WORKED HOLIDAY Time Rule = Time code at Time Rule level is HOL WORK DAY. Target Time Code Set targets REG TM
;Results: 8 Hours HOL DAY OFF
!Scenario 14
''This is the case where an employee is not scheduled to work the holiday. The employee will need to be given credit for the holiday, even though it falls on an OFF day. IDHC is set up without a Day Off Time Code specified.''
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Holiday Time code=STAT HOL\\Worked Time Code = HOL WORK DAY\\Day Off Time Code = NULL
;Setup on IDWR:Holidays Use Sched Hrs=ON\\PAID HOLIDAY Time Rule - No Time Code specified at Time Rule level. Target Time Code Set targets REG TM and HOL WORK DAY\\WORKED HOLIDAY Time Rule = Time code at Time Rule level is HOL WORK DAY. Target Time Code Set targets REG TM
;Results: 8 Hours STAT HOL
!Scenario 15
''This is the case where an employee is scheduled to work the holiday (7 am - 3 pm) and will need to be paid for the day worked plus the holiday. The holiday time worked will only apply to a portion of the time worked after 12:00 PM.
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Start = 12:00 PM\\Holiday Time code=STAT HOL\\Worked Time Code = HOL WORK DAY\\Day Off Time Code = NULL
;Setup on IDWR:Holidays Use Sched Hrs=ON\\PAID HOLIDAY Time Rule - No Time Code specified at Time Rule level. Target Time Code Set targets REG TM and HOL WORK DAY\\WORKED HOLIDAY Time Rule = Time code at Time Rule level is HOL WORK DAY. Target Time Code Set targets REG TM
;Results: 8 Hours STAT HOL\\12:00 - 3:00 PM = 3 Hrs HOL WORK DAY\\12:00 - 3:00 PM = -3 Hrs REG TM
!Scenario 16
''This is the case where an employee is scheduled to work on a holiday and also applies for holiday overtime for time worked after 5 PM. Shift is 11 am to 7 PM.''
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Start = 5 PM\\Holiday Time code=STAT HOL\\Worked Time Code = HOL WORK DAY\\Day Off Time Code = NULL
;Setup on IDWR:Holidays Use Sched Hrs=ON\\OT HOLIDAY Time Rule - OT Time Code specified at time rule level\\WORKED HOLIDAY Time Rule = Time code at Time Rule level is HOL WORK DAY. Target Time Code Set targets REG TM
;Results: 8 Hours HOL WORK DAY\\-8 Hrs REG TM\\2 Hrs OT Holiday
!Scenario 17
''This is the case where an employee takes a sick leave the day before a holiday and will not be eligible for the holiday paid time.''
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Holiday Time code=STAT HOL\\Worked Time Code = HOL WORK DAY\\Day Off Time Code = NULL
;Setup on IDWR:Holidays Use Sched Hrs=ON\\WORKED HOLIDAY Time Rule = Time code at Time Rule level is HOL WORK DAY. Target Time Code Set targets REG TM\\OFFSET PAID HOLIDAY Time Rule = TC at time fule level is STAT HOL. Target TC Set targets REG TM. Apply TC Set contains the Sick Time Code
;Results: 8 Hours SICK\\-8 Hours STAT HOL
!Scenario 18
''This is the case where the employee is scheduled to be working on the holiday and will need to get 8 hours for the holiday plus they will be paid their full schedule hours for working the day. In this example the employee works a 12 hour shift.''
;Setup on IDHC:Hours Per Day = 8\\OT Factor=Null\\Holiday Time code=STAT HOL\\Worked Time Code = HOL WORK DAY\\Day Off Time Code = NULL
;Setup on IDWR:Holidays Use Sched Hrs=ON\\PAID HOLIDAY Time Rule - No Time Code specified at Time Rule level. Target Time Code Set targets REG TM and HOL WORK DAY\\WORKED HOLIDAY Time Rule = Time code at Time Rule level is HOL WORK DAY. Target Time Code Set targets REG TM and othr work type time codes
;Results: -12 Hours REG\\12 Hours HOL WORK DAY\\8 Hrs STAT HOL
!Scenario 19
''This is the case where the employee only works part-time (FTE<1). The employee works an 8 hour day on the day of the holiday even though they were scheduled for 4 hours. The employee is to be paid for the number of hours he/she worked on the holiday (8), not the number of hours on their assignment in the Hrs/Day field. Their schedule is 8 hours, 8 hours, 8 hours, 4 hours and 4 hours for the week. the holiday falls on the last day.''
;Setup on IDHC:Hours Per Day = Null\\OT Factor=Null\\Holiday Time code=STAT HOL\\Worked Time Code = HOL WORK DAY\\Day Off Time Code = NULL
;Setup on IDWR:Holidays Use Sched Hrs=ON\\PAID HOLIDAY Time Rule - No Time Code specified at Time Rule level. Target Time Code Set targets REG TM and HOL WORK DAY. __Value is set to 1.__\\WORKED HOLIDAY Time Rule = Time code at Time Rule level is HOL WORK DAY. Target Time Code Set targets REG TM and other work type time codes.
;Results: -8 Hours REG TM\\8 Hours STAT HOL\\8 Hours HOL WORK DAY
![Notes|Edit:Internal.TIME_SHEET_HOLIDAY_PROCESSING]
[{InsertPage page='Internal.TIME_SHEET_HOLIDAY_PROCESSING' default='Click to create a new notes page'}]