Administrator Reports

[HUDX-234-AD] HMIS Statistics Report

Purpose

While the HMIS Statistics Report is not an official HUD specified report, it can be used for obtaining certain statistics for HMIS project APR reporting.

Running the Report

Who Can Run the Report

System administrators and users with additional access can run the HMIS Statistics Report.

Report Location

This report is found in the Administrator Reports section in the Report Library.

Parameters

The following parameters are required to run this report.

Parameter Description

CoC(s)

Choose which CoC(s) to include:

  • Single select for a single CoC 
  • Ctrl or Shift select for multiple CoCs

Agency Status

All, Active or Inactive

Agency(-ies)

Agencies with Programs in the selected CoC(s) will display.

Choose which agency(-ies) to include: 

  • All
  • Single select for a single agency 
  • Ctrl or Shift select for multiple agencies

Program Type

Choose which program type(s) to include: 

  • All
  • Single select for a single program type
  • Ctrl or Shift select for multiple program types

Program Status

All Programs, Active Programs or Inactive Programs 

Program(s)

Programs in the selected Agencies and CoC(s) will display.

Choose which program(s) to include: 

  • All
  • Single select for a single program
  • Ctrl or Shift select for multiple programs

Report Date 

Choose the date of point-in-time counts for the report.

Report Output Format

Choose to format the report as a Web Page, PDF or Excel.

Drilldown Output Format

Choose to format the drilldown output as a Web Page, Excel or CSV. 

Please note, drilldowns with more than 20,000 rows will automatically return as an Excel workbook.

 

Specifications

Users

  • Count of Users where
    • (Agency in the selected CoC(s) OR Agency includes programs in the selected CoC(s)) AND
    • User was added before/on the [Report Date] AND
    • User is not deleted

Client Records

  • Count of Unique Client IDs where
    • Client is not deleted AND

    • Client was created before/on [Report Date] OR
      Client Note was added before/on [Report Date] OR
      Client File was added before/on [Report Date] OR
      Client Assessment was added before/on [Report Date] OR
      Client Referral was added before/on [Report Date] OR
      Client Reservation was added before/on [Report Date] OR
      Client Service was added before/on [Report Date] OR
      (Client has Project Stay active before/on [Report Date] AND [HoH’s Most Recent Location] is in the selected CoC(s))

Drilldown Functionality

Drilldown functionality is available for this report.

For Users, the drilldown includes:

  • User Agency Name
  • Additional Agency Access Agency Name
  • User Full Name
  • Username

For Client Records, the drilldown includes:

  • Unique Identifier
  • Client Full Name
  • SSN (xxx-xx-####)
  • Date of Birth

Updated 3/02/2021