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 7 added one line
At line 9 added one line
At line 9 changed 2 lines
;[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.
;[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\\
;[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.
;[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\\
At line 19 added one line
At line 19 changed one line
;[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.
;[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 21 removed 2 lines
__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 24 removed 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.
At line 26 changed one line
__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|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 30 added 25 lines
|| ||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.
This page (revision-32) was last changed on 26-Nov-2021 10:22 by jescottTop