[HUDX-111] HUD CSV / XML Program Data Export (RHY CSV Instructions)

Report Purpose and Summary  

RHY repository uploads are required at regular intervals set by the the Department of Health and Human Services. This guide will show you the steps to follow in HMIS to retrieve the file to upload to your repository (RHYMIS).

Instructions 

Make sure you are operating in Clarity under the agency you are running the report for. You can check and change this under your name in the top right corner.


Step 1: Click on the Launchpad, then click on the Reports icon.  

 

Step 2: In the Report Library, click the down arrow next to the HUD Reports folder to expand the section.  

Step 3: Click the Run button next to [HUDX-111] HUD CSV / XML Program Data Export.

 

Reporting Parameters

Reporting Parameters

Step 4: Enter the following parameters. The following parameters apply to both RHY and SSVF requests.

Switch Access Agency(-ies)

Select your agency

CoC Filter Category

Select Agency CoC

CoC(s)

Select CoC(s) the program is in (hold either control/command/shift button to select multiple)

Program Type(s)

Choose the Program Type(s) being reviewed (hold either control/command/shift button to select multiple)

 

Program Status

Select Active Programs

 

Program(s)

Choose the appropriate Program(s) (hold either control/command/shift button to select multiple)

 

Apply Client Location Filter

Select No

 

PIT Date

Optional leave blank

 

Date From

Start date of reporting period

 

Date To

The date you are running the report

 

Version

Auto-populated field leave as is

 

Source Type

Select Continuum-operated HMIS

 

Encrypt Identifying Data

RHY Select Yes

 

Include Deleted Data

Select No

Include Service Item ID

Select No

 

Include Assessment Screen ID

Select No

 

Include Custom Services

Select No

 

Report Output Format

Select CSV Format

 

Step 5: Click submit

The file will be sent to the Report Queue. Once the report is processed, you will receive a notification that the report is ready.

 

To open the report, either select Open on the popup or click the Queue icon and then click Open.

Step 6: Save the .csv file on your computer and upload the file to the appropriate repository.

 

Important Note: Do not open or alter any of the information in the .csv file.

Reporting Details

The export is simply a series of CSV formatted tables that are zipped together and uploaded to the RHY or SSVF repositories. Within the zip file there will be the following tables:

  • Export File
    • Export.csv
  • Project Descriptor Files
    • Organization.csv
    • User.csv
    • Project.csv
    • Funder.csv
    • ProjectCoC.csv
    • Inventory.csv
    • Affiliation.csv
  • Client File
    • Client.csv
  • Enrollment Files
    • Enrollment.csv
    • EnrollmentCoC.csv
    • Exit.csv
    • IncomeBenefits.csv
    • HealthAndDV.csv
    • EmploymentEducation.csv
    • Disabilities.csv
    • Services.csv
    • CurrentLivingSituation.csv
    • Assessment.csv
    • AssessmentQuestions.csv
    • AssessmentResults.csv
    • Event.csv
    • YouthEducationStatus.csv

It is critical that the contents of the zip file ARE NOT CHANGED. If the contents are changed, likely there will be a problem with uploading the file to the repository. The name of the zip file can be changed, but nothing else.


Related Resources:

RHY funded projects

SSVF funded projects

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.