This page (revision-11) was last changed on 26-Nov-2021 10:22 by Kevin Higgs

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

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
11 26-Nov-2021 10:22 17 KB Kevin Higgs to previous
10 26-Nov-2021 10:22 13 KB Kevin Higgs to previous | to last
9 26-Nov-2021 10:22 13 KB Kevin Higgs to previous | to last
8 26-Nov-2021 10:22 13 KB Kevin Higgs to previous | to last
7 26-Nov-2021 10:22 13 KB Kevin Higgs to previous | to last
6 26-Nov-2021 10:22 11 KB Kevin Higgs to previous | to last
5 26-Nov-2021 10:22 13 KB Kevin Higgs to previous | to last
4 26-Nov-2021 10:22 13 KB Kevin Higgs to previous | to last
3 26-Nov-2021 10:22 4 KB Kevin Higgs to previous | to last
2 26-Nov-2021 10:22 4 KB Kevin Higgs to previous | to last
1 26-Nov-2021 10:22 4 KB Kevin Higgs to last

Page References

Incoming links Outgoing links
E-SICK
E-SICK

Version management

Difference between version and

At line 44 changed one line
\\
At line 46 changed one line
\\
At line 51 added one line
\\
At line 53 added one line
\\
At line 55 added one line
\\
At line 57 added one line
\\
At line 55 changed 4 lines
Question:for part-time employees, how are their standard hours per day coded on the work assignment? 
There are two approaches in the system:
Question:for part-time employees, how are their standard hours per day coded on the work assignment?  \\
\\
There are two approaches in the system:\\
At line 60 changed 2 lines
 Example 8 hours per day is defined on their work assignment with an FTE of 0.75, full-time equivalent.   The
employee will be paid 6 hours per day. \\
*Example 8 hours per day is defined on their work assignment with an FTE of 0.75, full-time equivalent.The employee will be paid 6 hours per day. \\
At line 63 changed 5 lines
b.  Coded with the reduced hours per day of 6 hours with an FTE of
1.  ·       
If you code the PT with the FT equivalent of 8
hours, then different logic is required to multiple their std hours by the
FTE.  Use the UserCalc E-SICK FTE. 
b.  Coded with the reduced hours per day of 6 hours with an FTE of 1.   
*If you code the PT with the FT equivalent of 8 hours, then different logic is required to multiple their std hours by the FTE. Use the UserCalc E-SICK FTE.        
*If you code their PT employees with the full-time equivalent of 6 hours, then use E-Sick UserCalc v20200331.  \\
If you are unsure, select a part-time employee and go the work assignment screen (IEAS), Compensation Tab.  If the Fulltime Wage toggle is turned on, then use the E-SICK FTE UserCalc. 
At line 69 removed 28 lines
·       
If you code their PT employees with the
full-time equivalent of 6 hours, then use E-Sick UserCalc v20200331. 
 
If you are unsure, select a part-time employee and go the
work assignment screen (IEAS), Compensation Tab.  If the Fulltime Wage toggle is turned on,
then use the E-SICK FTE UserCalc. 
At line 99 removed one line
At line 73 added one line
!!SetUp
At line 75 added 5 lines
![New User Variables|] ([IMVR])
*E-SICK EE D-CAP for the Employee e-sick pay daily maximum of $511
*E-SICK EE MAX for the Employee e-sick aggregate maximum of $5110
*E-SICK Care D-CAP for the care of others daily maximum of $200
*E-SICK Care Max aggregate maximum of $2,000
At line 103 changed 88 lines
 
