Showing posts with label Work Schedules. Show all posts
Showing posts with label Work Schedules. Show all posts

Thursday, April 4, 2013

PeopleSoft 9.2 feature review - Enhancement to Monthly Schedule page in ESS

The Monthly Schedule page in PeopleSoft Time and Labor Employee Self Service, provides a calendar based view of the work schedule of the employee for a certain month. Details of absences and/or trainings (if integrated with PeopleSoft Enterprise Learning Management suite) are also displayed for each day of the month. A sample of the page is given below:

In PeopleSoft 9.2, I have noticed that there is a slight enhancement to the Monthly Schedule page. The T&L product team has added a grid on the page with daily breakdown of the employee's work schedule for the selected month. The new grid on the page is shown below:


As seen above, the grid gives a day by day break-down of the scheduled hours (and with indication of whether there is an absence/training or holiday on a certain day) for the selected month. While this looks like a duplication of the data shown in the calendar format in the same page, employees will be able to download the schedule information from this grid.
Point of View:
  • This is a minor enhancement that duplicates the data that is already present in the same page.
  • This feature will give employees the ability to download their work schedules into an excel sheet.
  • If the purpose of adding this grid was to enable downloading schedule data - wouldn't a 'Print Schedule' link, similar to the 'Print Timesheet' link, served the requirement better? 

Wednesday, November 14, 2012

How is the personal work schedule id derived?

Work Schedules play a central role in both PeopleSoft Absence Management and Time and Labor. Work Schedules can be assigned directly to an employee and there are the following assignment methods possible:
1. Assign a pre-defined work schedule
2. Inherit a default work schedule. If you are interested to know how the default work schedule is decided, read this post.
3.  Assign a personal schedule. A personal schedule gives the user flexibility to define a work schedule pattern that is specific to one assignment of an employee.

When you define a personal work schedule, the schedule id is automatically derived by PeopleSoft and is non-editable.

The figure above, clearly illustrates that when an assignment method of personal schedule is selected, the schedule id is defaulted and greyed out.
So, what is the logic used by the system to derive the schedule id?
The system uses a combination of Employee Id and Employee Record number to derive the personal schedule id. This is done so that it will enable users to create unique personal schedule for different assignments of an employee id. The personal schedule id is derived by concatenating the employee id to a five digit number derived by adding the employee record number to 100000.
The code used to come up with the personal schedule id is given below:

EMPLID | Substring(String(100000 + EMPL_RCD), 2, 5);

The code can be interpreted as a two step process:
The first step is to derive the last five digits of the personal schedule id. This is done by first adding the employee record number to the numeral 100000. The first five digits starting from the second digit of the result is then retrieved. This new five digit number is concatenated to the employee id to derive the personal schedule id.
Let us sign off this post with an example.
What would be the personal schedule id of an employee with employee id 100000345 and employee record number 3?
Step 1:
Add employee record number to 100000. This results in 100003
Retrieve the last five digits of the schedule id by substringing the above result. So, the last five digits of the schedule id will be 00003.

Step 2:
Concatenate the final result from Step 1 with the employee id to have the personal schedule id.
This will result in a personal schedule id of 10000034500003

Monday, March 26, 2012

Design Flaw in PeopleSoft Work Schedule Defaults and design in Oracle Fusion HCM

For a Human Resources ERP suite, PeopleSoft HCM has excellent Time and Attendance features. One area that is highly under-appreciated (but lauded by customers when they see the complete potential!) is the Schedule Management features in PeopleSoft Time and Labor and Absence Management. Some of the features, like the ability to define flexible work schedules, ability to create work schedules on the fly, integrated Time Calendar views with Time, Absence and Training information etc. are very exciting and useful. In this post, I want to highlight a glaring flaw in the design of the work schedule defaulting feature in PeopleSoft. A Work Schedule can be attached at multiple levels in PeopleSoft HCM, for eg:
a. At the employee level in the Assign Work Schedule page (underlying datastructure is SCH_ASSIGN)
b. At the Absence Management/Global Payroll Paygroup level
c. At the Payroll for North America Paygroup level
d. At the Time and Labor workgroup level

If a work schedule is not directly attached to an employee, PeopleSoft follows a specific hierarchy to resolve the work schedule that has to be assigned. In this hierarchy, Absence Management/Global Payroll paygroup takes precedence over Payroll for North America paygroup, which takes precedence over Time and Labor workgroup.
In our opinion, it is not a good practice to default a work schedule from a Paygroup or Workgroup. The primary purpose of a Paygroup/Workgroup is to group employees with similar pay/absence/time characteristics together and is not to group employees working similar schedules. The fact that Absence Management/Global Payroll paygroups take precedence over other definitions makes the case more rigid in our opinion. This is because, the Global Payroll/Absence Management organisational and processing frameworks are extremely flexible. It is possible to define very generic paygroups and then drive application of specific rules to concerned group of employees through the use of conditional processing elements or even payee level overrides. An optimal design of Absence Management/Global Payroll frameworks should make use of this inherent product flexibility and design simple,lean and flat frameworks. The simpler the configuration, the more generic will be the assignment of paygroups, i.e. most employees will share the same paygroup. But, most often it is required to have more specific groupings for the purpose of work schedule defaults. So a simplistic Absence Management/Global Payroll framework design will not help in proper defaulting of work schedules. We have seen many legacy Time and Attendance applications (applications from which the client moved to PeopleSoft Time and Attendance) where the time processing rules were tightly tied to the work schedule of employees. This is our mind is similar to the concept of tying a work schedule to a paygroup/workgroup. But, all these systems suffered from the complexity introduced by the tight coupling of rule processing groups and schedules and the same deficiency exists in PeopleSoft as well.
My suggestion to the PeopleSoft Time and Labor/Absence Management product managers would be to take a relook at the schedule default options in PeopleSoft and provide a mechanism to default work schedules from a data definition that is more attuned with the actual business process of wok schedule assignments. In our opinion, Jobcodes and especially Positions are excellent candidates for this. From an operational point of view, employees in a certain jobcode or position have more probability of sharing a work schedule that those in the same paygroup (ofcourse the challenge of global implementations and shared jobcodes/positions do come in here, but we believe that these definitions are better candidates for work schedule defaults than a paygroup).

In this context, we want to introduce the work schedule defaulting features available in Oracle Fusion HCM. In Fusion HCM, the hierarchy of work schedule resolution is given below:
  1. Primary assignment of the worker
  2. Position
  3. Job
  4. Department
  5. Location
  6. Legal Employer
  7. Enterprise
It's excellent to see that Oracle Fusion HCM offers a more flexible and elaborate work schedule assignment mechanism, which in our opinion is more in tune with the business requirements. We do hope that the PeopleSoft design team takes a cue from the Oracle Fusion HCM design and provides a more flexible work schedule defaulting design.