This view pulls in data from over 30 fields that are relevant to Diversions, so you have an easy way to reference everything you need, all in one place. It includes all fields from the Diversion module, along with a calculated field to determine whether the Diversion was successful or not.

As a bonus, we're throwing in a free sample report that'll work with this dataset. It's designed for you to play with and make your own, so it's not terribly fancy. Make something beautiful with it!

This view contains the following columns, pulling data from the Diversion module:

• DiversionID

• PrimaryClientID

• ClientID

• AnonymousID

• PrimaryClientTF

• ClientName

• Gender

• AgeAtDiversion

• AgeGroup

• OrganizationID

• OrganizationName

• DiversionDateTime

• ReasonForService

• ReferredFrom

• ReferredTo

• HousedSafelyLastNightTF

• CaseWorkerID

• CaseWorkerName

• Minutes

• ProgramID

• Program

• FinancialAssistanceProvidedTF

• GoodsServicesProvidedTF

• GoodsActivitiesID

• ExpectedDestination

• DiversionNextSteps

• ScheduledFollowUpDate

• DiversionStory

• Comments

• DiversionResult_Manual

• DiversionResult_ACRE

• ViewVersion

Documentation

• vw_ACRE_Diversion - Schema.csv

• Sample Report for Use with Diversion Dataset - Sample Output.pdf