...
- status =
active - current_time < expiration_date (inserted_at + SERVICE_REQUEST_EXPIRATION_DAYS (7 365 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