• Client Model: Archivable Clients

    A best practice for human services systems is to periodically remove or archive data for inactive clients. HIPAA standards call for removal after 6 years. The Client Model provides a method to identify inactive clients using the "Last Interaction" features of the model. For a description of the "Last Interaction" fields, refer back to the Client Model article. The following is a suggested Look ...

    label_outline Looker label_outline Client Model
  • Client Model: Clients with No Assessments/Enrollments

    For some agencies, a program enrollment is essential to client case management and outcomes reporting. For coordinated entry projects, having an Assessment such as the VI-SPDAT is the starting point for the coordinated entry system for the community. No assessment, no prioritization. The following suggested Look is intended to identify clients that may have missed getting a program enrollment &/or an assessmen...

    label_outline Looker label_outline Client Model
  • Data Quality: Annual Assessment Due

    Annual Assessments are a required element of several Federal Partner programs. This Look will help program managers monitor progress towards collecting these data points. Explore - Data Quality Model Fields Add the following fields to the Look: [Name] (Programs folder) [Assigned Staff] (Enrollments) [Personal ID] (Clients) [Enrollment ID] (Enrollments) [Annual Assessment Status] (DQ Annual Assessments) [Targeted...

    label_outline Looker label_outline Data Quality label_outline Data Quality Model
  • Data Quality: Universal Data Element

    The Universal Data Elements are, well, universal. All HMIS projects must report on all of these elements. The following will give a simple summary of data quality problems by program and user with exceptional detail on the drill downs. Explore - Data Quality Model FieldsAdd the following fields to the Look: [Name] (Programs folder) [Assigned Staff] (Enrollments) Measure [Total Universal Data Element Errors Count...

    label_outline Looker label_outline Data Quality label_outline Data Quality Model
  • Data Quality: LSA Data Quality Errors

    The following instructions will provide a quick Look at the data quality problems that will be reported in the LSA. The Look will cast a wide net. But these are basic data quality problems that should be resolved. To develop a more exact report, review the LSA specifications. For this article, keeping it simple is the goal. Explore - Data Quality Model FieldsAdd the following fields to the Look: Personal ID (C...

  • HMIS Performance: Client Location of Heads of Household

    HUD reports are increasingly relying on [Client Location of Head of Household] for CoC-wide reporting. Specifically this is required for: System Performance Measures (SPM) Longitudinal System Analysis (LSA) (formerly AHAR) The following are steps for developing a suggested Look for identifying Enrollments with CoC issues. Explore - HMIS Performance model Add the following fields to the Look: Personal ID (Clien...

    label_outline Looker label_outline SPM label_outline System Performance Measures label_outline LSA label_outline Longitudinal System Analysis
  • Project Descriptor: Additional Project Information

    To create a Look to review the required project descriptor elements, do the following in Looker: Explore>Project Descriptor Model Add Filters: Program Active=Active (Programs folder) Project Type Code=      (Programs) Emergency Shelter PH - Housing Only PH - Housing Services (no disability... PH - Permanent Supportive Housing (disability... PH - Rapid Re-Housing Transitional Housing Safe Haven Add the fo...

    label_outline Looker label_outline For System Administrators label_outline Data Standards label_outline 2017 label_outline Project Descriptor Model
  • Project Descriptor: Funding Sources

    To create a Look to identify projects with retired federal partner funding sources, do the following in Looker: Explore>Project Descriptor Model Add Filters: Funding Source (Program Funding Sources) RETIRED (VA Community Contract Residential Treatment) RETIRED (VA: Grant Per Diem) Program Active = Active (Programs) Add the following dimensions to the Look: Agency Name (Agencies) Name (Programs) Funding ...

    label_outline Looker label_outline Project Descriptor Model
  • Reservation Status Chart

    This article describes the steps to create a Look that summarizes the Status for Reservations. Explore - Reservations Model FieldsAdd the following fields to the Look: Reservation Section (Reservation Slots) Reservation Slot (Reservation Slots) Status (Styled) (Reservations) Pivot on Date (Reservations) FiltersAdd the following fields to the Look: Added by default: Reservation Slots Date - Adjust days as nee...

    label_outline Looker label_outline Reservations Model
  • Reservation Utilization Chart

    This article will describe creating a Look to display the utilization of reservations. Explore - Reservations Model FieldsAdd the following to the Look: Status (Reservations) Count (Reservation Slots) FiltersChange the default filter, Reservation Slots Date to: Is in the past - "1 quarters"Add additional filters as appropriate Agency Name Reservation Slot Section Service or Service Item Name Run ...

    label_outline Looker label_outline Reservations Model