Night-by-Night (NbN) Shelter Clients without Entries

This report helps users identify clients who:

have stayed at Night-by-Night shelters and need to have an Entry/Exit created; or
have an Entry/Exit recorded in a Night-by-Night shelter and need to have a Shelter Stay recorded or have their Entry/Exit deleted

When should clients have an entry/exit for a NbN shelter?

Clients must have an entry/exit around all nights of stay recorded in the system.

When should clients have a shelter stay for a NbN shelter?

All clients must have nights of stay recorded within their entry/exit. If the client never actually stayed at the shelter, the entry/exit must be deleted.

Specifically, this report looks at:

Each individual shelter stay to determine whether it is within an entry/exit record and provides entry dates for those clients who need to have entry/exits created; and
Each individual entry/exit to determine if there are any shelter stays recorded.

Running the Report

Report Path

Folders
> Public Folder
> missouri_live_folder
> Data Quality and Completeness Reports
> NbN Shelter Clients without Entries or Shelter Stays

Recommended Export Format

Schedule to Microsoft Excel - Reports

Setting the Prompts

Prompt	Instructions
Select Provider(s):	Select the provider(s) for which you wish to run the report. Note: If this prompt is completed, the "Select Reporting Group(s)" prompt must be left incomplete (blank).
Select Reporting Group(s):	Select the reporting group(s) for which you wish to run the report. Note: If this prompt is completed, the "Select Provider(s):" prompt must be left incomplete (blank).
Select CoC Code(s):	This prompt is for use by ICA System Administrators only. Leave set to "none selected."
Show Client Names?	Select "Yes" if client names should be displayed in the report, and "No" if the client names should be hidden in the report. Important! If you include client names when you run this report, then the report cannot be emailed (even within agencies) unless encrypted, nor can it be shared outside of the agency.
EDA Provider	If only one project is selected in "Select Provider(s):" above, select the same project here. If more than one project is selected in "Select Provider(s):" or if one or more reporting group has been selected in "Select Reporting Group(s):", then select one of the projects within the selected projects or reporting groups.
Report Start Date:	Enter the start date for the reporting period in M/d/yyyy format. For example, if you're running a report for 7/1/2021-6/30/2022, the date entered in this box would be 7/1/2021.
Report End PLUS 1 Day:	Enter the date after the last date of the reporting period in M/d/yyyy format. For example, if you're running a report for 7/1/2021-6/30/2022, the date entered in this box would be 7/1/2022.

Using the Report

This report has four tabs, each serving a specific purpose.

Summary

The summary tab contains two tables showing all projects included in the report. The table shows the number of clients with night-by-night shelter stays as well as the number of clients without an entry/exit.

Missing EE Detail

This table is split into sections by provider if the report is run for more than one provider. The column "First Shelter Stay Night" shows the date which should be used as a back date when creating the project start portion of the entry/exit. All clients who appear in this report need to have an entry/exit created. The report does not show clients who have an entry/exit properly created.

Missing Shelter Stays Detail

This table is split into sections by provider if the report is run for more than one provider. If the client did stay at the shelter, the column "First Entry Date Night" shows the date which should be used as a back date when creating the first shelter stay for this client. If the client never actually stayed at the shelter must have their entry/exit deleted.

Note: A client may show up on this report as not having a shelter stay when in fact they had shelter stays recorded that were before the report period. To check, re-run the report with an earlier Start Date.

Additional Information

This tab contains information about the report that can be utilized by ICA staff to determine whether the report was run properly by the user. If you seek assistance with this report from the ICA Missouri Helpdesk, please be prepared to read/send information off of this tab to the individual who assists you.

Need Assistance?

If you need assistance running the report, understanding the information in the report, or troubleshooting potential errors, please reach out to the ICA Missouri Helpdesk. Include the name and date of the BusinessObjects report as it appears in your BI Inbox in your request for assistance. Do not attach the report to any emails going to the helpdesk as the report contains personally identifying information and cannot be transmitted unless encrypted.