Data story: Providers holding onto cases they don't have workers for

[cbeaulaurier]

Background

One of the motivators for a paradigm shift in referrals comes from DCYF's understanding that "providers hoard referrals." The provider tries to find someone who can work the referral, rather than reporting that they don't have anyone available. There's a concern that this provider practice is causing a delay in visits.

What question are you hoping to answer with this Sprout data?
What can we see in Sprout data about providers that may be holding onto referrals? Are there patterns, like are certain providers or regions doing this more? Or is it fully widespread?

How do you hope to filter the Sprout data?
By provider, by region

Description

There's not a perfect way to look for "hoarded referrals" but we can brainstorm behavior in Sprout that might indicate a hoarded referral.
Cases we identified:

• When a provider accepts a referral and later rejects it

• When a provider accepts a referral and has a long time lag between accepting and the first visit

• Long time lag between when provider accepted a referral and provider assigned a visit supervisor at the referral level

• Data start and end date: past 3 months?

• Time granularity: (month, quarter, etc.)

• Referral types: ongoing

• Supervision level: all

• Geography: region #

• Organization: n/a

• Visit Participants: n/a

Data Needed By:
TBD at 3/10 Sprout meeting