Housing Reports

[HSNG-102] CoC Housing Assessment Report

Description

Type of Report

The CoC Housing Assessment Report uses Bed Inventories and Program Enrollments to report on bed availability and utilization. 

Purpose of Report

This report provides a monthly housing attendance average for each month of the reporting period for all CoC participating agencies. The four PIT (Point-in-time) dates (last Wednesday of designated month) are also provided to assist in the assessment of individual housing programs inclusion in the HIC (Housing Inventory Count) and the former AHAR (Annual Homeless Assessment Report), now derived from the LSA (Longitudinal System Analysis).

Running the Report

Who Can Run Report

Anyone can run the report but the returned information will be limited based on the access rights of the user.

Report Location

It is currently located in the Housing section of the Report Library.

Parameters

  • CoC - uses the Bed Inventory CoC
  • Project Type
    • Emergency Shelter
    • Transitional Housing
    • Permanent Supportive Housing
    • Safe Haven
    • Housing Only
    • Housing with Services
    • Rapid Re-Housing
  • Year - choose which fiscal year (10/1/#### - 9/30/####)
  • Month - choose on which month to base Average Length of Stay and Utilization Rate

If [Month] = [October, November, December], 
then [Report Start Date] = October 1, [Year]
else [Report Start Date] = October 1, [Year -1]

[Report End Date] = the last day of the selected [Month], [Year].

Specifications

The report returns the following table structure, by program.

Table Elements

  • Program Name
  • Total Available Beds 
    • Sum[Total Bed Inventory] WHERE
    • (([Bed Availability End] >= [Report Start Date] OR Is NULL) AND
    • [Bed Availability Start] <= [Report End Date])
  • Monthly average occupied beds
    • Sum[Bed Nights]/[days in the month]
      • For Night-by-night Emergency Shelter, Bed Night Services are counted
      • For all other projects, Bed Nights are the [Length of Stay during Project Stay] during the month
      • X denotes months in the future of the reporting period
  • Quarterly PIT Occupancy
    • Sum[Bed Nights] on PIT date
  • Average Length of Stay (during parameter selected Month)
    • Sum[Bed Nights]/[Number of Clients]
  • Utilization rate (during parameter selected Month)
    • Sum[Bed Nights]/(Sum[Total Bed Inventory]*[days in the month])

Updated 3/1/2021