paycheck dates

I don't believe there is a file with future paycheck dates. Once the payment is closed, it is in PRCHECK and it seems as if one other but off the top of my head I can't remember. In our company, for a regular payroll, the check date is usually 5 days after the pay end but for one affiliate, that changes if a holiday interferes.

You can look at these and see if they help. PROVERTIME
PROTPAYPRD
PROTWRKPRD

There is not a file that contains "pay check dates" as that date could be any day. When I have had to do things like this I have used the PROTPAYPRD table.

If you wanted to use this table, you could supply your Period End Date on the submission form and then match up on the Period End Date. You could then pull in any "Check Date" between those two dates.

You could also have your program calculate the begin date from the date on the submission form if you pay periods are consistent. We are paid bi-weekly, so if they entered a Period End Date of 05/09/15. I would then use the API 900-INCREMENT-DATE and go back two weeks to get the period start date. Once you get the start date.... I would validate against this table making sure I had a good period date especially since the date is being manually entered an no guarantee the date is actually an Period End Date.

In some cases, I have even added logic in the 050- paragraph to validate this date there and display a message on the form if it is not a valid date and stop them from submitting the job.