This report was developed for the City of Ottawa to show a list of all clients that had stayed in selected shelter(s) during a specified date range. The report lists clients, grouped by household, and displays each client's family role for that household, along with each family member's date of birth, admission date, and discharge date. 

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.