Coordinated Entry: Currently on a Community Queue

Purpose

The Coordinated Entry: Currently on a Community Queue dashboard includes information on clients that have a Coordinated Entry program enrollment and are also currently on a Community Queue. This dashboard provides an overview of who is on the queue highlighting general counts, special populations and demographics, assessment information, household information, and a client detail list. 

Dashboard Details

This dashboard is accessible in Looker by utilizing the following pathway:

• “All Folders” 
  • “LookML Dashboards”

• • • “Coordinated Entry: Currently on a Community Queue”

Once selected, your dashboard will begin to run. This dashboard utilizes the Coordinated Entry model for all Looks. 

Filters

The following filters are available for this dashboard:

• Community Queue CoC 
  • Select the Community Queue CoC(s) to include in the dashboard.
• Community Queue Name
  • Select the Community Queue Name(s) to include in the dashboard.
• Assessment Name
  • Select the name(s) of assessments to include in the dashboard.
• Household Type
  
  • Select the household type(s) to include in the dashboard.
    • Household type is pulled from the client’s enrollment. 
• Current Age 
  • Select the age range to include in the dashboard. 
    
    • The filter defaults to ‘is any value’. Once a range is selected, clients without an age are filtered out of the dataset. 
• Veteran Status
  • Select the Veteran Status to include in the dashboard. 
• Chronically Homeless
  
  • Select Chronically Homeless (Yes/No) to filter the dashboard. 
    • The filter utilizes the Entry Screen - Chronically Homeless at Project Start - Individual field.
• Gender
  • Select which Gender(s) to include in the dashboard. 
• Race and Ethnicity
  • Select which Race(s) and Ethnicity(-ies) to include in the dashboard. 

Tile Overview

The dashboard contains 23 tiles broken down into 6 sections: Community Queue Overview, Enrollment Information, Household Information, Assessment Information, Demographics/Special Populations, and Currently on Community Queue - Client Detail. Each Look has an information bubble containing notes about the Look and information about applicable filters if relevant. 

Community Queue Overview 

Clients Currently on Community Queue

This Look contains a single value visualization with a count of clients and households currently on a Community Queue. Household counts are pulled from latest CE enrollment household data.

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters
  • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes
• Measures
  • Clients - Number of Clients 
  • Entry Screen - Count Households 
• “Explore from Here”
  • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down. 
      • Client Count drill down contains Personal ID, Unique Identifier, Client Full Name, and Current Age
      • Household Count drill down contains Entry Screen ID, Household ID, Personal ID, Unique Identifier, Client Full Name, Project Start Date, and Project Exit Date.

• • • This drill down Look can also be achieved by selecting any count on the dashboard tile. 

Clients Currently on a CQ Multiple Times

This Look contains a single value visualization with a count of clients currently on a Community Queue multiple times. If there are “No Results” returned within the tile, there are no clients on a Community Queue multiple times. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters
  • Referrals - Is referral currently on queue?: is equal to Yes
  • Referrals - Count: is greater than 1 
• Custom Fields
  • Table Calculation
    
    • Clients on Queue(s) Multiple Times
    • Expression:

      • count(${client.id})

• Dimensions
  • Clients - Personal ID
  • Referrals - Referral Community Queues • Name(pivot)

• Measures

• • Referrals - Count 

• “Explore from Here”

• • Select “Explore from Here” for a client list (Personal ID), and count of referrals on a Community Queue. 

• • • • Within the Look, the referral count drill downs contain Personal ID, Referrals ID, and Referral Method. 

Veterans Currently on CQ

This Look contains a single value visualization with a count of Veterans currently on a Community Queue.

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Chronically Homeless, Gender, and Race/Ethnicity (Veteran Status filter is not applied to this Look.)

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes
  • Custom Filter: 

    • ${static_demographics.veteran_text}="Yes"

• Measures

• • Clients - Number of Clients 

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on the count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Client Age. 
    • This drill down Look can also be achieved by selecting the count on the dashboard tile.

Chronically Homeless Clients Currently on CQ

This Look contains a single value visualization with a count of Chronically Homeless individuals currently on a Community Queue.

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Gender, and Race/Ethnicity (Chronic Homeless filter is not applied to this Look.)

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes
  • Custom Filter: 

    • ${chronic_homeless.ch_at_project_start}="Yes"

• Measures

• • Clients - Number of Clients

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on the count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Client Age. 
    • This drill down Look can also be achieved by selecting the count on the dashboard tile.

