Family Stays Dataset

Data Wrangling Project

The view combines data from the Admissions module and also the Families module. The following logic is used: when the client booked in, were they in a family? And if so, did any other members of the same family book in at the same shelter at the same time? If the answer to both of these questions is a yes, then the stay is interpreted as a family stay. Household size and number of dependents are calculated based on this logic.

The dataset also includes foreign keys that can easily be linked with other client and service data.

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!

vw_ACRE_Stays_Family - Sample Output

The view contains the following columns, pulling data from all services that have a Program recorded:

  • StayID
  • ServiceID
  • FamilyStayID
  • DateStart
  • DateEnd
  • OrganizationID
  • OrganizationName
  • ClientID
  • ClientFullName
  • Gender
  • DOB
  • AgeAtBookIn
  • FamilyStayType
  • SingleID
  • FamilyID
  • HouseholdID
  • FamilySize
  • NonDependents
  • Dependents
  • FamilyRole
  • FamilyHeadClientID
  • FamilyHeadName


vw_ACRE_Stays_Family - Sample Output