is there a way to add last run date logic in ORC Bip report

Sep 17, 2026 5:29AM

Summary:

i have this data model which sends the congrats offer template to candidates, i've used a 15 minutes window schedule , is there a way to use last run date logic for this datamodel, and it should run every 15 minutes and only should pick the latest data.
/* Congrats offer - updated */

SELECT
ppnfv.display_name AS cand_full_name,
ppnfv.first_name AS cand_FirstName,
ppnfv.last_name AS cand_lastName,
pp.person_id,
ic.candidate_number,
hapft.name AS position_name,
pea.email_address AS cand_email,
hr_coord.display_name AS hr_coordinator_name,
hr_coordper_num.person_number AS hr_coord_person_number,

is there a way to add last run date logic in ORC Bip report

Howdy, Stranger!