Youth Summary 

This Look contains a multiple value visualization with Unaccompanied Youth Clients and Parenting Youth Households counts that are currently on a Community Queue. 

Unaccompanied Youth Clients in this Look are age 0-24 with no household members older than 24 and no children in the household.

Parenting Youth Households in this Look are youth clients with at least one child in their household.

These counts are based on the client’s current age from the client profile screen. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity (Current Age filter is not applied to this Look.)

• Filters

• • Enrollments - Enrollment Household: is Current Age 
  • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Custom Fields

• • Custom Measures
    • Parenting Youth Households

• • • • Field to Measure: Entry Screen - Count Households
      • Custom Filter: 

        • ${household_makeup.oldest}<=24 AND ${household_makeup.count_children}>0

• • • Unaccompanied Youth Clients 
      • Field to Measure: Number of Clients
      • Custom Filter: 

        • ${household_makeup.oldest}<=24 AND ${household_makeup.count_children}=0

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down.

• • • • Parenting Youth Households Count drill down contains Entry Screen ID, Household ID, Personal ID, Unique Identifier, Client Full Name, Project Start Date, and Project Exit Date.
      • Unaccompanied Youth Client Count drill down contains Personal ID, Unique Identifier, Client Full Name, and Current Age. 

• • • This drill down Look can also be achieved by selecting any count on the dashboard tile. 

Older Adults/Seniors Summary

This Look contains a multiple value visualization with counts of Older Adults (Age 55-61), Seniors (Age 62+), and Total client counts that are currently on a Community Queue. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity (Current Age filter is not applied to this Look.)

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Custom Fields

• • Custom Measures
    • Older Adults (Age 55 - 61) 
      • Field to Measure: Number of Clients
      • Custom Filter: 

        • ${clients.age}>=55 AND ${clients.age}<62

• • • Seniors (Age 62+)
      • Field to Measure: Number of Clients
      • Custom Filter: 

        • ${clients.age}>=62

• • • Total Older Adults and Seniors
      • Field to Measure: Number of Clients
      • Custom Filter: 

        • ${clients.age}>=55

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any count on the dashboard tile. 

Average Length of Time (Days) on CQ

This Look contains a single value visualization with the average length of time in days clients have been on a Community Queue that are currently on a Community Queue. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Custom Fields

• • Custom Measure
    • Average of Days Since Referral Added to Queue

• • • • Field to Measure: Referrals - Days Since Referral Added to Queue
      • Measure Type: Average

• “Explore from Here”

• • Drill down functionality is not available for this Look. 

Monthly Referrals to CQ 

This Look contains a column visualization with a count of clients referred to a Community Queue by added month that are currently on a Community Queue. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Dimensions

• • Referrals - Added Date • Month

• Measures

• • Clients - Number of Clients 

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any count/column on the dashboard tile. 

 

Enrollment Information

Monthly CE Enrollments 

This Look contains a column visualization with a count of clients enrolled in a Coordinated Entry program by project start month that are currently on a Community Queue. This Look pulls project start month from the client’s latest CE enrollment. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Dimensions

• • Enrollments - Project Start Date • Month

• Measures

• • Clients - Number of Clients 

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age.
    • This drill down Look can also be achieved by selecting any count/column on the dashboard tile.

Clients Currently on a CQ Without an Active CE Enrollment

This Look contains a single value visualization with a count of clients that are currently on a Community Queue without an active CE enrollment and without any CE enrollment.

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Referrals - Is referral currently on queue?: is equal to Yes
  • Active CE Enrollments: is 0

• Custom Fields

• • Custom Measures 
    • Active CE Enrollments (Hidden)

• • • • Field to Measure: Enrollments - Count
      • Custom filter: 

        • ${enrollments.still_in_program}="Yes" AND ${programs.project_type_code}="Coordinated Entry"

