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

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
23 26-Nov-2021 10:22 13 KB jmyers to previous
22 26-Nov-2021 10:22 14 KB jmyers to previous | to last
21 26-Nov-2021 10:22 14 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
UPCALC WORKERS COMPENSATION PROCESSING
UPCALC WORKERS COMPENSATION PROCESSING

Version management

Difference between version and

At line 124 added one line
!!WC Calculation
At line 125 changed one line
!UPCALC WC Processing
At line 128 added one line
The following WC Methods are supported for WC Calculation:
At line 128 changed one line
|01|Work State/Prov IPWC Class (used for Canada and US)\\ \\The IPPH Work State will be used to retrieve the IPWC Class
|02|US Symmetry Taxation (US only)\\ \\WC will be calculated in UPCALC by US Symmetry Taxation only, IPWC is not used
|03|Work State IPWC & US Taxation (US only)\\ \\Both Method 01 and 02 will be used for WC calculation
|11|Res State/Prov IPWC Class (used for Canada and US)\\ \\The IPPH Residence State will be used to retrieve the IPWC Class
|13|Res State IPWC & US Taxation (US only)\\ \\Both Method 11 and 02 will be used for WC calculation
|99|Do Not Calculate
At line 137 added one line
WC Method is first taken from the Pay Category of each pay. If Pay Category WC Method does not exist, then the Payrule WC Method is used. If Payrule WC Method does not exist, then the IPWC WC Method of the Work Province is used.
At line 139 added one line
If any of the Pay Category, Payrule or IPWC WC Method = 99, WC will not be calculated. Thus user can suppress WC calculation at any level.
At line 141 added 56 lines
According to the WC Method, UPCALC determines if the Pay Header’s Work or Residence State/Province to be used to load the IPWC WC Class for WC calculation.
In UPCALC, each Pay Line’s Pay Component is checked against the IPWC Element. If the Pay Component is included in IPWC Element, then this Pay Line’s Earnings is considered as WC assessable earnings and will be accumulated by WC Class.
The WC Class is retrieved for each Pay Line and accumulated. The WC Class is first taken from the Pay Line if it exists. If WC Class does not exist, UPCALC uses the Pay Line Assignment to retrieve IEAS WC Class. If WC Class does not exist, then uses the Pay Line Position to retrieve IDPS WC Class. If WC Class does not exist, then uses the Pay Line Job to retrieve IDJB Job WC Class.
For internal amounts that are not from Pay Line (i.e. Usercalc, benefit amounts etc), the employee’s prime Assignment is used to retrieve the WC Class. Most likely, there will be only one class per pay, but UPCALC handles more than one WC Class per pay. If more than one class is found, and the ‘WC Maximum’ happens to be different in the WC Classes, then the highest WC Maximum is used
UPCALC then retrieves the YTD WC assessable earnings by IPWC Element for the Work or Residence State/Province according to the WC Method.
If YTD WC assessable earnings exceeds the highest WC annual maximum assessable earnings, then WC premium will not be calculated for that class. The excess earnings will be stored by Class for WC reporting purposes
!UPCALC WC Calculation
Calculate Total WC assessable earnings
= Current WC assessable earnings + YTD WC assessable earnings and capped at the Highest WC Maximum Earnings from eligible WC Classes of all Pay Lines
Calculate Current pay WC Premium contribution (by WC Class)
= Current WC assessable earnings * WC rate on IPWC screen for each Class and accumulate
The following PC Usages are used for WC Calculation:
|7003|Work WC Earnings
|7004|Work WC Premium
|7005|Work WC Excess Earnings
|7009|Res WC Earnings
|7010|Res WC Premium
|7011|Res WC Excess Earnings
If WC Method is by Work State/Province, store the WC Results into Work WC Pay Components:
*Store Current pay’s WC contribution in pay component with usage = 7003
*Store Current pay’s WC contribution in Pay Line Detail by WC Class for WC Report
*Store Current pay’s WC earnings in pay component with usage = 7004
*Store Current pay’s WC earnings in Pay Line Detail by WC Class for WC Report.
*Store Current pay’s WC Excess earnings in pay component with usage = 7005
*Store Current pay’s WC Excess earnings in Pay Line Detail by WC Class for WC Report.
If WC Method is by Residence, store the WC Results into Residence WC Pay Components:
*Store Current pay’s WC contribution in pay component with usage = 7009
*Store Current pay’s WC contribution in Pay Line Detail by WC Class for WC Report
*Store Current pay’s WC earnings in pay component with usage = 7010
*Store Current pay’s WC earnings in Pay Line Detail by WC Class for WC Report.
*Store Current pay’s WC Excess earnings in pay component with usage = 7011
*Store Current pay’s WC Excess earnings in Pay Line Detail by WC Class for WC Report.
!Trial Calc - WC Sample
When employee lives in Ontario and works in BC, if the Res WC is to be calculated, then the Res WC pay components are used.
This page (revision-23) was last changed on 26-Nov-2021 10:22 by jmyersTop