Pay Period # and Date

Looking for a way to automate our interface from Lawson HR/Payroll (Oracle) to a non-Lawson Budgetting system. The program needs to select records from PRDISTRIB based off of pay period end date, which is currently entered by a user via a parameter. They are also prompted for the pay period # so the pp# can be appended to the name of the csv file. For example: PRfile01.csv, PRfile02.csv, etc. Is there a table in HR/Payroll that contains the most recent pay period ending date & the pay period number? If not, how have others accomplished this for automating reports/interfaces?

Thanks in advance!
Deanna

Find more posts tagged with

Comments

jreese

I have a processflow that extracts this information after every pay period for our Budget Advisor application. The process is scheduled to run every week because there isn't a bi-weekly option on the scheduler. I have a CSV file that contains the payroll dates and pay period nbr that the program looks to match to know if it is actually a payroll week and continue processing or terminate and wait until next week to process again. If I need to do an on-demand run I have a trigger page built in Design Studio to pass the period end date and then runs just like the scheduled process. Has been running now for 3 years.

vipin-katiyar

If you all have OT plans set up and one of your plans conforms to your pay periods, you may be able to use table PROTPAYPRD
For example, if you all use bi-weekly pay periods:
SELECT
PAY_START_DATE-14 AS PRIOR_PER_BEG
,PAY_END_DATE-14 AS PRIOR_PER_END
/* period number based on period begin date in the year */
,TO_CHAR(TRUNC(((PAY_START_DATE-14)
- TO_DATE(EXTRACT(YEAR FROM PAY_START_DATE-14)||'0101','yyyymmdd'))/14)+1,'00') PERNBR
FROM PROTPAYPRD
WHERE COMPANY =
AND PLAN_CODE = ''
AND SYSDATE BETWEEN PAY_START_DATE AND PAY_END_DATE;
If using the table does not work for you, there are some other modular and date arithmetic tricks to apply to a known "stake in the ground" period begin date whereby we can get the desired results.

Copyright © 2025 Infor. All rights reserved.