...
- 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
...
active