Program Management (Retired)

This dashboard was designed to give managers and stakeholders insight into exit outcomes of program participation as well as the populations served by the program.

The Program Management dashboard will be available in the LookML dashboards mid-June, 2021.

Included Tiles

Unless otherwise noted, all tiles are from the HMIS Performance model.

Exit Housed

This tile displays the percentage of exits where the client exited to a permanent housing destination. Refer to HMIS Data Dictionary, Appendix A for a list of destinations.

Fields

• Custom Measures
  • Exited Clients
    • Under the Enrollments view, Count, click on the 
      • Click on Filter Measure
      • Change the name to "Exited Clients"
      • Paste the following into the formula area: 

• • • • Save the measure
      • Hide from the visualization

• Housed on Exit Count
  • Repeat the above but name the field "Housed on Exit Count"
  •  Formula:

• • • Hide from the visualization
• Table Calculation
  • Create a Table Calculation:
    • "Percent Housed on Exit":

Filters

• Enrollments, Reporting Period Filter: is in the past 12 complete months

Visualization

This tile uses a Liquid Fuel Gauge visualization.

Exit w/Known Destination

This tile shows the percent of exits with a known destination.

Fields

• DQ Client UDE, Destination Error Count - Hide from the visualization
• Custom Measure
  • Using the method described in Exit Housed to create a measure for "Exited Clients" 

• • • • Hide from the Visualization
• Table Calculations
  • Exited with Known Destination

• • Hide from the visualization
• Percent Exited with Known Destination

Filters

• Enrollments, Reporting Period Filter: is in the past 12 complete months

Visualization

This tile uses a Liquid Fuel Gauge visualization.

Exit w/Income Increase >= $100

This tile shows the percent of exits with a known destination.

• Fields
  • Custom Measure
    Using the method described in Exit Housed to create a measure for "Exited Clients"

• • • • Hide from the visualization

• Table Calculations
  • Increase Income by >=$100

• • • • Hide from the visualization
• Percent Increased Income by >=$100

Filters

• Enrollments, Reporting Period Filter: is in the past 12 complete months
• Programs, Tracking Method: is not equal to Night-by-Night
• Custom Filter:

Visualization

This tile uses a Liquid Fuel Gauge visualization.

Filters

• Enrollments, Reporting Period Filter: is in the past 12 complete months
• Programs, Tracking Method: is not equal to Night-by-Night
• Custom Filter:

Visualization

This tile uses a Liquid Fuel Gauge visualization.

Average Total Cash Income

This tile returns the mean and median income amounts for those that have exited the program. 

Fields

• Update/Exit Screen, Average Cash Income (mean)

• Custom Measure:
  • Median of Total Cash Income
    • From the Dimension for Update/Exit Screen, Total Cash Income, click on
    • Choose Median

Filters

• Enrollments, Reporting Period Filter: is in the past 12 complete months
• Programs, Tracking Method: is not equal to Night-by-Night
• Custom Filter:

Visualization

This tile uses a simple Column chart to display the results.

Harder to Serve Target Populations

This tile identifies the percentage of clients from collection of target populations which may be considered more difficult to serve.

Fields

Most of the fields start with a standard HMIS Data element and then calculate the percentage of households in that target population.

• Entry Screen, Count Households - hide the measure from the visualization
• Custom Measures 
  • Using a method similar to Exited Housed, create Count Mental Illness
    • Under the Entry Screen view, Count Households, click on the gear 
      • Click on Filter Measure 
      • Change the name to "Count Mental Illness"
      • Paste the following into the formula area: 

• • • • Save the measure
      • Hide from the visualization
  • Repeat for Count Alcohol Abuse

• • • • Hide from the visualization
  • Count Drug Abuse

• • • • Hide measure
  • Count Both Alcohol and Drug Abuse

• • • • Hide measure
  • Count Chronic Health Condition

• • • • Hide measure
  • Count HIV

• • • • Hide measure
  • Count Developmental Disabilities

• • • • Hide measure
  • Count Physical Disabilities

• • • • Hide measure
  • Count Domestic Violence

• • • • Hide measure
  • Count Unaccompanied under age 18

• • • • Hide measure

• • • Count Unaccompanied TAY age 18-24 year

• • • • • Hide measure
• Table Calculations
  • Create percent calculations for each of the target populations
  • Mental Illness

• • Alcohol Abuse

• • Drug Abuse

• • Both Alcohol and Drug Abuse

• • Chronic Health Condition

• • HIV

• • Developmental Disabilities

• • Physical Disabilities

• • Domestic Violence

• • Unaccompanied Youth under age 18

• • Unaccompanied TAY age 18-24

Filters

• Enrollments, Reporting Period Filter: is in the past 12 complete months

Visualization

This tile is a simple horizontal bar chart.

Household Challenges

This tile goes hand-in-hand with Harder to Serve Target Populations. It looks at the percent of households belonging to 1 or more of the Target Populations. It also provides the percent of Households with Challenges.

Fields

• Entry Screen, Count Households - Hide from visualization
• Custom Measures
  • Under the Entry Screen view, Count Households, click on the gear
    • Click on Filter Measure 
    • Change the name to "Count of 1 Target Population"
    • Paste the following into the formula area: 

