GHR field for last date an employee was paid - not terminated employees

unknown

We want to automate a listing of all employees in GHR who have received a payment via S3 payroll during the last 90 days.  Is there an easy field to grab with the last (most recent) payment date for an employee?

--- very new at IPA.  I have decent experience with Crystal and Lawson S3 database

unknown

In IPA Process Designer, you can use the SQL Query node under Data to query the PRCHECK table in S3 to obtain the EMPLOYEE and MAX(CHECK_DATE) for the desired date range. For each record returned, you can use EMPLOYEE to obtain the GHR data you need using the Landmark Transaction node under Landmark. You could also join the S3 and Landmark tables in the SQL query if your database allows that.