...
- status =
active - expiration_date < > current_time + SERVICE_REQUEST_EXPIRATION_DAYS (7 days on prod)
- program_processing_status= NULL or new
- there is no encounter or diagnostic report in ME where incoming_referral/based_on reference service_request