VSP: Sage Submissions for Comparable Databases

This article assists Victim Service Providers (VSP) utilizing comparable databases with test running and uploading the CoC-APR (Annual Performance Report designed for Continuum of Care funded projects) or ESG-CAPER (Consolidated Annual Performance and Evaluation Report) to HUD's repository, Sage. While each VSP may utilize a different software, all comparable databases are required to have the functionality to produce these reports. Since the reports are formatted the same way, uploading to Sage will follow the same process regardless of software.

If you need the CoC-APR or ESG-CAPER, or need to locate the reports within your system, please reach out directly to your software vendor as the NCCEH Data Center does not have access to VSP databases.

REPORT: COC-APR (ANNUAL PERFORMANCE REPORT)

Testing the CoC-APR Report to Sage

Go to www.sagehmis.info
On the right-hand side of the page, under the header "Test run a report", click Upload a CSV-APR or CSV-CAPER to generate a paper report.
Select CSV-APR FY2022 from the dropdown menu. Click on the Browse (or Choose File) button to select the .zip file from your computer that you downloaded in the Save/Export the Report section.
Complete the reCAPTCHA by clicking the check box that says I'm not a robot. If prompted, complete any verifications required.
Click Upload and Test
1. If Sage was unable to validate your APR, an error message will appear in red text. Make applicable corrections, or contact the Data Center if you need assistance.
2. If Sage was able to validate your APR, you will receive a message confirming the upload has passed all validations.

Submitting an Official CoC-APR Report through Sage

Go to www.sagehmis.info.
Log-in using your Sage username and password.
Upload the CSV-APR (.csv file) to Sage to review, resolve, and submit (with CoC approval)

Please see additional HUD resources for Sage below:

- Sage CoC APR Guidebook: a guidebook for HUD’s CoC APR reporting requirements
- Create an Account in Sage Video: HUD released “how-to” video demonstrating how users can set up accounts in Sage.
- Overview of the Sage HMIS Repository Webinar: HUD recording which reviews the process of setting up an account in Sage and provided guidance on HUD’s expectations for the transition from e-snaps to Sage.
- Ask A Question (AAQ) Portal: If the Primary Contact information submitted to HUD via e-snaps is out of date, Grantees need to notify HUD immediately via the AAQ and also update the Applicant Profile in e-snaps.

SPECIAL NOTE FOR USERS WITH APPLE (MAC) COMPUTERS: you cannot use the Safari web browser to download the official .csv zipfile!

REPORT: ESG-CAPER (Consolidated Annual Performance and Evaluation Report)

Testing the ESG- CAPER Report in Sage

Go to www.sagehmis.info.
On the right hand side of the page, under the header "Test run a report", click Upload a CSV-APR or CSV-CAPER to generate a paper report.
Select CSV-CAPER FY2022 from the dropdown menu. Click on the Browse (or Choose File) button to select the .zip file from your computer that you downloaded in the Save/Export the Report section.
Complete the reCAPTCHA by clicking the check box that says I'm not a robot. If prompted, complete any verifications required.
Click Upload and Test
1. If Sage was unable to validate your CAPER, an error message will appear in red text. Make applicable corrections, or contact the Data Center if you need assistance.
2. If Sage was able to validate your CAPER, you will receive a message confirming the upload has passed all validations.

Submitting an Official ESG-CAPER Report through Sage

Go to www.sagehmis.info.
Log-in using your Sage username and password.
Upload the CSV-CAPER (.csv file) to Sage to review, resolve, and submit (with CoC approval)

Please see additional HUD resources for Sage below:

Sage ESG-CAPER Guidebook: The Guidebook provides information about HUD’s ESG CAPER reporting requirements for recipients (like State DHHS or City gov) and subrecipients (individual agencies), and also instructs ESG subrecipients on uploading their ESG CAPER CSV directly into Sage.
Sage Guidance for ESG subrecipients Webinar: HUD training to review: How to upload the ESG CAPER report via Comma Separated Value (CSV) into Sage, Data flow from HMIS to Sage, Common data errors and how to resolve them, Coordination with recipients

SPECIAL NOTE FOR USERS WITH APPLE (MAC) COMPUTERS: you cannot use the Safari web browser to download the official .csv zipfile!