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 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 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
      • Choose the month on which to base Average Length of Stay and Utilization Rate
      Report Output Format Web Page, PDF, or Excel 

      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])


      Drilldown Functionality

      Drilldown functionality is available for this report. To drill down, click on any count. The drilldown functionality will then provide the following information: 

      • Unique ID
      • Name
      • Age
      • LOS (Length of Stay)
      • Project Start Date
      • Project End Date


      Updated 3/22/2023