Top PeopleSoft Jobs

How does PeopleSoft Calculate Hourly Rate

Tuesday, June 12, 2012

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


Share/Save/Bookmark

Read more...

About This Blog

Have you got a PeopleSoft Question? Post it in the forums section or in your preferred place or in comments section, so that we can answer it for you in detail with screen shots;

Learn PeopleSoft functionality and how to use the setups and process flow offered in different modules;

Hope this would give you some ideas...

Blog Archive