HUD and Federal Partner Reports

[HUDX-228] ESG CAPER

This article describes how to run the CAPER that recipients of Emergency Solutions Grant (ESG) funding are required to submit annually to HUD.

Data collection for the ESG portion of the CAPER is aligned with the most recent version of the HMIS Data Standards.

The ESG-CAPER portal also contains important information for grantees.

Programming Specifications

The consolidated specifications for the APR ([HUDX-227]) and ESG-CAPER are found at https://www.hudexchange.info/resource/4696/hmis-programming-specifications/.

The APR and ESG reporting are similar, with the APR containing additional tables that are not required for the ESG-CAPER.

Description

The ESG-CAPER is a series of tables with questions about service levels and outcomes for the funded projects. 

The final version is submitted as a zip file of CSV files. Each question in the report will have a separate CSV.

Running the Report

Preparation

We recommend that grantees run the [HUDX-225] HMIS Data Quality Report in preparation for running ESG-CAPER. This report identifies data quality problems that can be repaired before running the ESG-CAPER report.

The Data Quality Report is found in the HUD Reports section of the Clarity Human Services Report Library.

Note

The ESG-CAPER is designed to be run for one program for one year. There is an option to run the report for more than one program. The report will run under this scenario, but due to the dynamic situation of household configurations, you may see different results than expected.

There is no way to program the report to address all the possible household scenarios that may occur across programs and agencies.

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.

The Admin version of the report can be run across agencies by System Administrators and others with the appropriate access roles.

Report Location

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

  • HUD Reports → [HUDX-228] ESG CAPER
  • Administrator Reports → [HUDX-228-AD] ESG CAPER

Parameters

The following parameters are required to run this report:

Switch Access Agency(-ies)

This feature allows a user to generate the report for programs from multiple agencies. Some ESG grants require this capability. The ability is dependent on the access rights of the user. In other words, the user must have access to more than one agency.

The list of agencies will include the users primary or home agency followed other agencies for which the user has access
CoC Filter Category

Select the level of CoC filtering:

  • Agency CoC: The report will only pull from agencies within the selected CoC(s). All of the CoC selection filters have a multi-select option. To choose more than one option, select the first CoC, then Control/Command-click additional CoC(s).
  • Program CoC: The report will only pull from Programs/Projects within the selected CoC(s).
  • Site CoC: The report will only pull from Sites within the selected CoC(s).
  • Inventory CoC: The report will only pull from Bed Inventories within the selected CoC(s). Note: choosing this option will limit to only those projects with Bed Inventories.
CoC(s)

Choose which CoCs to include in the report:

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

Project Type(s)

Choose which project type(s) to include in the report:

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)

Choose which program(s) to include:

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

Apply Enrollment CoC Filter  The report can be narrowed further to only include those households from the selected CoC(s) at project entry. Click "Yes" to turn on this level of filtering.

PROGRAM BASED FUNDING SOURCE
(for Federal Partner funding sources)

Federal Funding Source Criteria
  • Not Based on Federal Funding Source
    • Select this option for most official grant submissions.
    • If this option is selected, the Federal Funding Status and Federal Funding Source(s) parameters will be hidden.
  • Based on Federal Funding Source
Federal Funding Status Choose whether to include active and/or inactive funding sources.
Federal Funding Source(s) Choose the funding source(s) to include in the report.
LEGACY FEATURE: SERVICE BASED FUNDING SOURCE
(for local, service-based, funding sources)
Funding Criteria
  • Not Based on Funding Source
    • Choose this option for most official grant submissions.
    • If this option is selected, the Funding Status and Federal Funding(s) parameters will be hidden.
  • No Funding Source
    • The report is based on funding source; however, there is no funding source assigned to services.
    • If this option is selected, the Funding Status and Federal Funding(s) parameters will be hidden.
  • Only Primary Fundings
  • Primary and Subgrant Fundings
    • The report only pulls data from services with either primary or subgrant funding sources.
Funding Status Choose whether to include active and/or inactive funding sources.
Funding(s) Choose the funding source(s) to include in the report.
Report Date Range The date range to include in the report.
Report Output Format Web Page, PDF, Excel, CSV-Upload
Drilldown Output Format Web Pate, PDF, CSV

Admin Report Additional Parameters

The administrator version does not include the Switch Agency(ies) parameter and instead includes:

Agency Status
  • All Agencies
  • Active Agencies
  • Inactive Agencies
Agency Filter Category See CoC Filter Category above
Agency(ies)

Choose which agencies to include:

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

Submitting the ESG-CAPER

Use the Sage Upload- ESG CAPER and APR article for detailed instructions for submitting to the Sage HMIS Reporting Repository. It is important that you NOT change the contents of the downloaded report. You can change the name of the file, but nothing more. Be careful not to change the file extension when changing the name of the file.

ESG-CAPER FAQ

For additional support and frequently asked questions about the ESG-CAPER, please review APR and ESG-CAPER FAQ.


Updated 01/08/2024