How does PeopleSoft Calculate Hourly Rate

How does PeopleSoft Calculate Hourly Rate:

In PeopleSoft HCM, we define Frequency ID’s that are defined on the Frequency table, that are used for many different purposes, but one of the usage of Frequency ID is to convert compensation calculations from one frequency to another.

Each Frequency ID that is defined is associated with a Annualization Factor. Frequency Annualization Factor is the number of periods in one year for the frequency ID. For example, a standard monthly frequency has the Annualization factor of 12.

If you hire a Salaried Employee and provide a compensation rate with Annual Frequency, how does PeopleSoft Calculate the Hourly Rate? What logic will it use in converting the Annual Amount to Hourly Amount?  We can take an Example of a Salaried Employee who has a Compensation Rate of 6000.00 USD with a Monthly Frequency.

PeopleSoft uses the below formula for Compensation Conversion Using Frequency:

Annual compensation rate / job standard hours’ × frequency factor of standard work period. 

First the system annualizes the Comp Rate for the given frequency, then for the Annualized Rate, the system applies the above formula. 

For monthly compensation of 6000.00 USD, it is first converted to Annualized rate, by applying the Annualization factor of 12.  This would become 72,000.00 USD. 

Next comes the Job Standard hour for the work period.  If the standard work period defined is as ‘W’ (Weekly, with annualization factor of 52), and for this work period, if the standard hours are defined as 40, then the above formula would be: 

Hourly Rate:           

=   72,000.00 / (40 * 52)         

 =  72,000 / (2080)

 =  34.615385

How does PeopleSoft Calculate Hourly Rate

Read more...

Deleting Time and Labor Template Built Rule

Question: How do you delete a time and labor template built rule?

Answer:

If you are working on Time and Labor Template Built rule and if you happen to create a rule by mistake or realize that you did not want the rule to be in specific name and want to create a new one, there is no option in PeopleSoft Time and Labor to delete the Rule that you just created using the Templates. The only way would be using the backend method.

Below are the Time and Labor Tables that you will use to delete the rule using a SQL Editor.

DELETE FROM PS_TL_TMPLT_RULE WHERE TL_RULE_ID = 'Rule Name';

DELETE FROM PS_TL_TMPLT_RULE2 WHERE TL_RULE_ID = 'Rule Name';

DELETE FROM PS_TL_RULE_TMPLT WHERE TL_RULE_ID = 'Rule Name';

DELETE FROM PS_TL_RULE_DEFN WHERE TL_RULE_ID = 'Rule Name';

DELETE FROM PS_TL_RULE_STEPS WHERE TL_RULE_ID = 'Rule Name';

Also, go to TL_TA_RULES Application Engine Program and delete the section of the template rule.

Deleting Time and Labor Template Built Rule

Read more...