Housing Reports
      Back to home
      1. Clarity Human Services Help Center
      2. Report Library
      3. 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 the designated month) are also provided to assist in the assessment of individual housing programs included 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 the Report

      All users can run the report. There are restrictions on which information can be accessed based on the user's access rights.

      Report Location

      This report can be found in the following locations in the Report Library:

      • Housing  → [HSNG-102] CoC Housing Assessment Report

      Parameters

      CoC
      • Single select
      • Uses the Bed Inventory CoC
      Project Type
      • Single select
      Year
      • Single select
      • Choose which fiscal year ((10/1/#### - 9/30/####)
      Month
      • Single select
      Report Output Format Web Page, PDF, or Excel 

      The start date for the report depends on the selections made for Year and Month.

      If the selected Month is October, November, or December:

      • The start date for the report will be October 1 of the selected Year.
      • For example, if Year = 2023 and Month = November:
        • The report start date will be October 1, 2023

      If the selected Month is a month other than October, November, or December:

      • The start date for the report will be October 1 of the year before the selected Year.
      • For example, if Year = 2023 and Month = April:
        • The report start date will be Oct 1, 2022

      The end date for the report will be the last day of the selected Month in the selected Year.

      Specifications

      The report returns the following table structure, by program.

      HSNG102 Screenshot

      Table Elements

      • Program Name
      • Current Inventory (Count of Beds is linked to the Bed and Unit Inventory Information)  
        • 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 percentage
        • Sum[Bed Nights]/[days in the month]
          • For Night-by-night Emergency Shelter: Total bed nights clients have for the program within the month.
          • For Entry Exit Emergency Shelter, Transitional Housing, and Safe Haven: Total days clients were enrolled in the program within the month is used for "Bed Nights".  
          • For Permanent Housing Programs: Total days on/after the housing move-in date clients were enrolled in the program within 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])


      Drilldown Functionality

      Drilldown functionality is available for this report. To drilldown, click on any count.

      The drilldown functionality will then provide the following information for counts related to utilization: 

      • Unique ID
      • Name
      • Age
      • HMIS LOS (Length of Stay)
      • LOS within Month
      • Project Start Date
      • Project End Date
      • Total Clients
      • Total HH (Households)

      image-20230708-172330


      Updated: 01/19/2024