...
for all service requests where:
- status =
active - current_time < expiration_date > current(inserted_time at + SERVICESERVICE_REQUEST_EXPIRATION_DAYS (7 days on prodProd))
- program_processing_status= NULL or new
- there is no encounter or diagnostic report in ME where incoming_referral/based_on reference service_request