• • • Any CE Enrollments (Hidden
      • Field to Measure: Enrollments - Count
      • Custom filter: 

        • ${programs.project_type_code}="Coordinated Entry"

• • Table Calculations
    
    • Clients on CQ without an Active CE Enrollment
      • Expression: 

        • sum(if(${active_ce_enrollments}=0,1,0))

• • • Clients on CQ without any CE Enrollment
      • Expression: 

        • sum(if(${any_ce_enrollments}=0,1,0))

• Dimensions

• • Clients - Personal ID (Hidden) 

• “Explore from Here”

• • Drill down functionality is not available for this Look, but selecting “Explore from Here” does provide the Look with all fields exposed within the Data section to review clients (via Personal ID) without active/any CE enrollment. 

Household Information - Latest Coordinated Entry Enrollment

Household Type Breakdown 

This Look contains a pie visualization with the counts and percentage of households by household type that are currently on a Community Queue. This Look pulls household type from the client’s latest CE enrollment. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Dimensions

• • Enrollments - Enrollment Household • Household Type

• Measures

• • Clients - Number of Clients

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any segment on the dashboard tile. 

Household Size Counts

This Look contains a table visualization with counts of households by household size for households that are currently on a Community Queue. This Look pulls household information from the client’s latest CE enrollment. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Custom Fields

• • Custom Dimension
    • Household Size
      • Expression:

        • case(
          
          when(${household_makeup.count_adults}+${household_makeup.count_children}=1,"1"),
          
          when(${household_makeup.count_adults}+${household_makeup.count_children}=2,"2"),
          
          when(${household_makeup.count_adults}+${household_makeup.count_children}=3,"3"),
          
          when(${household_makeup.count_adults}+${household_makeup.count_children}=4,"4"),
          
          when(${household_makeup.count_adults}+${household_makeup.count_children}>=5,"5+"),
          null)

• Measures

• • Clients - Number of Clients 

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any count on the dashboard tile. 

 

Assessment Information

Clients Currently on the Community Queue with a Non-CE Assessment

This Look contains a single value visualization with a count of clients currently on a Community Queue with a non-CE assessment. These clients may need to be re-assessed or removed from the queue as their linked assessment is a non-CE assessment. If there are "No Results" returned in the tile, there are no clients on Community Queue with a non-CE assessment.

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Client Assessments - Is Coordinated Entry: is equal to No
  • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Dimensions

• • Client Assessments - Assessment Name

• Measures

• • Clients - Number of Clients

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any count on the dashboard tile. 

Assessment Type Counts on CQ

This Look contains a bar visualization with counts of clients currently on Community Queue by linked assessment name. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Dimensions

• • Client Assessments - Assessment Name
  • Client Assessments - Is Coordinated Entry (pivot)

• Measures

• • Clients - Number of Clients

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any count on the dashboard tile. 

Demographics/Special Populations

Age Tiers 

This Look contains a column visualization with counts and percent of clients currently on a Community Queue by Age Tier. Client age is pulled from the current age on the profile screen. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Client - Age Tier:is not Below 0 
  • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Custom Fields

• • Table Calculation
    • Percent of Clients

• • • • Calculation: % of Column
      • Source Field: Clients - Number of Clients 
      • Format: Percent, 0 Decimals

• Dimensions

• • Clients - Age Tier

• Measures

• • Clients - Number of Clients 

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any count on the dashboard tile. 

Veteran Status

This Look contains a pie visualization with the count and percent of clients currently on a Community Queue by Veteran Status.

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Dimensions

• • Clients - Veteran Information • Veteran Status

• Measures

• • Clients - Number of Clients 

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any segment on the dashboard tile. 

Gender

This Look contains a pie visualization with the count and percent of clients currently on a Community Queue by Gender.

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Custom Fields

• • Custom Dimension
    • Gender Groups 

• • • • Male: is Male
      • Female: is Female
      • Transgender: is Transgender

• • • • Questioning: is Questioning
      • Data Not Collected: is Data not collected
      • Client PNTA: is Client prefers not to answer
      • Client Doesn’t Know: is Client doesn’t know 

• Measures

• • Clients - Number of Clients 

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any segment on the dashboard tile. 

Chronically Homeless at Project Start

This Look contains a pie visualization with the count and percent of clients currently on a Community Queue by Chronically Homeless at Project Start (Yes/No). Client data is pulled from the client’s latest CE enrollment using HUD logic and 3.917 data elements. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Dimensions

• • Entry Screen - Chronically Homeless at Project Start • Individual

• Measures

• • Clients - Number of Clients 

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any segment on the dashboard tile. 

Race & Ethnicity 

This Look contains a pie visualization with the count and percent of clients currently on a Community Queue by race and ethnicity.

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Dimensions

• • Clients - Race & Ethnicity

• Measures

• • Clients - Number of Clients 

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any segment on the dashboard tile. 

Disabling Condition at Project Start 

This Look contains a pie visualization with the count and percent of clients currently on a Community Queue by disabling condition at project start (yes/no). Disabling condition information is pulled from the client’s latest CE enrollment.

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Dimensions

• • Entry Screen - Disabling Condition

• Measures

• • Clients - Number of Clients 

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any segment on the dashboard tile. 

Disabling Condition Types at Project Start 

This Look contains a bar visualization with a count of clients that reported a disabling condition/disabling condition types at project start. Disabling condition information is pulled from the client’s latest CE enrollment. Due to the nature of disabling condition data elements, as they are not required for SSO Coordinated Entry, this tile may not contain counts dependent on a community's workflow. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes

• Custom Fields

• • Custom Measures 
    • Alcohol Use Disorder

• • • • Field to measure: Number of Clients 
      • Custom Filter: 

        • ${entry_screen.health_substance_abuse}="Alcohol Use Disorder"

• • • Any Disabling Condition
      • Field to measure: Number of Clients 
      • Custom Filter: 

        • ${entry_screen.disabling_condition}="Yes"

• • • Both Alcohol and Drug Use Disorder
      • Field to measure: Number of Clients 
      • Custom Filter: 

        • ${entry_screen.health_substance_abuse}="Both Alcohol and Drug Use Disorder"

• • • Chronic Health Condition
      • Field to measure: Number of Clients 
      • Custom Filter: 

        • ${entry_screen.health_chronic}="Yes"

• • • Developmental Disability
      • Field to measure: Number of Clients 
      • Custom Filter: 

        • ${entry_screen.health_dev_disability}="Yes"

• • • Drug Use Disorder
      • Field to measure: Number of Clients 
      • Custom Filter: 

        • ${entry_screen.health_substance_abuse}="Drug Use Disorder"

• • • HIV/AIDS
      • Field to measure: Number of Clients 
      • Custom Filter: 

        • ${entry_screen.health_hiv}="Yes"

• • • Mental Health Disorder
      • Field to measure: Number of Clients 
      • Custom Filter: 

        • ${entry_screen.health_mental}="Yes"

• • • Physical Disability
      • Field to measure: Number of Clients 
      • Custom Filter: 

        • ${entry_screen.health_phys_disability}="Yes"

• “Explore from Here”

• • There are two ways to explore this Look to obtain more information.
    • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Unique Identifier, Client Full Name, and Current Age. 
    • This drill down Look can also be achieved by selecting any count on the dashboard tile. 

Currently on Community Queue - Client Detail

Client Detail List 

This Look contains a table visualization with a client detail list for clients currently on a Community Queue. Due to the 5,000 row limit, if a Community Queue has more than 5,000 clients the Look can be downloaded for a complete client list. To download data select the ellipses in the upper right corner of the Look and select ‘Download Data’. The Look is defaulted to sort by Community Queue Name and Days on Queue. 

Applicable Filters: Community Queue CoC, Community Queue Name, Assessment Name, Household Type, Current Age, Veteran Status, Chronically Homeless, Gender, and Race/Ethnicity

• Filters

• • Enrollments - Is Last Enrollment per Project Type (Yes/No): is Yes
  • Programs - Project Type Code: is equal to Coordinated Entry 
  • Referrals - Is referral currently on queue?: is equal to Yes
• Custom Fields

• • Table Calculation
    • Household Size 
      • Expression: 

        • ${household_makeup.count_adults}+${household_makeup.count_children}

• Dimensions

• • Client Assessments - Assessing Program
  • Client Assessments - Assessment Date 
  • Client Assessments -  Assessment Name
  • Client Assessments - Assessment Score
  • Clients - Client Activity • Last Activity Agency
  • Clients - Client Activity • Last Activity Date
  • Clients - Current Age
  • Clients - Gender
  • Clients - Personal ID
  • Clients - Veteran Information • Veteran Status 
  • Enrollments - Assigned Staff
  • Enrollments - Enrollment Household • Count Adults (Hidden)
  • Enrollments - Enrollment Household •  Count Children (Hidden)
  • Enrollments - Enrollment Household • Household Type
  • Entry Screen - Chronically Homeless at Project Start • Individual 
  • Referrals - Added Date • Date
  • Referrals - Days Since Referral Added to Queue 
  • Referrals - Referral Community Queues • CoC
  • Referrals - Referral Community Queues • Name
• “Explore from Here”

• • Drill functionality is not available for this Look.

 

Updated: 11/6/2023