Sample Looks

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 assessment. The following is only a recommended approach, feel free to explore to best meet your needs.

  1. Explore - Client Model
  2. Fields
    Add the following fields to the Look:
    • [Personal ID] (Clients folder)
    • [Date Created] (Clients)
    • [Agency that created Client Profile] (Clients)
    • [Full Name] (Programs) &/or Assessment Name (Client Assessments)
    • [User Updating] (Clients)
  3. Filters
    • To identify clients missing a necessary assessment, filter on the following dimensions:
      • [Agency that created Client Profile] "is equal to" type in the agency name(s)
      • [Date Created] (Clients):
        • "is in the past" Year, Quarter, Complete Quarter, etc. OR
        • "is on or after" choose the date to meet your needs OR
        • "is any time" OR
        • other criteria
      • [Assessment Name] "is not equal to" type in the assessment(s) that are needed
    • To identify clients with no Enrollments in the agency or specific projects, filter on the following dimensions:
      • [Agency that created Client Profile] "is equal to" type in the agency name(s)
      • [Date Created] (Clients):
        • "is in the past" Year, Quarter, Complete Quarter, etc. OR
        • "is on or after" choose the date to meet your needs OR
        • "is any time" OR
        • other criteria
      • [Full Name] or [Name] (Programs) "is not equal to"
        • Use [Full Name] to easily find and exclude all agency programs
        • Use [Name] to select certain programs to exclude
      • Sys Admins: To find all clients without any program enrollments: 
        • Filter by [Enrollment ID] (Enrollments) "is null"