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 13 changed one line
[{TableOfContents }]
At line 17 changed one line
This is the configuration required for the payroll processing, time collection and capping the earnings maximums based on maximum employee rates. Please see the attached document [here|E-SICK_SAMPLE.pdf.pdf] for a sample E-Sick policy set up on [IALP]
This is the configuration required for the payroll processing, time collection and capping the earnings maximums based on maximum employee rates. Please see the separate document describing a sample E-Sick
At line 44 changed one line
\\
At line 46 changed one line
\\
At line 51 removed one line
\\
At line 53 removed one line
\\
At line 55 removed one line
\\
At line 57 removed one line
\\
At line 59 changed 3 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 63 changed one line
*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 65 changed 7 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.
**Details Available for Download (Screenshots appear later in Document) - [E-SICK_FTE.xlsx].        
*If you code their PT employees with the full-time equivalent of 6 hours, then use the E-SICK UserCalc.
**Details Available for Download (Screenshots appear later in Document) - [E-SICK.xlsx]
\\
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.
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. 
At line 73 removed one line
[{Image src='Figure_01.jpg' width='100%' height='100%' align='left'}]\\
At line 75 removed one line
!!SetUp
At line 77 changed 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
·       
If you code their PT employees with the
full-time equivalent of 6 hours, then use E-Sick UserCalc v20200331. 
At line 83 changed 11 lines
![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 \\
 
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. 
Figure 1: Fulltime Wages Selection Box
\\
 
!!! [|] [|] [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 \\
At line 95 removed 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 99 removed one line
The daily maximum will be applied during UPCALC via the UserCalc.
At line 101 removed one line
Set up the properly GL coding (IDGA/IPPC)  
At line 103 changed 18 lines
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.
\\
![New Leave Type|] ([IAPT])
E-SICK - Minimum leave set up required to set up the payroll calculation\\
\\
![New Statistic Code|] ([IDSC])
PT HRS WK - The value in the statistic when placed on [IEST] will be used as the entitlement amount for the employee rather than the entitlement defined in the plan. This amount must be manually entered into [IEST]\\
\\
[{Image src='Figure_00.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 0: IDSC - PT HRS WK/%\\
\\
\\
![New Attendance UserCalc|] ([IMUC])
||User Calc Code||Purpose
|A260-TEMP SICK|Allows the amount of entitlement to be overridden and replaced by the value of a statistic PT HRS WK
Calculation
Method for E-Sick Taken Care and Child Hrs (PC 458 and 459) hours pay
components = EV X Rate
At line 122 removed 18 lines
%%info A260-TEMP SICK/%\\
[{Image src='A260-TEMP_00.jpg' width='100%' height='100%' align='left'}]\\
[{Image src='A260-TEMP_01.jpg' width='100%' height='100%' align='left'}]\\
\\
![New Leave Policy|] ([IALP])
Leave Policy Code E-SICK - linked to the New Leave Type.\\
\\
%%info __Policy Set Up__/%\\
|Policy Start|01-Apr-2020|
|Frequency| This should be calculated every pay|
|LWOP Time Code| LWOP TAKEN (Or the name of your LWOP time Code being used)|
|Policy Basis|HR|
|Service Time Basis|YR|
|Accrual Begin|Policy Date Method|
|Time Warning Rule|Error, Do not Allow|
|Service Level|9999|
|Entitlement|80|
|Entitlement Cap|80|
At line 141 removed 49 lines
\\
%%info __Leave Policy Components__/%\\
||Seq||AC Code||Component Description||Rule||Rule Description||Value||Action||PC Code||Element||User Calc|
|1|A001|Preprocess/Qualify User Calc|00|Use User Calc Only|-|Store on Accrual|-|-|A001-TEMP SICK|
|50|A050|Prior Year Time Adjustments|01|Allow Time Adjustments|-|Store on Accrual|-|-|-|
|100|A100|Service Length Calculation Method|02|Calculate Based on Service Date|-|Calculate|-|-|-|
|110|A110|Service Date|02|Use Seniority Date|-|Store on Accrual|-|-|-|
|120|A120|Service Length Evaluation Freq|01|Every Time Policy Evaluated (Eval Date)|-|Calculate|-|-|-|
|130|A130|Service Length|02|Replace Service Length|-|Store on Accrual|-|-|-|
|140|A140|Service Length Change|01|Amount of Service Length Change|-|Log to Leave Line|-|-|-|
|200|A200|Entitlement Frequency|01|Give Entitlement Each Evaluation|-|Calculate|-|-|-|
|260|A260|Period Entitlement Method|02|Service Level Entitlement (Prorate by FTE rule)|-|Calculate|-|-|A260-TEMP SICK|
|270|A270|Prorate by FTE Rule|03|Prorate by Employee FTE Value|-|Log to Leave Line|-|-|-|
|290|A290|Current Year Entitlement Time(Before Cap)|01|Increment Time Entitlement|-|Log and Accrue|-|-|-|
|300|A300|Total Time Taken|01|Derive from All Sources|-|Store on Accrual|9955|-|-|
|320|A320|Time Available to Take Before Caps|02|Prior Year Plus Current Year less Taken|-|Store on Accrual|-|-|-|
|330|A330|Current Year Entitlement(Caps Applied)|02|Total Entitlement Limit(Use Annual Entitle Cap)|-|Store on Accrual|-|-|-|
|703|A700|Current Year Time Available|02|Prior Plus Current Year less Taken|-|Log and Accrue|858|-|-|
|1400|A1400|Default Time Code/Pay Component for Leave Entry|01|Pay Component|-|Calculate|457|-|-|
\\
%%info
__The set up of the A001 Component is optional and should only be used if employees need to be further disqualified from the policy. This component requires a pre-processing or qualifying <UserCalc>. The UserCalc must be of the type ‘Function’, with a return value of the type ‘Boolean’. Use the RET operator to return the Boolean value of True or False.
The false value is interpreted by the component as an instruction to exit the leave policy without further processing.__/%
\\
\\
![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)
\\
![New payroll UserCalc|] ([IMUC])
UserCalc named E-SICK or E-SICK FTE
\\
%%info E-Sick UserCalc/%\\
[{Image src='E-SICKa.jpg' width='100%' height='100%' align='left'}]
[{Image src='E-SICKb.jpg' width='100%' height='100%' align='left'}]
[{Image src='E-SICKc.jpg' width='100%' height='100%' align='left'}]
\\ 
At line 191 changed 4 lines
%%info E-Sick FTE UserCalc/%\\
[{Image src='E-SICK_FTEa.jpg' width='100%' height='100%' align='left'}]
[{Image src='E-SICK_FTEb.jpg' width='100%' height='100%' align='left'}]
[{Image src='E-SICK_FTEc.jpg' width='100%' height='100%' align='left'}]
·       
EV = enter value are the hours keyed.
At line 196 removed 19 lines
\\ 
*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 216 removed 6 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.
\\
![UPCALC Exception Messages|]
At line 223 changed 5 lines
__“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. \\
\\
![Sample Configuration|]:
·       
Rate = employee standard rate of pay
At line 229 removed 9 lines
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\\
\\
[{Image src='Figure_02.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 2: IMVR Cared Cap Variable/%\\
\\
[{Image src='Figure_03.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 3: IMVR Care Max/%\\
At line 239 changed 83 lines
\\
[{Image src='Figure_04.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 4: IMVR Sick EED-Cap/%\\
\\
[{Image src='Figure_04.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 5: IMVR EE Max/%\\
\\
\\
__STEP 2: Pay Components__ ([IPPC])\\
\\
7 PCs required in set up\\
\\
__Hint: Set up the Earnings PCs first as they are required for the Hours PCs__\\
\\
[{Image src='Figure_06.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 6: E-Sick $ Pay Component/%\\
\\
[{Image src='Figure_07.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 7: E-Sick Taken Hours Pay Component/%\\
\\
[{Image src='Figure_08.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 8: E-Sick Taken Care $ Pay Component/%\\
\\
[{Image src='Figure_09.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 9: E-Sick Taken Care Hours Pay Component/%\\
\\
[{Image src='Figure_10.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 10: E-Sick Taken Child $ Pay Component/%\\
\\
[{Image src='Figure_11.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 11: E-Sick Taken Child Hours Pay Component/%\\
\\
[{Image src='Figure_12.jpg' width='100%' height='100%' align='left'}]\\
%%info 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.\\
\\
[{Image src='Figure_13.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 13: Define Leave Policy Type/%\\
\\
\\
__STEP 4: Time Codes__ ([IDTC])\\
\\
[{Image src='Figure_14.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 14: E-Sick Entitlement/%\\
\\
[{Image src='Figure_15.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 15: E-Sick Taken/%\\
\\
[{Image src='Figure_16.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 16: E-Sick Taken Care/%\\
\\
[{Image src='Figure_17.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 17: E-Sick Taken Child/%\\
\\
\\
__STEP 5: Set up the UserCalc ([IMUC])__\\
\\
Please see E-Sick Usercalc on top of the form for details\\
\\
[{Image src='Figure_18.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 18: E-Sick UserCalc on IMUC/%\\
\\
\\
__STEP 6: Pay Point IPPP__\\
\\
[{Image src='Figure_19.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 19: Pay Point Type/%\\
\\
\\
__STEP 7: Pay Point IPPP__\\
\\
[{Image src='Figure_20.jpg' width='100%' height='100%' align='left'}]\\
%%info Figure 20: Pay Point Type/%\\
\\
\\
%%success __You have now completed the setup of Emergency Sick Leave__/%
\\
----
![Notes|Edit:Internal.E-SICK]
[{InsertPage page='Internal.E-SICK' default='Click to create a new notes page'}]
The daily maximum will be applied during UPCALC
via the UserCalc.
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
 
__
__
__ __
__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 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?
__ __
__ __
__ __
__ __
__ __
__ __
__ __
__You have now completed the setup for the Temporary Extended
Family and Medical Leave__
This page (revision-11) was last changed on 26-Nov-2021 10:22 by Kevin HiggsTop