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

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

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
32 26-Nov-2021 10:22 8 KB jescott to previous
31 26-Nov-2021 10:22 8 KB JMyers to previous | to last
30 26-Nov-2021 10:22 9 KB JMyers to previous | to last
29 26-Nov-2021 10:22 14 KB JAiken to previous | to last
28 26-Nov-2021 10:22 14 KB JAiken to previous | to last
27 26-Nov-2021 10:22 14 KB JMyers to previous | to last
26 26-Nov-2021 10:22 14 KB JMyers to previous | to last
25 26-Nov-2021 10:22 14 KB JMyers to previous | to last
24 26-Nov-2021 10:22 14 KB JMyers to previous | to last
23 26-Nov-2021 10:22 14 KB JMyers to previous | to last TYPE_SEQUENCE ==> PREMIUM_TYPE_SEQUENCE
22 26-Nov-2021 10:22 14 KB JMyers to previous | to last
21 26-Nov-2021 10:22 13 KB JMyers to previous | to last

Page References

Incoming links Outgoing links
ISPM
ISPM

Version management

Difference between version and

At line 1 removed 2 lines
[{TableOfContents }]
At line 4 changed one line
[Premiums|PREMIUMS] are used to track and pay extra time and earnings that are not strictly wages. Premiums are created and maintained on the Define Premiums (ISPM) screen.
Premiums are used to track and pay extra time and earnings that are not strictly wages.
At line 8 changed one line
;[Premium|PREMIUM_CODE]:Enter the name of the premium in this field. It is not necessary to build into the name any reference to the unit, it is acceptable (and recommended) to use the same premium codes across multiple units. In this way, a “night shift” premium is always the same code with different rates which are employed based on the union/unit of the employee.
;[Premium|PREMIUM_CODE]:Enter the name of the premium in this field.It is not necessary to build into the name any reference to the unit, it is acceptable (and recommended) to use the same premium codes across multiple units. In this way, a “night shift” premium is always the same code with different rates which are employed based on the union/unit of the employee. Premium_Code is a 16-character alphanumeric mandatory field which you will enter manually.
At line 10 changed one line
;[Unit|UNIT_CODE]:Each premium must be associated with a unit which may be identified in this field.
;[Unit|UNIT_CODE]:Each premium must be associated with a unit which may be identified in this field. Unit is a mandatory 16-character alphanumeric field which you must complete by selecting a value from the LOV. These values are maintained on the Define Entities ([IDUN]) form.
At line 12 changed one line
;[Entity|ENTITY_CODE]:Units are associated with an entity which is identified in this field. This value presented is for information use only and may not be updated by users.
;[Entity|ENTITY_CODE]:Units are associated with an entity which is identified in this field. This value presented is for information use only and may not be updated by users. Entity is a 16-character alphanumeric information field that defaults from the unit code and may not be updated.
At line 14 changed one line
;[Premium Type|PREMIUM_TYPE_CODE]:In this field, you may categorize the premium into one of the premium types created in the [ISPT] form.
;[Premium Type|PREMIUM_TYPE_CODE]:In this field, you may categorize the premium into one of the premium types created in the [ISPT] form. Premium_Type_Code is a 16-character alphanumeric mandatory field that may be either chosen from the LOV, or manually entered.
At line 16 changed one line
;[Type Sequence|PREMIUM_TYPE_SEQUENCE]:The sequence field is used to determine an order of priority for premiums. Users may enter a sequence number to define the order of the premium. This sequence will override the sequential order defined before (pay line over assignment over position over job) and is only applicable to the Time Scheduling module.
;[Type Sequence|TYPE_SEQUENCE]:The sequence field is used by the [UTTG] process to determine an order of priority for premiums. Users may enter a sequence number to define the order of the premium. This sequence will override the sequential order defined before (pay line over assignment over position over job) and is only applicable to the Time Scheduling module.\\This feature works for all premiums of the same type.\\ \\ ''Example:\\Unit - Hourly has two premiums with the Premium Type of TIME; MINREST and TIMEOT\\
*''MINREST pays double-time and TIMEOT pay time-and-a-half.
*''MINREST is added to the Time Entries upon Clock OUT for the MIN HRS BTW SHFT Time Rule.
*''TIMEOT is added to the Time Entries and Pay Transactions during UTTG for the PREM TIME OF DAY Time Rule.
;:Previously this meant that the TIMEOT premium would override the MINREST premium as related to order of processing. By making the ‘Sequence’ of the TIMEOT premium ‘1’ and the ‘Sequence’ of the MINREST premium ‘2’, the MINREST premium will be applied instead of the TIMEOT premium if both are encountered by the UTTG process.''Type_Sequence is a 30-character numeric optional field that may be manually entered.
At line 18 changed 3 lines
;[Description|DESCRIPTION]:This field holds a description of the premium code created.
!Rules
;[Premium Rate|PREMIUM_RATE]:This is the rate that will be used when the Premium Calc rule includes “premium rate” in the formula. If the rule indicates premium rate (Prem Rt) then enter the rate as a percentage amount (0.50 for 50%) or a flat amount (100 for a fitness club premium). If the rule indicates a premium percentage (Prem Prc) then enter the percentage as a whole number (25 for 25%).
;[Description|DESCRIPTION]:This field holds a description of the premium code created. Description is an optional 50-character alphanumeric field that may be manually entered.
\\
----
!!Rules
;[Premium Rate|PREMIUM_RATE]:This is the rate that will be used when the Premium Calc rule includes “premium rate” in the formula. If the rule indicates premium rate (Prem Rt) then enter the rate as a percentage amount (0.50 for 50%) or a flat amount (100 for a fitness club premium). If the rule indicates a premium percentage (Prem Prc) then enter the percentage as a whole number (25 for 25%). Premium_Rate is a mandatory numeric field that may be entered by users.\\ \\__Note that this rate is the default rate, but that it may be overridden, if necessary, for individual jobs, positions, assignments, or transactions (as long as the user has proper security clearance to do so).__
At line 22 changed one line
;:%%information Note that this rate is the default rate, but that it may be overridden, if necessary, for individual jobs, positions, assignments, or transactions (as long as the user has proper security clearance to do so).%%
;[Rate Basis|RATE_BASIS]:This field defines the time period (hour, day, week, year) used with the premium rate value provided. Rate_Basis is a mandatory fixed lexicon ([X_RATE_BASIS]) that the user may use to look up the value.
At line 24 changed one line
;[Rate Basis|RATE_BASIS]:This field defines the time period (hour, day, week, year) used with the premium rate value provided.
;[Premium Calc Rule|PREMIUM_CALC_RULE]:Premium Calc rule is the rule that will be used to calculate the premium. There are a number of formulas provided. Below is a table that outlines the calc rule from the LOV, the formula it represents, whether a pro-ration is applicable, and an example of each rule. An explanation of the use of FTE Pro-ration follows the table.\\ \\__If the premium calculation rule uses a user variable, that user variable must be on the Time Pay component in order for this premium calculation to work__
At line 26 changed one line
;[Premium Calc Rule|PREMIUM_CALC_RULE]:Premium Calc rule is the rule that will be used to calculate the premium. There are a number of formulas provided. Below is a table that outlines the calc rule from the LOV, the formula it represents, whether a pro-ration is applicable, and an example of each rule. An explanation of the use of FTE Pro-ration follows the table.\\ \\If the premium calculation rule uses a user variable, that user variable must be on the Time Pay component in order for this premium calculation to work.
|| ||Premium Calc Rule:||Formula / Notes||FTE Pro?||Example:
|01|Premium Rate|Premium Rate\\Premium Type attached to [IPPC]\\Created when Pay Line is created/saved|Yes|Premium Rate=6.00\\Frequency = (not applicable)\\Result = $6.00 for each transaction with this premium attached
|02|Prem Rt Per Period|Premium Rate for the pay period frequency\\Flat amount created during [UPAUDT]|Yes|Premium Rate=6.00\\Pay Frequency=Monthly\\Result = $6.00 given once each pay.
|03|Prc x Wage Rt|Premium Rate as a Percentage X Employee’s Rate\\Premium Type attached to [IPPC]\\Created when Pay Line is created/saved|Yes|Premium Rate = 100.00\\Rate Basis = WK (from ISPM form)\\EE’s Wage Rate = 50,000/year\\Calc = 100 / 100 * $50,000 / 52 wk\\Result = $961.54 for each transaction with this premium attached (100% of 1 weeks’ pay)
|04|Prem Rt x PC UVar|Premium Rate X PC User Variable Rate\\Premium Type attached to [IPPC]Created when Pay Line is created/saved|Yes|Premium Rate = 10.00\\Rate Basis = (not applicable)\\User Variable Rate = 1.5\\Calc = 10.00 * 1.5\\Result = $15.00 the rate basis of the premium and the pay component that originated the transaction (if there is one), are not applicable
|05|Prc x Wg Rt x UVar|Premium Rate as a Percentage X Employee’s Rate X PC User Variable Rate\\Premium Type attached to [IPPC]\\Created when Pay Line is created/saved|Yes|Premium Rate = 15.00\\Rate Basis = WK (from ISPM form)\\EE’s Wage Rate = 10.00/hr\\EE’s Hours/Week = 40 (from Assignment)\\User Variable Rate = 2\\Calc = 15 / 100 * $400 * 2\\Result = $120.00 for each transaction with this premium attached ($400 is the weekly rate)
|06|Prem x EV|Premium Rate X Entered Value\\Premium Type attached to IPPC\\Created when Pay Line is created/saved|N/A|Premium Rate = 10.00\\Rate Basis = DY (from ISPM form)\\EE’s Hours/Day = 8 (from Assignment)\\Entered Value = 4\\Time PC basis = HR (from transaction)\\Calc = 10.00 / 8 * 4\\Result = $5.00 for this transaction
|07|Prem x EV x Wg Rt|Premium Rate X Entered Value X Employee’s Rate\\Premium Type attached to [IPPC]\\Created when Pay Line is created/saved|N/A|Premium Rate = 0.25\\Rate Basis = HR (from ISPM form)\\Entered Value = 8\\Time PC basis = HR (from transaction)\\EE’s Wage Rate = 10.00/hr\\Calc = 0.25 * 8 * 10\\Result = $20.00 for this transaction
|08|Prem x EV x UVar|Premium Rate X Entered Value X PC User Variable Rate\\Premium Type attached to [IPPC]\\Created when Pay Line is created/saved|N/A|Premium Rate = 4.00\\Rate basis = DY (from ISPM form)\\Entered Value = 6 \\Time PC basis = HR (from transaction)\\EE’s Hours/Day = 7.5\\User Variable Rate = 1.5\\Calc = 4 * (6 / 7.5) x 1.5\\Result =$4.80 based on the fact that a day is 7.5 hours, so the time was 0.8 days
|09|Prem x EV x Wg x UVar|Premium Rate X Entered Value X Employee’s Rate X PC User Variable Rate\\Premium Type attached to IPPC
Created when Pay Line is created/saved|N/A|Premium Rate = 5.00\\Rate basis = HR (from ISPM form)\\EE’s Wage Rate=15.00/hr\\Entered Value = 9\\Time PC basis = HR (from transaction)\\User Variable Rate = 0.005\\Calc = 5 * 9 * 15 * 0.005\\Result = $3.38
|10|Contract Limit Prem|Only applied to the Contract Limit on IEAS when an employee is in a ‘Contract’ type Group|N/A|Premium Rate = 1500.00\\Rate basis = CT (from ISPM form)\\This amount is included in the Contract Limit.
|11|Cell Points| | | |N/A – custom calc rule
|12|UPTG Period $$$ Premium Rate the frequency indicated
Flat amount created during UPTG
This rule is only applicable when generating dollars and not if you’re generating hours. Yes Premium Rate = 6.00
Frequency = WK (from ISPM)
Pay Frequency = Biweekly
Result = $12.00 for this pay period (6.00 per week).
13 UPTG Period Cell Pts N/A – custom calc rule
14 Increment Time Increment Time is used in ITIO -determined by the Clock In and Out times and the Time Type. Used on premiums attached to the Pay Line, and – not to the Position, Job or Assignment. This restriction is imposed since the ‘Override Rate’ is the key value in the formula and it would always be entered for premiums of this type.
15 Pay Period Premium Flat dollar amount that is given once per pay period. If there are multiple pays in a pay period, this will be give only once.
16 Flat Amount Per Day Flat dollar amount that is given once for each day worked. If there are multiple transactions on the same day, it will be given only once. FTE is not relevant here.
At line 29 changed one line
;[Custom Premium Logic|CUSTOM_PREMIUM_LOGIC]:If you require custom premium logic, contact your consultant.
__The examples show that where there is a difference between the rate basis of the premium and the rate basis of the employee or the time transaction, a conversion of the rate will occur using the employee’s hours per day, or the rate basis of the time transaction, as applicable.__
At line 31 changed 8 lines
;[Premium Wage Source|PREMIUM_WAGE_SOURCE]:This field allows you to define the source of the premium, either from the pay line or from the highest scale/step rate on the position record.
;[Frequency|FREQUENCY]:This field indicates how often, or for what types of pay, the transaction line will be created. Personality uses the term “frequency” to control the timing of payroll deductions, benefits, and earnings. Frequencies are defined during Payroll training and once created may be accessed by the LOV.\\ \\‘Frequency’ is only applicable to the “Prem per Period” and “UPTG Period Premium” calculation method. However, if either of those methods are used, frequency is REQUIRED.
;[User Variable|USER_VARIABLE_CODE]:This field allows you to choose a specific user variable for a premium. When a premium amount is calculated the system will read the user variable associated with the [Pay Component|PAY COMPONENTS]; however, if a user variable has been specified in ISPM then this will act as an override.
;[Prorated|PREMIUM_PRORATED]:If the toggle is ON, the premium paid will be prorated based on the employee’s FTE value. This is not applicable to Premium Calc rules that include time in the formula, as actual time worked is already included in those calculations.
;:Example: A company pays for employees’ fitness memberships; a yearly amount of $400.00. All employees may sign up for the benefit, but part-time employees receive a pro-rated amount based on their Full Time Equivalency (FTE). As well, the company would like to pay the premium at the beginning of each month. The [ISPM] form would be set up as follows:
;[Custom Premium Logic|CUSTOM_PREMIUM_LOGIC]:If you require custom premium logic, contact your High Line consultant.
;[Premium Wage Source|PREMIUM_WAGE_SOURCE]:This field allows you to define the source of the premium, either from the pay line or from the highest scale/step rate on the position record. Premium_Wage_Source is an optional fixed lexicon ([X_PREMIUM_WAGE_SOURCE]) that you may use to look up the value.
;[Frequency|FREQUENCY]:This field indicates how often, or for what types of pay, the transaction line will be created. [{$applicationname}] uses the term “frequency” to control the timing of payroll deductions, benefits, and earnings. Frequencies are defined during Payroll training and once created may be accessed by the LOV.\\__‘Frequency’ is only applicable to the “Prem per Period” and “UPTG Period Premium” calculation method. However, if either of those methods are used, frequency is REQUIRED.__\\Frequency is an optional, 16-character alphanumeric field that may be retrieved from the LOV.
;[User Variable|USER_VARIABLE]:This field allows you to choose a specific user variable for a premium rather than relying on the user variable associated with the Pay Component.
;[Prorated|PRORATED]:If the toggle is ON, the premium paid will be prorated based on the employee’s FTE value. This is not applicable to Premium Calc rules that include time in the formula, as actual time worked is already included in those calculations. \\ ''Example: A company pays for employees’ fitness memberships; a yearly amount of $400.00. All employees may sign up for the benefit, but part-time employees receive a pro-rated amount based on their Full Time Equivalency (FTE). As well, the company would like to pay the premium at the beginning of each month. The ISPM form would be set up as follows:''
At line 44 removed one line
At line 46 changed 34 lines
;[Replacement Option|REPLACEMENT_OPTION]: If the toggle is ON, the hours and/or earnings will be replaced by the new hours and/or earnings (including premium) calculated when the pay line is generated. The premium will remain attached to the pay line for audit purposes.
;:In theory, any number of premiums could be attached to a single pay line. If any one of these premiums invokes the ‘Replace’ option, then the hours and/or earnings generated by the original transaction will be replaced by the hours and earnings on the premium. Any other premiums will be processed based on these new hours/earnings.
;[Incl in Highest Rate of Day|HIGHEST_RATE_OF_DAY]:If the toggle is ON it provides the ability to apply the highest rate of pay received on that day worked including premiums. The highest rate on a day of course cannot be determined until all transactions for a pay are available and ‘official’. Because of this, the perfect place to ‘Rate’ [Pay Components|PAY COMPONENTS] with this option, is when the Pay hits the Pay Stage to be audited, so the [UPAUDT] function will be given the responsibility to apply the ‘Highest Rate of the Day’ feature.
!Pay Components
;[Time PC Code|PPC_ID_TIME]:Time PC code is the [pay component|PAY COMPONENTS] code that will store the “time” result of the premium calculation. Users may wish to use this field if time is stored separately as a result of premium transactions.
;:An employee has worked 8 hours in one night shift. A transaction for the 8 regular hours has been entered, and a night shift premium will be applied. If the company requires that the 8 hours of premium time be recorded in a separate area for tracking reasons, a pay component may be entered in this field. Result: 8 hours regular time, 8 hours premium time
;:If the company requires only that 8 hours of regular time be recorded (relying on the earnings [pay components|PAY COMPONENTS] to track the premium paid), leave the time [pay component|PAY COMPONENTS] blank. Result: 8 hours regular time.
;:PPC_ID_TIME is an optional, 4-character numeric code that may be entered by the user or retrieved from the LOV. At least one of Time or Amount PC code must be entered.
;[Abbrev.|PC_ABBREVIATION]:This field displays the abbreviated description of the Time PC Code selected above. This data for this field will default in once the Time PC Code has been selected.
;[Amount PC Code|PPC_ID_DOLLARS]:Amount PC code is the [pay component|PAY COMPONENTS] code that will store the “earnings” result of the premium calculation. Users may wish to use this field if the earnings from the premium are stored separately as a result of the premium transaction. This may be necessary if the cost account (or distribution code) of the premium differs from the originating transaction.
;:Continuing with the same example as above, this employee’s rate is $10/hr, and the premium rate is $0.50/hr. If separate areas for tracking regular earnings and premium (or shift) earnings are required and defined, the result would be:$80.00 regular earnings, $ 4.00 premium earnings
;:If the company requires only that the earnings be recorded in one lump sum (premiums are not tracked as a separate amount on the financial journal, or are tracked based on hours pay components, instead), the result would be:$84.00 regular earnings'
;[Abbrev.|PC_ABBREVIATION]:This field displays the abbreviated description of the Amount PC Code selected above. The data for this field will default in once the Time PC Code has been selected.
;:Pay Point Type and Seq are only applicable to the “Prem per Period” and “UPTG Period Premium” calculation method and are REQUIRED if either of those methods are used.\\
;[Pay Point Type|PAY_POINT_TYPE]:Choose the point in the payroll cycle when the premium should be processed. Pay Points allow you to control the flow and process steps of the payroll process, and you may in this way ensure that a premium is calculated at the correct point.
;[Pay Point Seq|PAY_POINT_SEQUENCE]: In this field, you may define the sequential order of each step taken within a pay point.
;[Replacement Option|REPLACEMENT_OPTION]: If the toggle is ON, the hours and/or earnings will be replaced by the new hours and/or earnings (including premium) calculated when the Pay Line is generated. The premium will remain attached to the pay line for audit purposes.
\\
;:__In theory, any number of premiums could be attached to a single Pay Line. If any one of these premiums invokes the ‘Replace’ option, then the hours and/or earnings generated by the original transaction will be replaced by the hours and earnings on the premium. Any other premiums will be processed based on these new hours/earnings.__
\\
;:Replacement_Option is an optional toggle (P2K_SA_PREMIUM_DETAILS) that the user may set on or off.
;[Incl in Highest Rate of Day|HIGHEST_RATE_OF_PAY]:If the toggle is ON it provides the ability to apply the highest rate of pay received on that day worked including premiums. The highest rate on a day of course cannot be determined until all transactions for a pay are available and ‘official’. Because of this, the perfect place to ‘Rate’ Pay Components with this option, is when the Pay hits the Pay Stage to be audited, so the UPAUDT function will be given the responsibility to apply the ‘Highest Rate of the Day’ feature.\\Highest_Rate_Of_Pay is an optional toggle ([P2K_SA_PREMIUM_DETAILS]) that the user may set ON or OFF.
\\
At line 81 changed 2 lines
![Notes|Edit:Internal.ISPM]
[{InsertPage page='Internal.ISPM' default='Click to create a new notes page'}]
!!Pay Components
;[Time PC Code|PAY_COMPONENTS]:Time PC code is the pay component code that will store the “time” result of the premium calculation. Users may wish to use this field if time is stored separately as a result of premium transactions.\\ \\''An employee has worked 8 hours in one night shift. A transaction for the 8 regular hours has been entered, and a night shift premium will be applied. If the company requires that the 8 hours of premium time be recorded in a separate area for tracking reasons, a pay component may be entered in this field. ''\\''Result: 8 hours regular time, 8 hours premium time\\''If the company requires only that 8 hours of regular time be recorded (relying on the earnings pay components to track the premium paid), leave the time pay component blank.\\''Result: 8 hours regular time.\\ \\Pay_Component is an optional, 4-character numeric code that may be entered by the user or retrieved from the LOV. At least one of Time or Amount PC code must be entered.
;[Abbrev.|ABBREVIATION]:This field displays the abbreviated description of the Time PC Code selected above. This data for this field will default in once the Time PC Code has been selected.
;[Amount PC Code|PAY_COMPONENT]:Amount PC code is the pay component code that will store the “earnings” result of the premium calculation. Users may wish to use this field if the earnings from the premium are stored separately as a result of the premium transaction. This may be necessary if the cost account (or distribution code) of the premium differs from the originating transaction.\\ \\''Continuing with the same example as above, this employee’s rate is $10/hr, and the premium rate is $0.50/hr. If separate areas for tracking regular earnings and premium (or shift) earnings are required and defined, the result would be:\\''$80.00 regular earnings, $ 4.00 premium earnings\\''If the company requires only that the earnings be recorded in one lump sum (premiums are not tracked as a separate amount on the financial journal, or are tracked based on hours pay components, instead), the result would be:\\''$84.00 regular earnings''\\ \\Pay_Component is an optional, 4-character numeric code that may be entered by the user or retrieved from the LOV.
;[Abbrev.|ABBREVIATION]:This field displays the abbreviated description of the Amount PC Code selected above. The data for this field will default in once the Time PC Code has been selected. \\__Pay Point Type and Seq are only applicable to the “Prem per Period” and “UPTG Period Premium” calculation method and are REQUIRED if either of those methods are used.__\\
;[Pay Point Type|PAY_POINT_TYPE]:Choose the point in the payroll cycle when the premium should be processed. Pay Points allow you to control the flow and process steps of the payroll process, and you may in this way ensure that a premium is calculated at the correct point. Pay_Point_Type is an optional, fixed lexicon ([X_PAY_POINT_TYPE]) that may be retrieved from the LOV.
;[Pay Point Seq|PAY_POINT_SEQUENCE]: In this field, you may define the sequential order of each step taken within a pay point. Pay_Point_Sequence is an optional, 4-character alphanumeric field that may be manually entered.
This page (revision-32) was last changed on 26-Nov-2021 10:22 by jescottTop