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.
- Select the household type(s) to include in the dashboard.
- 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.
- Select the age range to include in the dashboard.
- 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.
- Select Chronically Homeless (Yes/No) to filter the dashboard.
- 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.
- Select “Explore from Here”, then click on any count in the data section for a drill down.
- There are two ways to explore this Look to obtain more information.
-
-
- 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})
-
- Table Calculation
- 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.
- There are two ways to explore this Look to obtain more information.
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.
- There are two ways to explore this Look to obtain more information.
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
- Custom Measures
-
-
-
- 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
-
- Unaccompanied Youth 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.
- There are two ways to explore this Look to obtain more information.
-
-
-
- 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
-
- Older Adults (Age 55 - 61)
- Custom Measures
-
-
- Seniors (Age 62+)
- Field to Measure: Number of Clients
- Custom Filter:
-
${clients.age}>=62
-
- Seniors (Age 62+)
-
-
-
- Total Older Adults and Seniors
- Field to Measure: Number of Clients
- Custom Filter:
-
${clients.age}>=55
-
- Total Older Adults and Seniors
-
- “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.
- There are two ways to explore this Look to obtain more information.
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
- Custom Measure
-
-
-
- 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.
- There are two ways to explore this Look to obtain more information.
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.
- There are two ways to explore this Look to obtain more information.
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)
- Custom Measures
-
-
-
- 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"
-
- Any CE Enrollments (Hidden
-
-
- Table Calculations
- Clients on CQ without an Active CE Enrollment
- Expression:
-
sum(if(${active_ce_enrollments}=0,1,0))
-
- Expression:
- Clients on CQ without an Active CE Enrollment
- Table Calculations
-
-
- Clients on CQ without any CE Enrollment
- Expression:
-
sum(if(${any_ce_enrollments}=0,1,0))
-
- Expression:
- Clients on CQ without any CE Enrollment
-
- 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.
- There are two ways to explore this Look to obtain more information.
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)
-
- Expression:
- Household Size
- Custom Dimension
- 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.
- There are two ways to explore this Look to obtain more information.
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.
- There are two ways to explore this Look to obtain more information.
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.
- There are two ways to explore this Look to obtain more information.
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
- Table Calculation
-
-
-
- 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.
- There are two ways to explore this Look to obtain more information.
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.
- There are two ways to explore this Look to obtain more information.
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
- Custom Dimension
-
-
-
- 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.
- There are two ways to explore this Look to obtain more information.
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.
- There are two ways to explore this Look to obtain more information.
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.
- There are two ways to explore this Look to obtain more information.
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.
- There are two ways to explore this Look to obtain more information.
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
- Custom Measures
-
-
-
- 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"
-
- Any Disabling Condition
-
-
-
- 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"
-
- Both Alcohol and Drug Use Disorder
-
-
-
- Chronic Health Condition
- Field to measure: Number of Clients
- Custom Filter:
-
${entry_screen.health_chronic}="Yes"
-
- Chronic Health Condition
-
-
-
- Developmental Disability
- Field to measure: Number of Clients
- Custom Filter:
-
${entry_screen.health_dev_disability}="Yes"
-
- Developmental Disability
-
-
-
- Drug Use Disorder
- Field to measure: Number of Clients
- Custom Filter:
-
${entry_screen.health_substance_abuse}="Drug Use Disorder"
-
- Drug Use Disorder
-
-
-
- HIV/AIDS
- Field to measure: Number of Clients
- Custom Filter:
-
${entry_screen.health_hiv}="Yes"
-
- HIV/AIDS
-
-
-
- Mental Health Disorder
- Field to measure: Number of Clients
- Custom Filter:
-
${entry_screen.health_mental}="Yes"
-
- Mental Health Disorder
-
-
-
- Physical Disability
- Field to measure: Number of Clients
- Custom Filter:
-
${entry_screen.health_phys_disability}="Yes"
-
- Physical Disability
-
- “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.
- There are two ways to explore this Look to obtain more information.
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}
-
- Expression:
- Household Size
- Table Calculation
- 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