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

Version management

Difference between version and

At line 7 changed one line
Employers pay WCB assessments every year based on their employees' earnings and on the type of industry they are in. The employers are required to remit the WCB assessments contribution to the Workers' Compensation Board on a timely basis, therefore employers must calculate their WCB contribution while the employees are being paid.
Employers pay WCB assessments every year based on their employees’ earnings and on the type of industry they are in. The employers are required to remit the WCB assessments contribution to the Workers' Compensation Board on a timely basis, therefore employers must calculate their WCB contribution while the employees are being paid.
At line 13 changed one line
!IMLN - Lexicons
!IMLN – Lexicons
At line 16 changed 13 lines
;IMLN - X_WCB_CLASS:[X_WCB_CLASS] stores the names of the particular WC classes needed by the system. WC rates can vary by WC class of workers and the names of these classes are provided by the Workers' Compensation Board.\\ \\Users needs to maintain their own WC Class on this screen.
;IMLN - X_WC_REGIST_TYPE:[X_WC_REGIST_TYPE] is used by the [IPWC] and [IDGR] screens to allow for the set up of one or multiple WC Registration Numbers that are assigned by the Workers' Compensation Board.
|0100 |Not Specified|If within the [IDGR] screen, under the Registration tab, the WC Regist Type field is set to "0100", WC will not be calculated for this group
|0101|WC Regist 1|On the [IPWC] screen, enter the first WC Registration Number as "WC Regist 1".\\On the [IDGR] screen, under the Registration tab, a group can use the [IPWC] "WC Regist 1" set up.
|0102|WC Regist 2|This registration type is the same as 0101 and is to be used for the second WC Registration Number.
|0103|WC Regist 3|This registration type is the same as 0101 and is to be used for the third WC Registration Number.
|0104|WC Regist 4|This registration type is the same as 0101 and is to be used for the, use for fourth WC Registration Number.
|0105|WC Regist 5|This registration type is the same as 0101 and is to be used for the fifth WC Registration Number.
|0106|WC Regist 6|This registration type is the same as 0101 and is to be used for the sixth WC Registration Number.
|0107|WC Regist 7|This registration type is the same as 0101 and is to be used for the seventh WC Registration Number.
|0108|WC Regist 8|This registration type is the same as 0101 and is to be used for the eighth WC Registration Number.
|0109|WC Regist 9|This registration type is the same as 0101 and is to be used for the ninth WC Registration Number
|0190|Multiple WC Regist #|This '0190' lexicon value should only be used by the [IDGR] 'WC Regist Type' field.\\[IPWC] must __not__ use this lexicon value.\\Please read [IDGR Group set up|UPCALC WORKERS COMPENSATION PROCESSING#section-UPCALC+WORKERS+COMPENSATION+PROCESSING-IDGRDefineGroupsWCRegistType] below for more detail.
;IMLN – X_WCB_CLASS:[X_WCB_CLASS] stores the names of the particular WC classes needed by the system. WC rates can vary by WC class of workers and the names of these classes are provided by the Workers' Compensation Board.\\ \\Users needs to maintain their own WC Class on this screen.
;IMLN – X_WC_REGIST_TYPE:[X_WC_REGIST_TYPE] is used by the [IPWC] and [IDGR] screens to allow for one or multiple WC Registration Numbers that are assigned by the Workers' Compensation Board to be set up.
|0100 |Not Specified|if the [IDGR] screen WC Regist Type =‘0100’, WC will not be calculated for this group
|0101|WC Regist 1|On IPWC screen, enter the first WC Registration Number using ‘WC Regist 1’\\on IDGR Registration tab, a group can use IPWC ‘WC Regist 1’ set up
|0102|WC Regist 2|same as 0101, use for second WC Registration Number
|0103|WC Regist 3|same as 0101, use for third WC Registration Number
|0104|WC Regist 4|same as 0101, use for 4th WC Registration Number
|0105|WC Regist 5|same as 0101, use for 5th WC Registration Number
|0106|WC Regist 6|same as 0101, use for 6th WC Registration Number
|0107|WC Regist 7|same as 0101, use for 7th WC Registration Number
|0108|WC Regist 8|same as 0101, use for 8th WC Registration Number
|0109|WC Regist 9|same as 0101, use for 9th WC Registration Number
|0190|Multiple WC Regist #| this ‘0190’ lexicon value should only be used by IDGR ‘WC Regist Type’\\IPWC must not use this ‘0190 – Multiple WC Regist #’\\please read IDGR Group set up below for more detail
At line 30 changed 3 lines
;IMLN - X_CPRV_WCB_METHOD:[X_CPRV_WCB_METHOD] is used for Canadian Workers' Compensation calculation and are used by the following screens: [IPRLC], [IPPGC]
|01|Work State/Prov IPWC Class|The [IPPH] Work State/Province will be used to retrieve the [IPWC] Class
|11|Res State/Prov IPWC Class|The [IPPH] Residence State/Province will be used to retrieve the [IPWC] Class
;IMLN – X_CPRV_WCB_METHOD:X_CPRV_WCB_METHOD is used for Canadian Workmen’s Compensation calculation and are used by the following screens: IPRLC, IPPGC
|01|Work State/Prov IPWC Class|The IPPH Work State / Province will be used to retrieve the IPWC Class
|11|Res State/Prov IPWC Class|The IPPH Residence State / Province will be used to retrieve the IPWC Class
At line 35 changed 6 lines
;IMLN - X_UST_WCB_METHOD:[X_UST_WCB_METHOD] is used for US Workers' Compensation calculation and by the following screens: [IPRLU], [IPPGU] and [IPWC].
|01|Work State/Prov IPWC Class|The [IPPH] Work State field will be used to retrieve the [IPWC] class.
|02|US Symmetry Taxation|WC will be calculated in [UPCALC] by US Symmetry Taxation only; [IPWC] is not used.
|03|Work State IPWC & US Taxation|Both Method 01 and 02 will be used for WC calculation.
|11|Res State/Prov IPWC Class|The IPPH Residence State will be used to retrieve the [IPWC] class.
|13|Res State IPWC & US Taxation|Both Method 11 and 02 will be used for WC calculation.
;IMLN – X_UST_WCB_METHOD:X_UST_WCB_METHOD is used for US Workmen’s Compensation calculation and are used by the following screens: IPRLU, IPPGU and IPWC
|01|Work State/Prov IPWC Class|The IPPH Work State will be used to retrieve the IPWC Class
|02|US Symmetry Taxation|WC will be calculated in UPCALC by US Symmetry Taxation only, IPWC is not used
|03|Work State IPWC & US Taxation|both Method 01 and 02 will be used for WC calculation
|11|Res State/Prov IPWC Class|the IPPH Residence State will be used to retrieve the IPWC Class
|13|Res State IPWC & US Taxation|Both Method 11 and 02 will be used for WC calculation
At line 45 changed one line
!IPPC - WC Pay Components
!IPPC – WC Pay Components
At line 54 changed 2 lines
WC premiums are generally based on the state/province where the employee is physically at work.
Pay Components must be set up on the [IPPC] screen for Usage: 7003, 7004, 7005 for WC Calculation.
WC premiums are generally based on the State / Province where the employee is physically at work.
Users must set up Pay Components on IPPC screen for Usage: 7003, 7004, 7005 for WC Calculation.
At line 57 changed 2 lines
For employees who reside in one state/province and physically at work in different state/province, the State/Province may require to calculate WC according to the Residence State/Province.
Pay Components may be set up on the [IPPC] screen for WC Usage: 7009, 7010, 7011.
For employees who reside in one State / Province and physically at work in different State / Province, the State / Province may require to calculate WC according to the Residence State / Province.
Users may set up Pay Components on IPPC screen for WC Usage: 7009, 7010, 7011.
At line 60 changed one line
The Element on the [IPPC] screen does not need to be set up because the WC Element is defined on [IPWC].
Users do not need to set up Element on IPPC screen because WC Element are defined on IPWC.
At line 62 changed one line
!IPPP - Define Pay Points for WC
!IPPP – Define Pay Points for WC
At line 64 changed one line
[IPPP] must have the Pay Point Task field set to "Workers' Compensation" for any Pay Point Sets that require WC calculation.
IPPP must specify the Pay Point Task with ‘Workers Compensation’ for any Pay Point Sets that require WC calculation.
At line 66 changed one line
!IPWC - Maintain WC Rates
!IPWC – Maintain WC Rates
At line 68 changed one line
For each State/Province, each WC Class must be set up with the associated Maximum Amount and Rates.
For each State / Province, user must set up each WC Class with the associated Maximum and Rates.
At line 71 changed 3 lines
;WC Regist Type:Specifies 'WC Regist 1' up to 'WC Regist 9'\\You may have multiple WC Registration numbers from Workers' Compensation Board, which are to be used on the [IDGR] Registration tab.\\The Pay Header's Group is used to retrieve the [IDGR] WC Regist Type and therefore to retrieve the [IPWC] WC Regist Type entry.
;Element:Specifies the element to be used for the WC calculation of this State/Province.
;WC Method:Specifies the default WC method for this State/Province.\\The [IPWC] WC Method will be superimposed by the employee's Payrule WC Method from the [IPRLC]/[IPRLU] screen or overridden by the Pay Category of each pay from the [IPPGC]/[IPPGU] screen.\\If on the [IPWC] screen, the WC Method field is set to '99 - Do not calculate', the employee's Pay Rule will be overridden and the Pay Category WC Method, WC will not be calculated.
;WC Regist Type:Specifies ‘WC Regist 1’ up to ‘WC Regist 9’\\You may have multiple WC Registration numbers from Worker’s Compensation Board, this is to be used on IDGR Registration Tab\\The Pay Header’s Group is used to retrieve the IDGR WC Regist Type and therefore to retrieve IPWC WC Regist Type entry
;Element:specifies the Element to be used for WC calculation of this State/Province
;WC Method:specifies the default WC method for this State/Province\\IPWC WC Method will be superimposed by employee’s Payrule WC Method from IPRLC / IPRLU screen or overridden by the Pay Category of each pay from IPPGC / IPPGU screen\\If IPWC WC Method = ’99 – Do not calculate’, this overrides employee’s Payrule and the Pay Category WC Method, WC will not be calculated
At line 75 changed one line
!IDGR - Define Groups WC Regist Type
!IDGR – Define Groups WC Regist Type
At line 77 changed 6 lines
The Pay Header's Group is used to retrieve 'WC Regist Type' from IDGR in order to locate the [IPWC] entry to be used for WC Calculation.
*The [IDGR] WC Regist Type field can be set up according to [IMLN] [X_WC_REGIST_TYPE].
*If the [IDGR] WC Regist Type field is set to 'Multiple WC Regist #', it means all the [IPWC] Regist 1 to Regist 9 entries are to be used by this group with the same State/Province in order to look for a match for the WC Class of each pay line.
*This allows each group to use either single or multiple WC Registration Numbers.
*If 'Multiple WC Regist #' is used by any group, then each WC Class must be unique on [IPWC] for the 'WC Regist 1' to 'WC Regist 9' set up.
*If the same WC Class is defined more than once with 'WC Regist 1' to 'WC Regist 9', then the first entry of this WC Class under any 'WC Regist n' will be used.\\ \\
The Pay Header’s Group is used to retrieve the IDGR ‘WC Regist Type’ in order to locate the IPWC entry to be used for WC Calculation.
*IDGR WC Regist Type can be set up according to IMLN X_WC_REGIST_TYPE
*if IDGR WC Regist Type = ‘Multiple WC Regist #’, this means that all IPWC Regist 1 to Regist 9 entries are to be used by this Group with the same State/Province in order to look for a match for the WC Class of each Pay Line
* this allows each Group to use Multiple WC Registration Numbers or just one WC Registration Number
*if ‘Multiple WC Regist #’ is used by any group, then each WC Class must be unique on IPWC for ‘WC Regist 1’ to ‘WC Regist 9’ set up
*if the same WC Class is defined more than once with ‘WC Regist 1’ to ‘WC Regist 9’, then the first entry of this WC Class under any ‘WC Regist n’ will be used.\\ \\
At line 84 changed 6 lines
Group: 'FULL TIME' can report to 'WC Regist 1' and 'WC Regist 2', there are two set up options:
#Set up two groups, 'FULL TIME 1' and 'FULL TIME 2'
#*On [IDGR], use 'WC Regist 1' and 'WC Regist 2' for each group.
#Set up one group, 'FULL TIME'
#*On [IDGR], use 'Multiple WC Regist #' for this group.
#*On [IPWC], enter 'WC Regist 1' and 'WC Regist 2', then ensure that [IPWC] Class is unique under each 'WC Regist n' set up.
Group: ‘FULL TIME’ can report to ‘WC Regist 1’ and ‘WC Regist 2’, users have 2 options to set up:
#Set up two Groups, ‘FULL TIME 1’ and ‘FULL TIME 2’
#*on IDGR for each group, use ‘WC Regist 1’ and ‘WC Regist 2’
#Set up one Group, ‘FULL TIME’
#*on IDGR for this group, use ‘Multiple WC Regist #’
#*on IPWC, enter ‘WC Regist 1’ and ‘WC Regist 2’ entries, then ensure the IPWC Class are unique under each ‘WC Regist n’ set up
At line 91 changed one line
!IPRLC / IPRLU - Payrule WC Method
!IPRLC / IPRLU – Payrule WC Method
At line 93 changed one line
Most employees do not require a [IPRLC]/[IPRLU] set up, except to enter an overridden WC method or to suppress the WC calculation to "99 - Do not calculate". If [IPRLC]/[IPRLU] WC Method is not set up, the [IPWC] WC Method will be used according to the Pay Header's State/Province.
Most employees do not require to set up IPRLC / IPRLU except to enter an overridden WC method or to suppress the WC calculation to ’99 – Do not calculate’. If IPRLC / IPRLU WC Method is not set up, the IPWC WC Method will be used according to Pay Header’s State/Province.
At line 95 changed one line
In Canada, an employee may specify an overridden 'Prov WC Method'.
In Canada, an employee may specify an overridden ‘Prov WC Method’.
At line 97 changed one line
In US, an employee may specify an overridden 'WC Method'.
In US, an employee may specify an overridden ‘WC Method’.
At line 99 changed one line
!IPPGC / IPPGU - Pay Category WC Override
!IPPGC / IPPGU – Pay Category WC Override
At line 101 changed one line
In Canada, each pay category may specify an overridden 'Prov WC Method'. [IPPGC] WC Method overrides the [IPRLC] WC Method, which also overrides the [IPWC] WC Method of each province.
In Canada, each Pay Category may specify an overridden ‘Prov WC Method’. IPPGC WC Method overrides the IPRLC WC Method, which also overrides the IPWC WC Method of each Province.
At line 103 changed one line
In the US, each pay category may specify an overridden 'STATE WC Method'. [IPPGU] WC Method overrides the [IPRLU] WC Method, which also overrides the [IPWC] WC Method of each State.
In US, each Pay Category may specify an overridden ‘STATE WC Method’. IPPGU WC Method overrides the IPRLU WC Method, which also overrides the IPWC WC Method of each State.
At line 107 changed one line
On the [IPWC] screen, the 'WC Class' of an employee is significant in determining the WC rates to be used in the calculation of the WC premium. WC Class can be assigned by position, job or employee. [UPCALC] looks first at the employee's assignment WC Class from [IEAS], then the position WC Class from [IDPS], then the job WC Class from [IDJB].
On IPWC screen, the ‘WC Class’ of an employee is significant in determining the WC rates to be used in the calculation of the WC premium. WC Class can be assigned by Position, Job or Employee. UPCALC looks first at the Employee IEAS WC Class, then the Position IDPS WC Class, then the Job IDJB WC Class. User can also override the WC Class at the Pay Line Level.
At line 109 changed one line
The WC Class can also be overridden at the Pay Line level. WC calculations are performed based on the individual pay lines on assessed pays. If WC Class is overridden at the Pay Line level, then this WC Class is used, otherwise, the pay line's assignment is used to retrieve the Assignment WC Class. If WC Class does not exist on the assignment, then the position associated with the assignment is used to retrieve the Position WC Class. If the Position WC Class is not defined, then the job associated with the assignment is used to retrieve the Job WC Class.
!IDJB – Job WC Class
Each Job may specify a WC Class.
At line 113 added 9 lines
!IDPS – Position WC Class
Each Position may optionally specify a WC Class.
!IEAS – Assignment WC Class
Each employee’s Assignment may optionally specify a WC Class.
!IPPH – Pay Line WC Class
The WC Class can be overridden at Pay Line Transaction level. WC calculations are performed based on the individual Pay Lines on Pays assessed. If WC Class is overridden at the Pay Line level, then this WC Class is used, otherwise, the Assignment of this Pay Line is used to retrieve the WC Class from the Assignment. If WC Class does not exist on the Assignment, then the Position of the Assignment is used to retrieve the Position WC Class. If the Position WC Class is not defined, then the Job of the Assignment is used to retrieve the Job WC Class.
At line 117 changed 5 lines
|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
|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
At line 124 changed one line
WC Method is first taken from the pay category of each pay. If Pay Category WC Method does not exist, then the Pay Rule WC Method is used. If Pay Rule WC Method does not exist, then the [IPWC] WC Method of the Work Province is used.
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 126 changed one line
If any of the Pay Category, Pay Rule or [IPWC] WC Methods = 99, WC will not be calculated. Which means the WC calculation can be suppressed at any level.
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 128 changed one line
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.
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.
At line 130 changed one line
In [UPCALC], each pay line's pay component is checked against the [IPWC] Element. If the pay component is included in the IPWC Element, then this pay line's Earnings are considered as WC assessable earnings and will be accumulated by WC Class.
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.
At line 132 changed one line
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's Assignment to retrieve [IEAS] WC Class. If WC Class does not exist, then the pay line's Position is used to retrieve [IDPS] WC Class. If WC Class does not exist, then the pay line's Job is used to retrieve IDJB Job 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.
At line 134 changed one line
For internal amounts that are not from the 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.
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
At line 136 changed one line
[UPCALC] then retrieves the YTD WC assessable earnings by [IPWC] Element for the Work or Residence State/Province according to the WC Method.
UPCALC then retrieves the YTD WC assessable earnings by IPWC Element for the Work or Residence State/Province according to the WC Method.
At line 138 changed one line
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
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
At line 142 changed one line
;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 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
At line 144 changed one line
;Calculate Current pay WC Premium contribution (by WC Class):Current WC assessable earnings * WC rate on IPWC screen for each class and accumulate
Calculate Current pay WC Premium contribution (by WC Class)
= Current WC assessable earnings * WC rate on IPWC screen for each Class and accumulate
At line 156 changed 2 lines
*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 contribution in pay component with usage = 7003
*Store Current pay’s WC contribution in Pay Line Detail by WC Class for WC Report
At line 159 changed 2 lines
*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 earnings in pay component with usage = 7004
*Store Current pay’s WC earnings in Pay Line Detail by WC Class for WC Report.
At line 162 changed 2 lines
*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.
*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.
At line 168 changed 2 lines
*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 contribution in pay component with usage = 7009
*Store Current pay’s WC contribution in Pay Line Detail by WC Class for WC Report
At line 171 changed 2 lines
*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 earnings in pay component with usage = 7010
*Store Current pay’s WC earnings in Pay Line Detail by WC Class for WC Report.
At line 174 changed 2 lines
*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.
*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.