!!! [|] [|] [Set
Up|]
IMVR new
User Variables
·       
E-SICK EE D-CAP for the Employee e-sick pay
daily maximum of $511
·       
E-SICK EE MAX for the Employee e-sick aggregate
maximum of $5110
·       
E-SICK Care D-CAP for the care of others daily
maximum of $200
·       
E-SICK Care Max aggregate maximum of $2,000
IPPC new pay
components – clients can use their own coding and naming conventions.  Be sure to change the pay components on the
UserCalc to your codes.   
[·       
E-Sick Taken Hrs (PC 457)|]
·       
E-Sick Taken $ (PC 1457)
·       
E-Sick Taken Care (458)
·       
E-Sick Tkn Care $ (1458)
·       
E-Sick Tkn Child (459)
·       
E-Sick Tkn Child $ (1459)
Calculation
Method for E-Sick Taken Hrs (PC 457) hours pay components = EV X Rate
·       
EV = enter value are the hours keyed.
·       
Rate = employee standard rate of pay \\
![New Pay Components|] ([IPPC])
Clients can use their own coding and naming conventions.  Be sure to change the pay components on the UserCalc to your codes.   
*E-Sick Taken Hrs (PC 457)
*E-Sick Taken $ (PC 1457)     
*E-Sick Taken Care (458)
*E-Sick Tkn Care $ (1458)
*E-Sick Tkn Child (459)
*E-Sick Tkn Child $ (1459)
\\Calculation Method for E-Sick Taken Hrs (PC 457) hours pay components = EV X Rate
* EV = enter value are the hours keyed.
* Rate = employee standard rate of pay \\
At line 93 added 3 lines
\\Calculation Method for E-Sick Taken Care and Child Hrs (PC 458 and 459) hours pay components = EV X Rate      
*EV = enter value are the hours keyed.      
*Rate = employee standard rate of pay
At line 97 added one line
The daily maximum will be applied during UPCALC via the UserCalc.
At line 99 added one line
Set up the properly GL coding (IDGA/IPPC)  
At line 195 changed 3 lines
Calculation
Method for E-Sick Taken Care and Child Hrs (PC 458 and 459) hours pay
components = EV X Rate
Update all required elements.
*Hint: Run the RPPE report and search for Sick Leave Earnings.       
*Be sure to update your pay stub elements to report on the employee’s pay advice. 
*Do not include the earnings into FICA-ER elements as these earnings are not subject to employer portion of FICA.
At line 106 added 2 lines
![New Leave Type|] ([IAPT])
E-SICK (Minimum leave set up required to set up the payroll calculation)
At line 109 added 15 lines
![New Time Codes|] ([IDTC])     
*E-Sick Ent – Type of Leave Entitlement, tied back to PC 857
*E-Sick Tkn – Type of Leave, tied back to PC 457,leave type = E-Sick
*E-Sick Tkn Care - Type of Leave, tied back to PC 458, leave type = E-Sick
*E-Sick Tkn Child - Type of Leave, tied back to PC 459, leave type = E-Sick
\\
Once the time codes are entered, go back to the pay components and update the associated time codes. \\
\\
Add the time codes to the Work Rules as authorized time codes.\\ 
\\
Add a new element E-SICK (used in the UserCalc – IPPE)           
*Add the hours taken pay components.
**E-Sick Taken Hrs (PC 457)
**E-Sick Taken Care (458)
**E-Sick Taken Child (459)
At line 201 changed 2 lines
·       
EV = enter value are the hours keyed.
![New payroll UserCalc|] ([IMUC])
*UserCalc named E-SICK or E-SICK FTE
*Please the E-Sick UserCalc ''date''.xlxs or E-Sick UserCalc FTE ''date''.xlxs for details and description.
*Applies the daily maximums rates and the program maximums.
*Recalculates the earnings based on the capped rate.
*A Payroll UserCalc is required as there are no PC’s rules apply this type of maximum. 
*Before adding the UserCalc lines, please set up the UserCalc variables (E-SICK Variables tab in the spreadsheet)  
**Qualification – UserCa
***Only execute the UserCalc if the employee has e-sick hours by checking the E-SICK element for a value.
***The second qualification really should not be required. Check the YTD hours taken (E-SICK element) is greater/equal to 80 then issue a message and exit. 
***The time entry should capture the LWOP once the employee exceeds their 80 hour entitlement.
**Calculate the two capped and daily rates (lines 100)
***Move the employee’s regular work assignment daily rate to variable REG DAILY RATE
***Move the lessor of the reduce daily rate or $200 into variable DAILY RATE CARE
***Move the lessor of the daily rate or $511 into variable DAILY RATE CARE
**Calculate the employee’s aggregate maximum
***This section is not required since the time entry will cap at 80 hours
**At this point in the UserCalc, we have the current rates capped/reduced to be paid to the employee.  Calculate the earnings and populate the earnings PC’s.
***Multiple HRLY RATE SELF X number of hours in PC 457 and replace PC 1457
***Multiple HRLY RATE CARE X number of hours in PC 458 and replace PC 1458
***Multiple HRLY RATE CARE X number of hours in PC 459 and replace PC 1459
At line 147 added 4 lines
![Update Pay Point|] ([IPPP])
*Add the UserCalc to your Pay Point sets. 
*The example below shows Pay Point Type of 50 on the Regular Pay set.  It can be at any Type before legislative tax calculation.
*Be sure to add it to each required Pay Point Set.
At line 152 added one line
!![UPCALC Exception Messages|]
At line 206 changed 2 lines
·       
Rate = employee standard rate of pay
__“E-SICK - employee has reached maximum of 80 hours.  Please verify pay”.__\\
\\Action Required – the employee should never have 80 hours in pay history with current hours in the payroll. 
\\Investigation required on how time was entered for E-Sick.
At line 158 added one line
!![Configuration|]
At line 160 added 3 lines
Sample Configuration: \\
\\
Please note this is not the complete set up required.  For example, the Pay Component GL (Acct/Arrears tab) needs to be configured but is not included in these samples. 
At line 211 changed 2 lines
The daily maximum will be applied during UPCALC
via the UserCalc.
__STEP 1:__ User Variables (IMVR) set up the User Variables
At line 214 changed 331 lines
Set up the
properly GL coding (IDGA/IPPC)  
Update all
required elements.
·       
Hint: Run the RPPE report and search for Sick
Leave Earnings.
·       
Be sure to update your pay stub elements to
report on the employee’s pay advice. 
·       
Do not include the earnings into FICA-ER
elements as these earnings are not subject to employer portion of FICA.
IAPT New
Leave Type E-SICK (Minimum leave set up required to set up the payroll
calculation)
IDTC New
Time Codes
·       
E-Sick Ent – Type of Leave Entitlement, tied
back to PC 857
·       
E-Sick Tkn – Type of Leave, tied back to PC 457,
leave type = E-Sick
·       
E-Sick Tkn Care - Type of Leave, tied back to PC
458, leave type = E-Sick
·       
E-Sick Tkn Child - Type of Leave, tied back to
PC 459, leave type = E-Sick
Once the time codes are entered, go back to the pay
components and update the associated time codes. 
Add the time codes to the Work Rules as authorized time
codes. 
Add a new element E-SICK (used in
the UserCalc – IPPE)   
·       
Add the hours taken pay components.
o  
E-Sick Taken Hrs (PC 457)
o  
E-Sick Taken Care (458)
o  
E-Sick Taken Child (459)
IMUC – a new
payroll UserCalc named E-SICK or E-SICK FTE
·       
Please the E-Sick UserCalc ''date''.xlxs or E-Sick
UserCalc FTE ''date''.xlxs for details and description.
·       
Applies the daily maximums rates and the program
maximums.
·       
Recalculates the earnings based on the capped
rate.
·       
A Payroll UserCalc is required as there are no
PC’s rules apply this type of maximum. 
·       
Before adding the UserCalc lines, please set up
the UserCalc variables (E-SICK Variables tab in the spreadsheet)  
o   Qualification
– UserCalc lines < 100
§  Only
execute the UserCalc if the employee has e-sick hours by checking the E-SICK
element for a value.
§  The
second qualification really should not be required.   Check the YTD hours taken (E-SICK element)
is greater/equal to 80 then issue a message and exit. 
§  The
time entry should capture the LWOP once the employee exceeds their 80 hour
entitlement.
o   Calculate
the two capped and daily rates (lines 100)
§  Move
the employee’s regular work assignment daily rate to variable REG DAILY RATE
§  Move
the lessor of the reduce daily rate or $200 into variable DAILY RATE CARE
§  Move
the lessor of the daily rate or $511 into variable DAILY RATE CARE
o   Calculate
the employee’s aggregate maximum
§  This
section is not required since the time entry will cap at 80 hours
o  
At this point in the UserCalc, we have the
current rates capped/reduced to be paid to the employee.  Calculate the earnings and populate the
earnings PC’s.
§ 
Multiple HRLY RATE SELF X number of hours in PC
457 and replace PC 1457
§ 
Multiple HRLY RATE CARE X number of hours in PC
458 and replace PC 1458
§ 
Multiple HRLY RATE CARE X number of hours in PC
459 and replace PC 1459
Pay Point
IPPP
·       
Add the UserCalc to your Pay Point sets. 
·       
The example below shows Pay Point Type of 50 on
the Regular Pay set.  It can be at any
Type before legislative tax calculation.
·       
Be sure to add it to each required Pay Point
Set.
!!! [|] [|] [UPCALC
Exception Messages|]
[|] [1.   
“E-SICK - employee has reached maximum of 80
hours.  Please verify pay”.  |]
Action Required – the employee should never
have 80 hours in pay history with current hours in the payroll.  Investigation required on how time was
entered for E-Sick. [|] [|]
!!! [Configuration|]
Sample Configuration:
Please note this is not the complete set up required.  For example, the Pay Component GL
(Acct/Arrears tab) needs to be configured but is not included in these
samples. 
__STEP 1:__ User Variables (IMVR) set up
the User Variables
Figure 2: IMVR Cared Cap Variable
Figure 3: IMVR Care Max0
Figure 4: IMVR Sick EED-Cap
Figure 5: IMVR EE Max
 
