HUD and Federal Partner Reports

[HUDX-231-AD] LSA Quick Guide

Overview

The Longitudinal System Analysis (LSA) export is a requirement from HUD which replaces the Annual Homeless Assessment Report (AHAR).

The LSA export from Clarity Human Services is not intended to be in a format that is usable, as is, for informing communities. HUD's intention is to have a reporting end product available from HDX following upload to HDX 2.0. The most recent LSA Summary Display Table Shells are available within the resources section on the HUD Exchange. 

Export Format

The LSA export is similar to the standard HUD HMIS CSV export. Output from Clarity will be in the form of a zipped set of CSV files.

The first group are files specific to the LSA:

  • LSACalculated.csv
  • LSAExit.csv
  • LSAHousehold.csv
  • LSAPerson.csv
  • LSAReport.csv

The second group files are generated in both the HUD HMIS CSV export and LSA export and contain project description data:

  • Funder.csv
  • Inventory.csv
  • Organization.csv
  • Project.csv
  • ProjectCoC.csv

Generating LSA Export

Three versions of the export will be available:

  • [HUDX-231-AD] LSA Export (Administrator Reports) - This systemwide version will be uploaded to HDX 2.0 and should only be run by system administrators
  • [HUDX-231] LSA Export (HUD Reports) - This is a project-based version that can be used by agencies to check their data
  • [HUDX-236] LSA - Project Descriptor HDX Upload Test. There is also an Admin version of this report available.

    This report can be used to prepare for HDX upload without running client data. The purpose is to identify project descriptor issues.

    1. Run the report for the selected CoC
    2. Upload to HDX per instructions received from HUD.
    3. An error report will be returned in HDX:


      LSA
    4. Ignore the missing_files error, this is intentional because the client data was not run
    5. Review and repair any project descriptor errors that are reported in the error report

    Once all project descriptor errors are corrected, then run the main LSA report: [HUDX-231-AD] LSA Export - Systemwide.

Systemwide Export

  1. Navigate to the Administrator Reports folder, [HUDX-231-AD] LSA Export, Run
  2. CoC: Choose the CoC to be included in the report
    • Programs will be included if the selected CoC was chosen for the program
    • If an expected program is not included, edit the Program in Clarity, add the appropriate CoC code(s)
  3. Report Date Range
    • For example, for FY 2021 submission use 10/01/2020-09/30/2021
  4. OK
  5. Once complete, the report will be delivered as a zipped set of CSV files

The export will take some time to run. 2-3 hours for large CoCs, 30-40 minutes for smaller CoCs. Please do not run multiple copies. The export is processing a very large set of data.

Project-based Export

  1. Navigate to the HUD Reports folder, [HUDX-231] LSA Export, Run
  2. CoC: Choose the CoC to be included in the report
    • Programs will be included if the selected CoC was chosen for the program
    • If an expected program is not included, edit the Program in Clarity, add the appropriate CoC code(s)
  3. Agency Status: Choose whether to include inactive agencies
    • The LSA looks back through three years of enrollment data, be sure to include any agency that was active during the three year period
  4. Agencies: Choose agencies to include
    • Agencies will be included depending on the access level of the user running the export
  5. Program Status: Choose whether to include inactive programs
    • The LSA looks back through three years of enrollment data, be sure to include any program that was active during the three year period
  6. Program Type: Select the type of projects to include in the export
  7. Programs: Choose programs to include
  8. Report Date Range
    • For example, for FY 2021 submission use 10/01/2020-09/30/2021
  9. OK
    • For large CoCs, the processing time may be as much as 3 hours
    • For most CoCs, the processing time should be around 20-30 minutes
    • Please only run the export once and allow the processing to complete before starting another export
  10. Once complete, the report will be delivered as a zipped set of CSV files

Upload to HDX 2.0

Only the Systemwide LSA is to be uploaded to HDX 2.0.

The zipped CSV files that will be uploaded to HDX 2.0 should never be modified.

  • Only the zip file name can be modified.
  • If the CSV files are manually changed, problems are likely to be created.
  • Fix the data in Clarity. That is the only way to correct problems.

For details about submitting the LSA export to HDX 2.0, review Overview of the LSA Submission Process

Data Quality Clean-up

Four LSA Data Clean Up Dashboards have been created to assist with LSA preparation. More information on these four dashboards can be found in the 2021 LSA Toolkit article.

The four dashboards include:

  • LSA Data Cleanup: HoH Data
    • This dashboard contains looks related to common issues surrounding the head of household (HoH) data including program enrollments without an HoH.
  • LSA Data Cleanup: Funding Source, Bed Inventory, CoC Configuration
    • This dashboard contains looks for common LSA errors around funding sources, bed inventory, and potential CoC Configuration issues.
  • LSA Data Cleanup: Geocode, Project Descriptor, Length of Stay, and Utilization
    • This dashboard contains looks to help locate errors around geocode, project descriptors, length of stay, and utilization issues.
  • LSA Data Cleanup: Overlapping Enrollments
    • The dashboard contains multiple looks to help drill down on overlapping enrollments. Please note that due to the complexity of these looks, this dashboard might take a little longer to load.

Data Dictionary

The latest data dictionary for the LSA export can be found on HUD Exchange. The dictionary may be a helpful resource in understanding the information included in the export.

Additional Resources

The following are links to additional HUD Exchange resources.

 

Updated 11/02/2021