• • • Save the measure
    • Hide from the visualization
  • Repeat for Count of 2 Target Populations

• • • Hide the measure
  • Repeat for Count of 3 or More Target Populations

• • • Hide the measure
• Table Calculations
  • % of Households meeting any THREE or More Target Populations

• • % of Households meeting any TWO Target Populations

• • % of Households meeting any ONE Target Populations

• • Total % of Households w/Challenges

Filters

• Enrollments, Reporting Period Filter: is in the past 12 complete months

Visualization

This tile is a horizontal bar chart.

Percent of Enrollments W/O Data Quality Errors

Model: Data Quality

Fields

• Enrollments, Count - Hide from visualization
• Enrollments, Count of Enrollments with Error - Hide from visualization
• Table Calculations:
  • Count of Enrollments w/o Errors:

• • Percent of Enrollments W/O Errors

Filters

• Enrollments, Reporting Period Filter: is in the past 12 complete months

Visualization

This tile is a horizontal bar chart.

Percent of Enrollments W/O Data Quality Errors

Model: Data Quality

Fields

• Enrollments, Count - Hide from visualization
• Enrollments, Count of Enrollments with Error - Hide from visualization
• Table Calculations:
  
  • Count of Enrollments w/o Errors:

• • Percent of Enrollments W/O Errors

Filters

• Enrollments, Reporting Period Filter: is in the past 12 complete months

Visualization

This visualization uses Liquid Fuel Gauge.

Annual Assessment Status

Model: Data Quality

Fields

• DQ Annual Assessments, Annual Assessment Status dimension
• Enrollments, Count

Filtering

• DQ Annual Assessments, Annual Assessment Status: matches (advanced): Completed, Completed out of range, Due in 30-60 days, Past Due, Due
• Program Funding Sources, Funding Source: matched (advanced):
  • HUD: CoC - Joint Component TH/RRH,
  • HUD:CoC – Homelessness Prevention (High Performing Comm. Only),
  • HUD:CoC – Permanent Supportive Housing,
  • HUD:CoC – Rapid Re-Housing,
  • HUD:CoC – Transitional Housing,
  • HUD: ESG - CV,HUD:ESG – Emergency Shelter (operating and/or essential services),
  • HUD:ESG – Homelessness Prevention,
  • HUD:ESG – Rapid Rehousing,
  • HUD:ESG – Street Outreach,
  • HUD:HOPWA – Permanent Housing (facility based or TBRA),
  • HUD:HOPWA – Short-Term Rent, Mortgage, Utility assistance,
  • HUD:HOPWA – Permanent Housing Placement,
  • HUD:HUD/VASH,
  • HHS:PATH – Street Outreach & Supportive Services Only,
  • HHS:RHY – Maternity Group Home for Pregnant and Parenting Youth,
  • HHS:RHY – Transitional Living Program,
  • VA:Supportive Services for Veteran Families,
  • VA:Grant Per Diem - Case Management/Housing Retention,
  • VA:Grant Per Diem – Service Intensive Transitional Housing,
  • VA:Grant Per Diem – Transition in Place,
  • VA: CRS Contract Residential Services,
  • VA: Community Contract Safe Haven,
  • HUD: Pay for Success,
  • HUD: Rural Housing Stability Assistance Program,
  • HHS: RHY – Demonstration Project
• Programs, Tracking Method: is not equal to: Night-by-Night 

Visualization

The visualization for this tile is a Pie Chart, with a donut hole. To create the hole, add an Inner Radius of 60 (or another preferred radius).

Average Days for Data Entry

This tile shows the average number of days between project start and the date the enrollment is created in HMIS.

Model: Data Quality

Fields

• Enrollments, Average Timeliness of Data Entry

Filters

• Enrollments, Reporting Period Filter: is in the past 12 complete months

Visualization

This is a new type of visualization called Radial Gauge. To Access the Radial Gauge:

To set a target for Data Entry:

Potential Exits - Top 25

This tile displays the top 25 enrollments that have been inactive for more than 6 months.

Model: Client

Fields

• Programs, Full Name
• Enrollments, Enrollment ID
• Enrollments, Project Start Date
• Client Interactions, Last Interaction Type
• Client Interactions, Last Interaction Date

Filters

• Enrollments, Reporting Period Filter: is in the past 1 quarter
• Client Interactions, Last Interaction Date: is before 180 days ago
• Clients Deleted (Yes/No): is No
• Enrollments, Active: is equal to Yes
• Enrollments, Deleted (Yes/No): is No
• Enrollments, ID: is not null
• Enrollments, Project Start Date: is on or after 2012-10-01 (this to eliminate old enrollments, pre- HUD System Performance Measures Loopback Cutoff date)
• Custom Filter

Visualization

This visualization uses a standard table but is limited to the top 25 enrollments with the longest number of days inactive.

Dashboard Filters

• Program CoC
• Reporting Period Filter
  • Default: is in the last 12 complete months
• Agency Name
• Program Name
• Potential Exits Cutoff Date:
  • Client Interactions, Last Interaction Date
  • Default: is before 180 days ago