Figure 2: IMVR Cared Cap Variable\\
\\
Figure 3: IMVR Care Max0\\
\\
Figure 4: IMVR Sick EED-Cap\\
\\
Figure 5: IMVR EE Max\\
\\
At line 547 removed 2 lines
At line 551 changed 204 lines
__STEP 2:__ Pay Components – 7 PCs
required (IPPC)
Hint: Setting up the Earnings PCs first as
they are required for the Hours PCs
Figure 6: E-Sick $ Pay Component
Figure 7: E-Sick Taken Hours Pay
Component
Figure 8: E-Sick Taken Care $ Pay
Component
Figure 9: E-Sick Taken Care Hours Pay
Component
Figure 10: E-Sick Taken Child $ Pay
Component
Figure 11: E-Sick Taken Child Hours Pay
Component
Figure 12: E-Sick Hours Balance Pay
Code
 
__STEP
3:__ Leave Policy (IAPT)
Use the next available leave policy type. It does not have
to be 182 as shown below.
Figure 13: Define Leave Policy Type
 
__STEP 4:__ 4 Time Codes (IDTC)
Figure 14: E-Sick Entitlement
Figure 15: E-Sick Taken
Figure 16: E-Sick Taken Care
Figure 17: E-Sick Taken Child
__STEP 2:__ Pay Components – 7 PCs required (IPPC)\\
Hint: Setting up the Earnings PCs first as they are required for the Hours PCs\\
\\
Figure 6: E-Sick $ Pay Component\\
\\
Figure 7: E-Sick Taken Hours Pay Component\\
\\
Figure 8: E-Sick Taken Care $ Pay Component\\
\\
Figure 9: E-Sick Taken Care Hours Pay Component\\
\\
Figure 10: E-Sick Taken Child $ Pay Component\\
\\
Figure 11: E-Sick Taken Child Hours Pay Component\\
\\
Figure 12: E-Sick Hours Balance Pay Code\\
__
__
At line 756 changed 65 lines
__STEP 5__: Set up the UserCalc on IMUC
Please see the UserCalc Spreadsheet for details
Figure 18: E-Sick UserCalc on IMUC
 
