Looking up a Shift in the Shift table

Question:

What Table.Field is used to determine the SETID used when looking up a Shift in the Shift table during PayCalc?

Answer:

There are number of ways to define Shift in PeopleSoft Payroll as indicated in this previous post:

if you are defining Shift through the Paygroups or even some other method, PeopleSoft Payroll needs you to define at least one shift in PS_SHIFT_TBL; The shift you define is based on the SETID you select in PS_PAYGROUP_TBL; So, the Shift is connected to Paygroup that you define for your company;

When you define a paygroup, there is a Set ID in the paygroup, that is defaulted same as paygroup;you can change it to your HR SetID, but this should be defined in the SetID Table and SetControl value before you change it; or you can leave the default value as it is and come back and change it;

if you want to change it, you need to do the following setup:
For the Paygroup value you are defining, go to SetControl table that is under TableSet Control (TableSet Control - PeopleTools Utilities Administration TableSet Control ) enter the paygroup value under Set Control Value: and under PY_02 record group, change the value for SetID;

For this SetID, you need to define a shift value; if you are not using the Shift Table, you must define at least one shift as shown below:

So, when a paycalc is run, it checks the paygroup's SetID; For this value it checks the SetControl Table and under PY_02 record group, for the value of the SetID, there should be a Shift Defined;

Else, you should expect a payroll error :

Message ID : 000049

Shift Not Found

The shift displayed below was not found.

Tables/Fields for Shift Defination and paycalc process: PS_SHIFT_TBL , PS_PAYGROUP_TBL , PS_SETID_TBL , PS_SET_CNTRL_REC

Hope this helps...

'Salary replacement percentage' in disability plans

Question:
Can anyone let me know what's the significance of salary replacement percentage field in disability plans?If employee is to be paid a percentage of salary during disability period, will this field play any role or how can it be achieved in NA payroll?

Answer:

Premiums are based on employee salary or covered salary, whichever is lower.
Covered Salary = Maximum Monthly Benefit ÷ Salary Replacement Percentage.

So if a vendor like Liberty Mutual for example has a plan that provides a salary replacement value up to 50% of your annual base compensation, with a monthly maximum of $7,500.00 , you will setup that in your LTD Plan in Base Benefits Table.
In order to calculate the premium that needs to be deducted from EE who enrolled into this plan, Rate tables must be setup for this plan.

Let's assume that, EE monthly salary is 10,000.00. The benefit amount is 50 percent of that. Because the benefit amount is less than the maximum monthly benefit (7500.00) , 50 percent of salary is used to calculate the premium.

if .4 is the rate per hundred, then ($10,000 ÷ 100) × .4 × 12 = $480...This will be the annual premium.

If the Monthly Salary is 20,000.00 and the max benefit amount would be $7,500.00 , because the Salary replacement percentage of 50% which is (50% of 20,000K) is exceeding the max limit of 7500.00; the calculated base for premium amount would be 15k only;

($15,000 ÷ 100) × .4 × 12 = $720...This will be the annual premium.

Hope this helps..