Sunday, October 9, 2011

Trick:NA payroll : Pay Calculation for single employee

Like GP, NA payroll does not have option to run pay calculation for single/multiple employees'.

To run for specific employees in NA payroll, need to change the payline status. If any changes we made in online to paysheets then also it will trigger pay_line_status = 'U'

for eg: using below sql we can update the payline to - Job Chage.

UPDATE PS_PAY_LINE A
  SET A.JOB_CHANGE = 'R'  where emplid ='XXXX' and pay_end_dt='DD-MON-YYYY'.

after updating the payline status, run pay calculation by selecting the option  below.






Wednesday, October 5, 2011

Workaround :Overtime FLSA calculation Empl on multiple companies-NA payroll (till PS 9.1)


If empl is working on multiple companies peoplesoft (till 9.1 versions) does not calculate overtime FLSA as employee level & It calculates company level.

We had a requirement to calculate FLSA employee level.


After some analysis over changing the COBOL we found the FLSA calculation & but its quite risky to touch COBOL & time taking procedure.

So a workaround to achieve this, we have created custom appengine it will run after payroll calculation.

The main custom AE function is, to calculate the overtime based on FLSA by combining multiple company paylines(earnings). 

The Final amount paid by the employee is Diff between the Custom AE overtime amt  and overtime amount which calculated by Peoplesoft



AE contains two parts.

     1. Without prior period adjustment 

     2. With Prior adjustments (most complex part). 


:-)