LSA & SPM Data Preparation Guide

This guide is designed to help users complete the necessary steps of data preparation for the LSA and SPM.

LSA & SPM Data Preparation Guide
What is the LSA?
What is the SPM?
When do I have to have data cleanup completed?
What Projects does this affect?
What do I need to do?
- Street Outreach (SO)
- Emergency Shelters (ES) - Entry/Exit based (E/E)
- Emergency Shelters (ES) - Night-by-Night Based (NbN)
- Safe Havens (SH)
- Transitional Housing (TH)
- Rapid Rehousing (RRH)
- Permanent Supportive Housing (PSH)
- Permanent Housing: Housing Only (PH-H)
- Permanent Housing: Housing with Services (PH-S)
How should I submit the reports?
Training Materials
What if...?

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. So, we would like to build on the ongoing data cleanup you regularly do by asking you to run the following data quality reports for FY2022 (10/1/2021-9/30/2022).

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. So, we would like to build on the ongoing data cleanup you regularly do by asking you to run the following data quality reports for FY2022 (10/1/2021-9/30/2022).

When do I have to have data clean up completed?

While HUD hasn't yet released the official LSA deadline, they are anticipating that submission will begin in early November. The SPM submission will likely occur later this fall or early Winter. Therefore, we are asking you to complete your data clean up no later than 5 pm on Monday, October 31, 2022.

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/2021 - 9/30/2022
- 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)
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/2021 - 9/30/2022
- 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)
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/2021 - 9/30/2022
- 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)
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/2021 - 9/30/2022
- 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)
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/2021 - 9/30/2022
- 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)
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/2021 - 9/30/2022
- 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)
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/2021 - 9/30/2022
- 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)
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/2021 - 9/30/2022
- 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)
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/2021 - 9/30/2022
- 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)
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.

How should I submit the reports?

Run the report and clean up any data quality issues that are noted. Once you have a clean copy of the report, please:

Schedule the report and save it to your BusinessObjects inbox. Give it a name with the project name and the date run (e.g., LSA Client Served Report for ABC Shelter - 10132022)
Notify the helpdesk by sending an email to mohmis@icalliances.org that includes the names of the reports in your BusinessObjects inbox. Your system administrator will view the report to verify your data and follow up if necessary.

Training Materials

Slides from the training webinars can be found here.

Training Webinar Recording

Video password available from the helpdesk.

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.