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 can be found in the following location in the Report Library:

  • Administrator Reports → [HUDX-234-AD] HMIS Statistics Report

Parameters

The following parameters are required to run this report.

CoC(s)

Choose which CoC(s) to include:

Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)

Agency Status

  • All Agencies
  • Active Agencies
  • Inactive Agencies

Agency(-ies)

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

Choose which agency(ies) to include: 

All, Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)

Project Type

Choose which project type(s) to include: 

All, Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)

Program Status

  • All Programs
  • Active Programs
  • Inactive Programs

Program(s)

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

Choose which program(s) to include: 

All, Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)

Report Date 

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

Report Output Format

Web Page, PDF or Excel.

Drilldown Output Format

Web Page, Excel or CSV. 

Please note that 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 [Enrollment CoC] 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: 01/18/2024