This simple view compiles information from the Turnaways module into one convenient dataset. It compiles both identified and anonymous Turnaways together, making it easier to summarize. It includes all relevant information, including reasons for service and turnaway, requested by staff, and referral information.

This view contains the following columns, pulling data from all Turnaways:

• UniqueID
  
• TurnawayID
  
• ServiceID
  
• OrganizationID
  
• ServiceProvider
  
• ClientID
  
• ClientName
  
• PrimaryClientYN
  
• CalculatedNoPeople
  
• UserEnteredNoPeople
  
• ReasonForService
  
• ReasonForTurnaway
  
• RequestedBy
  
• ReferredByName
  
• ReferredFrom
  
• ReferredTo
  
• Comments
  
• ViewVersion

Documentation

• vw_ACRE_Turnaways - Sample Output.csv
• vw_ACRE_Turnaways - Schema.csv