Lately HUD has been encouraging CoC's to set objectives designed to end homelessness. I worked with the CoC committee tasked with setting the objectives to create a report that could show how each project was doing in relation to these goals. That report helped the committee get baseline data to know where projects …

Read More

While the ideal first step in writing a good custom report is writing down your plan, mapping out your queries and variables, and design, we all know the specifics in a large report can change while it is being built, and plans do not always pan out the way we intend. As a result, reports can turn into a tangled web of …

Read More

A custom report is needed- what are your first steps in building the report? A good first step is to write down exactly what you need to show, who the audience is, who will be actually running the report (if that's different), the data elements you will need to show it, what prompts will be needed, and the basic …

Read More

Sometimes we need to look at client data that represents the most recent data available on a client. For HMIS, this would translate to showing data as of an Exit Date, or, if the client had not exited the program on the last day of the reporting period, the report would use the last date of the reporting period …

Read More

For many years, our HMIS's main data quality report was pretty much the APR (except for HPRP). The conventional wisdom was "if your APR looks alright, your data must be fine." Once we started participating in the AHAR in a meaningful way, and submitting HMIS APR's and using other reports, like the NOFA, we …

Read More

There is one very big difference between hair cutting and report designing- in hair cutting, there is no going back. However if you are not careful, designing reports can be much like hair cutting, where every move you make has the potential to wreck everything. I have designed a few very large reports over the past …

Read More

Over the past couple of years, we have come to realize that between the CoC APR, the HMIS APR, the AHAR, and the NOFA, the definition of "missing" assessment data is a moving target. An agency with a completely clean APR that shows no missing data may have many many errors contributing to bad data on the NOFA …

Read More

We have had many agencies call to ask where to find a calculation of shelter nights. This means that each night a client is served in their program counts as one shelter night. It is measured between two dates, so that the nightly client count served on each night in the date range is added together to give a total …

Read More

UPDATE: Since this blog post was published, HUD has released new guidance on how to calculate this. However, I feel like this way of doing it makes a lot of sense and could be useful for folks who just want to know this kind of information for internal processes. So, use it if it suits you, but don't use it on the …

Read More

Last year, we did a giant audit of all 400 of our providers, one by one, asking grant managers and others who had more intimate knowledge of the individual projects if each one was still in business, because there were so many that were no longer in use that we couldn't tell what was what. We had some turnover in our …

Read More