SPM raw data reporting
We woulike to be able to pull full raw data (preferrably in a canned report) for the System Performance Measures. It is not convienent to click on every single data point for each measure to see the clients; further, doing so does not provide the full dataset. The SPMs in Looker have errors and are not reliable. We want to be able to match the SPM data to other reporting/characteristics, such as to report the SPM measures by demographics. See below for an example of what Wellsky is providing (this one is for Measure Two: Returns).
Personal id Client id Prior ee id Prior Provider ID Prior program type name Prior entry date Prior exit date Prior destination
fda5b771869b76470e5e9751bdd6477c 123456 1222254 Example Shelter - ES - State ESG (1825) Emergency Shelter - Entry Exit (HUD) 2024-02-16 14:18:21 UTC 2024-06-03 16:30:55 UTC Staying or living with friends, permanent tenure (HUD)