[HUDX-234-AD] HMIS Statistics Report – Bitfocus

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