LSA & SPM Data Preparation Guide
This guide is designed to help users complete data quality cleanup in preparation for the LSA and SPM.
Table of Contents
LSA & SPM Data Preparation Guide
What Projects does this affect?
- Emergency Shelters (ES) - Entry/Exit based (E/E)
- Emergency Shelters (ES) - Night-by-Night Based (NbN)
- Permanent Supportive Housing (PSH)
- Permanent Housing: Housing Only (PH-H)
- Permanent Housing: Housing with Services (PH-S)
What is the LSA?
The Longitudinal Systems Analysis (LSA) is a federal report submitted to HUD that informs the Annual Homelessness Assessment Report to Congress (for more, see this page on the HUD Exchange). While ICA will run the LSA on behalf of the CoCs, we need your help in ensuring that the data in the report is as accurate as possible.
What is the SPM?
The System Performance Measures (SPM) is a federal report submitted to HUD that examines the performance of the local coordinated system of homeless assistance programs (for more, see this page on the HUD Exchange). While ICA will run the SPM on behalf of the CoCs, we need your help in ensuring that the data in the report is as accurate as possible.
What projects does this affect?
The LSA and SPM pull data from specific continuum projects, regardless of funding source. The chart below indicates whether your specific project type participates in each. If you're unsure whether you have one of these project types, contact the helpdesk. We'll be happy to help you figure it out.
| Project Type | LSA | SPM |
| Street Outreach (SO) |
No | Yes |
| Emergency Shelter (ES) - Entry/Exit (E/E) |
Yes | Yes |
| Emergency Shelter (ES) - Night-by-Night (NbN) |
Yes | Yes |
| Safe Haven (SH) |
Yes | Yes |
| Transitional Housing (TH) |
Yes | Yes |
| Rapid Rehousing (RRH) |
Yes | Yes |
| Permanent Supportive Housing (PSH) |
Yes | Yes |
| Permanent Housing: Housing Only (PH-H) |
No | Yes |
| Permanent Housing: Housing with Services (PH-S) |
No | Yes |
What do I need to do?
That depends on the types of project(s) you have, and if you have an emergency shelter, whether it is an entry/exit based or night-by-night based shelter. If you're not sure which project type(s) you have, contact the helpdesk for assistance - we're happy to help!
Street Outreach (SO)
- Run these reports. The links will take you to specific guides on how to run and utilize the report.
- Canned Report: Data Quality Framework
- Report Dates: 10/1/2023 - 9/30/2024
- BusinessObjects Reports:
- Last Date of Contact Report for Street Outreach and Supportive Services Only
- Head of Household (HoH) and Client Location DQ Report
-
Income DQ Report (Optional: this provides detailed information on income errors that may help when using the canned Data Quality Framework)
- Canned Report: Data Quality Framework
- Use the information in the guides linked above to clean up the data to the greatest possible extent.
- Once you've confirmed that BusinessObjects is showing the projects as clean as you can get them, schedule a "final" version of the report in BusinessObjects.
- Once you've confirmed that the "final" versions of the reports are ready for review, contact the helpdesk and let us know. Your agency's system administrator will review the reports and let you know if any further action is needed on your end.
Emergency Shelters (ES) - Entry/Exit Based (E/E)
- Run these reports. The links below take you to specific guides on how to run and utilize each of the reports.
- Canned Report: Data Quality Framework
- Report Dates: 10/1/2023 - 9/30/2024
- BusinessObjects Reports:
- LSA Client Served Report
- Head of Household (HoH) and Client Location DQ Report
- Income DQ Report (Optional: this provides detailed information on income errors that may help when using the canned Data Quality Framework)
- Canned Report: Data Quality Framework
- Use the information in the guides linked above to clean up the data to the greatest possible extent.
- Once you've confirmed that BusinessObjects is showing the projects as clean as you can get them, schedule a "final" version of the report in BusinessObjects.
- Once you've confirmed that the "final" versions of the reports are ready for review, contact the helpdesk and let us know. Your agency's system administrator will review the reports and let you know if any further action is needed on your end.
Emergency Shelters (ES) - Night-by-Night Based (NbN)
- Run these reports. The links below take you to specific guides on how to run and utilize each of the reports.
- Canned Report: Data Quality Framework
- Report Dates: 10/1/2023 - 9/30/2024
- BusinessObjects Reports:
- LSA Client Served Report
- Head of Household (HoH) and Client Location DQ Report
- NBN Shelter Clients with Exit Errors
- NBN Shelter Clients without Entries
- Income DQ Report (Optional: this provides detailed information on income errors that may help when using the canned Data Quality Framework)
- Canned Report: Data Quality Framework
- Use the information in the guides linked above to clean up the data to the greatest possible extent.
- Once you've confirmed that BusinessObjects is showing the projects as clean as you can get them, schedule a "final" version of the report in BusinessObjects.
- Once you've confirmed that the "final" versions of the reports are ready for review, contact the helpdesk and let us know. Your agency's system administrator will review the reports and let you know if any further action is needed on your end.
Safe Havens (SH)
- Run these reports. The links below take you to specific guides on how to run and utilize each of the reports.
- Canned Report: Data Quality Framework
- Report Dates: 10/1/2023 - 9/30/2024
- BusinessObjects Reports:
- LSA Client Served Report
- Head of Household (HoH) and Client Location DQ Report
- Income DQ Report (Optional: this provides detailed information on income errors that may help when using the canned Data Quality Framework)
- Canned Report: Data Quality Framework
- Use the information in the guides linked above to clean up the data to the greatest possible extent.
- Once you've confirmed that BusinessObjects is showing the projects as clean as you can get them, schedule a "final" version of the report in BusinessObjects.
- Once you've confirmed that the "final" versions of the reports are ready for review, contact the helpdesk and let us know. Your agency's system administrator will review the reports and let you know if any further action is needed on your end.
Transitional Housing (TH)
- Run these reports. The links below take you to specific guides on how to run and utilize each of the reports.
- Canned Report: Data Quality Framework
- Report Dates: 10/1/2023 - 9/30/2024
- BusinessObjects Reports:
- LSA Client Served Report
- Head of Household (HoH) and Client Location DQ Report
- Income DQ Report (Optional: this provides detailed information on income errors that may help when using the canned Data Quality Framework)
- Canned Report: Data Quality Framework
- Use the information in the guides linked above to clean up the data to the greatest possible extent.
- Once you've confirmed that BusinessObjects is showing the projects as clean as you can get them, schedule a "final" version of the report in BusinessObjects.
- Once you've confirmed that the "final" versions of the reports are ready for review, contact the helpdesk and let us know. Your agency's system administrator will review the reports and let you know if any further action is needed on your end.
Rapid Rehousing (RRH)
- Run these reports. The links below take you to the specific guides on how to run and utilize each of the reports
- Canned Report: Data Quality Framework
- Report Dates: 10/1/2023 - 9/30/2024
- BusinessObjects Reports:
- LSA Client Served Report
- Head of Household (HoH) and Client Location DQ Report
- Income DQ Report (Optional: this provides detailed information on income errors that may help when using the canned Data Quality Framework)
- Canned Report: Data Quality Framework
- Use the information in the guides linked above to clean up the data to the greatest possible extent.
- Once you've confirmed that BusinessObjects is showing the projects as clean as you can get them, schedule a "final" version of the report in BusinessObjects.
- Once you've confirmed that the "final" versions of the reports are ready for review, contact the helpdesk and let us know. Your agency's system administrator will review the reports and let you know if any further action is needed on your end.
Permanent Supportive Housing (PSH)
- Run these reports. The links below take you to specific guides on how to run and utilize each of the reports.
- Canned Report: Data Quality Framework
- Report Dates: 10/1/2023 - 9/30/2024
- BusinessObjects Reports:
- LSA Client Served Report
- Head of Household (HoH) and Client Location DQ Report
- Income DQ Report (Optional: this provides detailed information on income errors that may help when using the canned Data Quality Framework)
- Canned Report: Data Quality Framework
- Use the information in the guides linked above to clean up the data to the greatest possible extent.
- Once you've confirmed that BusinessObjects is showing the projects as clean as you can get them, schedule a "final" version of the report in BusinessObjects.
- Once you've confirmed that the "final" versions of the reports are ready for review, contact the helpdesk and let us know. Your agency's system administrator will review the reports and let you know if any further action is needed on your end.
Permanent Housing: Housing Only (PH-H)
- Run this report. The link will take you to the specific guide on how to run and utilize the report.
- Canned Report: Data Quality Framework
- Report Dates: 10/1/2023 - 9/30/2024
- BusinessObjects Reports:
- Head of Household (HoH) and Client Location DQ Report
- Income DQ Report (Optional: this provides detailed information on income errors that may help when using the canned Data Quality Framework)
- Canned Report: Data Quality Framework
- Use the information in the guides linked above to clean up the data to the greatest possible extent.
- Once you've confirmed that BusinessObjects is showing the projects as clean as you can get them, schedule a "final" version of the report in BusinessObjects.
- Once you've confirmed that the "final" versions of the reports are ready for review, contact the helpdesk and let us know. Your agency's system administrator will review the reports and let you know if any further action is needed on your end.
Permanent Housing: Housing with Services (PH-S)
- Run this report. The link will take you to the specific guide on how to run and utilize the report.
- Canned Report: Data Quality Framework
- Report Dates: 10/1/2023 - 9/30/2024
- BusinessObjects Reports:
- Head of Household (HoH) and Client Location DQ Report
- Income DQ Report (Optional: this provides detailed information on income errors that may help when using the canned Data Quality Framework)
- Canned Report: Data Quality Framework
- Use the information in the guides linked above to clean up the data to the greatest possible extent.
- Once you've confirmed that BusinessObjects is showing the projects as clean as you can get them, schedule a "final" version of the report in BusinessObjects.
- Once you've confirmed that the "final" versions of the reports are ready for review, contact the helpdesk and let us know. Your agency's system administrator will review the reports and let you know if any further action is needed on your end.
What if...?
If you get stuck, if something doesn't look right, or if you have any questions; you're always welcome to contact the helpdesk for assistance. An ICA System Administrator will respond to your request for assistance, usually within 2 helpdesk hours (8 am to 5 pm, Monday thru Friday). If you'd prefer to talk to an ICA System Administrator via telephone instead of email, we ask that you send an email to the helpdesk asking us to call you (remember to include your phone number) and we'll call you as soon as we are able.
Copyright 2024 Institute for Community Alliances. All Rights Reserved.