How PeopleSoft Does Calculates Holiday Hours during Paysheet Creation.

Question : How PeopleSoft Does Calculates Holiday Hours during Paysheet Creation?

Answer:

You setup Holiday Calendar with holiday hours as shown in the below screen shot. For Example for New Year, the holiday hours are set as 8 Standard Hours.

If you are using Payroll for North America for US, you will select Standard as the Holiday Type as this value designates a U.S. holiday.

In this example , I am assuming that you are using Holiday Hours to be controlled by HR Paygroups and Job (not through Time & Labor Rules). Also you are using Semi Monthly Payroll as shown below :

Now, let’s say that you have the 2 Job Codes , one for Full Time Employee and another for Part Time employee with Standard Hours Set to 86.67 for each of this job codes and Semi Monthly as the Work Period.

Part Time Job Code Setup:

Full Time Job Code Setup:

Now let us hire employees into these job codes. We will hire one full time employee into FT job code and another part time employee in PT job code. Set the Standard Hours as shown in the screen shot. i.e. FT will have 86.67 and PT will have 40 hours.

FT Employee:

PT Employee:

Let’s create paysheet for this employees. Run Create Paysheet process for First payroll of the year so that New Year Holiday comes into paylines. Here are the paylines for FT and PT employee:

FT employee has full standard holiday hours which is 8 hours. However the holiday hours for PT employee is only 3.69 hours.

Now Let’s step back and look at the delivered funtionality for PeopleSoft Holiday Hours calculation.

PeopleSoft Delivered Logic for Holiday Hours:

If EE's are not full-time, then the system will calculate the holiday hours by using the standard hours of the employees, divides this by the number of standard hours on the installation table (or job code, if different) and then multiplies it by the hours on the holiday calendar table. 

So, For FT employee, here’s how PS calculated:

Formula will be :

(STD Hours for EE on Job ) / (STD Hours for EE on Job Code ) * Holiday Hours setup = Holiday Hours on paysheet

For FT Employee:

(86.67 / 86.67 ) * 8 =  8

For PT Employee

(40 / 86.67 ) * 8 = 3.692  = 3.69

 

How PeopleSoft Does Calculates Holiday Hours during Paysheet Creation.

Read more...

PeopleSoft AWE (Approval Workflow Engine) - Part 2

Let’s look at one of the AWE Example at higher level and see some of its setups.

Here’s an example of AWE process that comes delivered in the system. When a Time Reporter submits time, the time should be approved by this employee’s Supervisor; The Approval process is setup at Employee TL Workgroup level (not at TRC level).

For the above employee’s workgroup, system will be usin g the Approval Process ID of TLReportedTime (or the Approval Definition ID of TLBySupervisorID).

Also, In the demo system that I will be testing this AWE process, the Email Notification is turned off and only worklist is turned on as shown below :

What this mean is that, only worklists are triggerd when the approval s are routed and the Approver  has to go to the Worklist and pick up the approvals. If the Email Active was also selected, the email notification will also be sent to the Approver.  (there is also one more setup at AWE level for notifications and we assume that the delivered system uses both type of the notifications)

 So Lets Take a look at the Timesheet and submit Time :

If you look at the above screen shot, time is submitted for Friday 05/16 for 8 REG hours. This reported time needs approval;

If you look at the Approval Monitor Link, it looks as shown below :

It shows multiple Approvers. If you look at the Multiple Approvers link, it shows as below:

There are several approvers (17 of them) in the list ,which means that, anyone of the list can be approver and once it is approved, the time can be processed by Time Admin.

Now let’s dig into this AWE Setup and see how it is working and find the Process Flow:

AWE has the What, How, When & Who logic. When the Timesheet is submitted, this is the transaction and this is the “What” part of AWE.  So in AWE, we need to have a Transaction Registry Setup and this identifies how the calling application will interact with AWE;

Now comes the “How” Part which is handled by the Approval Process Definitions: The Approval Process Definition pages allow the functional analyst to define the workflow steps to be executed in order for the transaction to be approved. So with our example, we have KU0016 Employee (Time Reporter) time submission for 05/16 date, and how this should be approved; are there multiple approval levels or just a single level, is there a specific logic involved here? From our example, it is a simple single level approval and there are no multiple levels.

Next is the “When” Part.  There is an Approval Process Configuration page that allows the user to define events that trigger notifications. In our example, the Time Sheet submission should trigger the notification in the form of email or worklist or both.

The last part is the “Who” Part, i.e. who should approve or who would get the notification? This is the User list is which is generated by User Roles, SQL Definitions, PS/Query options and Application Packages. In our Example, we had a PS Query that fetches a list of users who can approve the transaction.

Let’s stop the Part – 2 here and continue with deeper diving in the Part – 3 of AWE. Hope you are following the steps so far. We will take a look at each of the above setups in the next part. See you later.

 

PeopleSoft AWE (Approval Workflow Engine) - Part 2

Read more...