__STEP 6:__ Pay Point IPPP
Figure 19: Pay Point Type
__STEP 7:__ Pay Point IPPP
Figure 20: Dud Image?
\\__STEP 3:__ Leave Policy (IAPT)\\
Use the next available leave policy type. It does not have to be 182 as shown below.
\\
Figure 13: Define Leave Policy Type\\
\\
__
__
At line 822 changed 3 lines
\\
__STEP 4:__ 4 Time Codes (IDTC)\\
\\
Figure 14: E-Sick Entitlement\\
\\
Figure 15: E-Sick Taken\\
\\
Figure 16: E-Sick Taken Care\\
\\
Figure 17: E-Sick Taken Child\\
__
__
At line 826 changed 3 lines
\\
__STEP 5__: Set up the UserCalc on IMUC\\
\\
Please see the UserCalc Spreadsheet for details\\
\\
Figure 18: E-Sick UserCalc on IMUC\\
__
__
At line 830 changed 3 lines
\\__STEP 6:__ Pay Point IPPP\\
\\
Figure 19: Pay Point Type\\
__
__
At line 834 changed 3 lines
\\__STEP 7:__Pay Point IPPP\\
\\
__
__
At line 838 changed 13 lines
__ __
__ __
__You have now completed the setup for the Temporary Extended
Family and Medical Leave__
Figure 20: Dud Image?\\
This page (revision-11) was last changed on 26-Nov-2021 10:22 by Kevin HiggsTop