Hennepin Chronic By Name List (CBNL)
Date Created: 03/25/2024
In this article
● Purpose: What is this report used for?
● Audience: Who should run this report?
● Location: Where can I find this report?
● Prompts: How do I run this report?
● In-Depth: What questions can this report answer?
● In-Depth: By Name List Columns and Calculations
Purpose: What is this report used for?
The CBNL.2024.v2_BETA report has four components:
● Chronic Pool: This tab lists adult or HoH clients who meet the chronic homeless criteria for Hennepin County and who are not currently on the Chronic BNL.
- HMIS shelter stay dates = 12 consecutive months of homelessness (1 day homeless in the month counts as 1 month homeless) OR
- 4 episodes of homelessness in past 3 years (one calendar month w/out stay is a new episode) OR
- Combination of unsheltered and sheltered homelessness using CLS that add up to 12 months or 4 episodes in 3 years AND
- HoH or adult AND
- Disability of Long Duration AND
- Not currently on the chronic by-name list
● Chronic BNL: Displays clients who have an open chronic index sub-assessment (aka have been placed on the Chronic BNL (CBNL))
● Outflow Pool: Displays clients who are on the CBNL AND have exited homelessness in the past 30 days or have no active homeless systems interactions.
● Outflow: Displays clients who have a Chronic Index sub-assessment with an end date on or before the report effective date.
Audience: Who should run this report?
Hennepin County case managers and planners, as well as community shelter and outreach staff, are the intended audience for this report. The report will be typically run and distributed by HC planners.
Note: A user's account settings and other visibility settings can affect what data the user will see when running a BusinessObjects report. For more information, please refer to the article Visibility Settings and Their Impact on BusinessObjects Reports.
Location: Where can I find this report?
In the BusinessObjects (BO) reporting tool, open these folders in order:
Public Folders => minnesota_live_folder => CoC/LSA ReportGallery => CoC - Hennepin => Housing Stability
Prompts: How do I run this report?
● EDA Provider: Do not change the default value -DefaultProvider-
● Enter Start Date: Enter the date 3 years prior to the effective date.
● Enter Last Transaction Cutoff Date: Enter the date 1 month prior to the effective date.
● Enter Effective Date: The date the report is being run. It is recommended that the time be set to 12:00:00 AM.
In-Depth: What questions can this report answer?
The focus of this report is identifying all adult clients who are potentially chronically homeless, have been identified as chronically homeless and added to the Chronic By-name List, those who may have recently exited the Hennepin County homeless system or are no longer considered chronically homeless as well as those who have been removed from the chronic by-name List.
In-Depth: By Name List Columns and Calculations
The table below lists every column in the report together with details about how it is pulled from BusinessObjects. Users are directed to set the effective date prompt to match the report's run date to ensure that the most recent assessment values are also pulled into the report.
Note: For chronic pool, clients must be qualified based on the chronic homeless criteria for Hennepin County in order to appear on this tab. For all other tabs, they must have a chronic index sub-assessment in order to appear. As a result, calculations for these different populations may look slightly different. Will note when there are differences below.
Column name | Field/Calculation details | Notes |
Client ID | =[Merge Client Id] | - |
First Name | =[Client First Name] | - |
Last Name | =[Client Last Name] | |
Client ID | =[Merge Client Id] | - |
DOB | =[Client Date of Birth] | - |
Age | =[Client Age (Current)] | Age as of effective date |
R/E | =[RaceEth2024 Detail] | Displays client selected race(s) and ethnicity |
HC Homeless date | =Max(If([Valid CBNL ES SO First]="X"; [Base Clients].[Entry Exit Entry Date])) In([Entry Exit Client Id]) |
This column displays the clients first entry into shelter or outreach in Hennepin County in the past 36 months. |
CM interest | =[Interested in receiving housing case management?(6388)] | This column displays the result of the question "Interested in receiving housing case management?(6388)]" |
Most recent case management provider | =[Max CM Provider] | If the client has at least one open entry/exit for a Hennepin County/Shelter case management provider as of the date the report was run (Exit Date is null), the Provider of the most recent entry/exit appears here. Most recent is defined as the latest Entry Date. |
All open case managers | =[Open CM FINAL] | This column displays all open case managers and providers recorded on the Case Manager tab. The results display a concatenated list of "Case Manager/Provider Name.” |
Most recent shelter entry | Chronic Pool =Max(If([Valid CBNL ES]="X"; [Base Clients].[Entry Exit Entry Date])) In([Entry Exit Client Id]) All other Tabs = [Max ES Entry - Outflow] |
Most recent is defined as the latest qualifying Entry Date into Emergency Shelter in Hennepin County. Shelter Stay services are not considered here. |
Shelter exit | Chronic Pool =Max(If([Valid CBNL ES]="X"; [Base Clients].[Entry Exit Exit Date])) In([Entry Exit Client Id]) All other Tabs = [Max ES Exit - Outflow] |
Displays the Exit Date or End Date from the client's most recent qualifying Hennepin County emergency shelter entry/exit. Shelter Stay services are not considered here. |
Shelter provider | Chronic Pool =Max(If([Valid CBNL ES]="X"; [Base Clients].[Entry Exit Provider Id])) In([Entry Exit Client Id]) All other Tabs =[Max ES Provider - Outflow] |
The provider of the most recent qualifying Hennepin County shelter entry/exit appears here. Most recent is defined as the latest Entry Date. |
Most recent street outreach entry | Chronic Pool =Max(If([Valid CBNL SO]="X"; [Base Clients].[Entry Exit Entry Date])) In([Entry Exit Client Id]) All other tabs =[Max SO Entry - Outflow] |
Displays the entry date for the most recent qualifying street outreach entry in Hennepin County. |
Street outreach provider | Chronic Pool =Max(If([Valid CBNL SO]="X"; [Base Clients].[Entry Exit Provider Id])) In([Entry Exit Client Id]) All other tabs =[Max SO Provider] |
The Provider of the most recent street outreach qualifying entry/exit appears here. "Most recent" is defined as the latest Entry Date. ● PATH SSO entry/exits have been recoded as SO and will pull into this column when appropriate. |
Current CLS date | Chronic Pool =[Max CLS Date - Base] All other tabs =[CLS Date Most Current] |
If the client has any contacts recorded in the Current Living Situation sub-assessment, the Start Date of the most recent (meaning the one with the latest Start Date) will display. |
Current living situation | Chronic Pool =[Max CLS - Base] All other tabs =[CLS Location Most Current] |
If the client has any contacts recorded in the Current Living Situation sub-assessment, the Current Living Situation from the most recent (meaning the one with the latest Start Date) will display. |
CLS details | Chronic Pool =[CLS Location Details Most Current -Base] All other tabs =[CLS Location DETAILS Most Current] |
If the client has any contacts recorded in the Current Living Situation sub-assessment, Location Details from the most recent CLS value (the one with the latest Start Date) will display. |
Most recent open day shelter entry | =[Max Open DS Entry - Outflow] |
If the client has an open enrollment into a day shelter (drop-in center), the entry date for the most recent provider will display. |
Open day shelter provider | =[Max Open DS Entry Provider- Outflow] |
If the client has an open enrollment into a day shelter (drop-in center), the most recent provider or the qualifying entry will display. |
Homeless history 36 months |
=Max([Episodes Base] In([Entry Exit Client Id])) |
Provides a visual display of qualifying homeless history for the preceding 36 months. “X” =homeless and “.” =not homeless during the month |
Shared? | Chronic Pool =If(Not(IsNull([Base Clients].[Date of ROI Consent(4074)])); "Shared") All other tabs =If(Not(IsNull([Date of ROI Consent]));"Shared") |
If there is a value saved in the Date of ROI Consent field, this column displays "Shared.” |
ID | =[Do you have a photo ID?(6000)] |
- |
SS card | =[Do you have your Social Security card?(6001)] |
- |
Birth certificate | =[Do you have your birth certificate?(6002)] | - |
Translation language | =[Interpretation Language] | If the 'Preferred Language' field is null, then use 'If yes, language.’ If 'Preferred Language' = "Different Preferred Language" then use 'If Different Preferred Language, please specify.’ If neither of the two previous conditions are true, then use 'Preferred Language.’ |
Veteran | =[Client Veteran Status] | - |
Income | =[Total income S/F] | If Total Household Monthly Income is null, displays Total Monthly Income, otherwise displays Total Household Monthly Income field. |
Housing type pursued (1) | =[dtl_hsg type 1] | Displays the response to “Current housing type being pursued (1)” |
Housing type pursued (2) | =[dtl_hsg type 2] | Displays the response to “Current housing type being pursued (2) (Optional)” |
On CES priority list | =If([dtl_Declined CE] = "Yes"; "Declined CE"; If(Not(IsNull([CE Sub Assess End Date]));"No"; If(Not(IsNull([CE EE Date Most Current]))); "Yes"; "No"))) |
|
CE referral provider | =Max([CE Referral Provider]) | If the client has a referral to a housing provider valid within their most recent Coordinated Entry entry/exit, the Provider referred to in the most recent referral (meaning the one with the latest Start Date) will display. |
CE referral date | =Max([CE Referral Date]) | If the client has a referral to a housing provider valid within their most recent Coordinated Entry entry/exit, the Date of Event from the most recent referral (meaning the one with the latest Start Date) will display. |
CE referral result | =Max([CE Referral Result]) | If the client has a referral to a housing provider valid within their most recent Coordinated Entry entry/exit, the Referral Result from the most recent referral (meaning the one with the latest Start Date) will display. |
CE referral result date | =Max([CE Referral Result Date]) |
If the client has a referral to a housing provider valid within their most recent Coordinated Entry entry/exit, the Referral Result Date from the most recent referral (meaning the one with the latest Start Date) will display. |
CE referral result reason | =[=Max([CE Referral Result Reason]) |
If the client has a referral to a housing provider valid within their most recent Coordinated Entry entry/exit, the "If Unsuccessful Reason" from the most recent referral (meaning the one with the latest Start Date) will display. |
If not housed, Date referral ended | =Max([CE Referral End Date - Not housed]) |
If the client has a referral to a housing provider valid within their most recent Coordinated Entry entry/exit, the End Date from the most recent referral (meaning the one with the latest Start Date) will display. |
Date added | =Max([Date Added(6609)]) | This displays the most recent date added to the chronic by-name list if on or before the report effective date |
Chronic Index Y/N | =[dtl_Chronic Idex] | Displays the answer to, “Is Client on the Chronic Homeless Index?” |
Outflow pool and outflow only
Date added to CBNL | =[Date Added(6609)] | This displays the date added to the chronic by-name list if on or before the report effective date. |
Shelter exit destination | =[Max ES Entry - Destination (Entry)] |
Displays the Exit Destination from the client's most recent qualifying Hennepin County emergency shelter entry/exit. Shelter Stay services are not considered here. |
Street outreach exit destination | =[Max SO Destination - Outflow.Entry] |
Displays the Exit Destination from the client's most recent qualifying Hennepin County street outreach exit. |
Most recent CM entry | =[Max SSO Entry - Outflow] | Displays the entry date for the most recent qualifying entry to an SSO provider. In most cases, these are Case Management providers. |
CM exit | =[Max SSO Exit - Outflow] | Displays the exit date for the most recent qualifying entry to an SSO provider. In most cases, these are Case Management providers. |
CM exit destination | =[Max SSO Destination - Outflow] |
Displays the exit destination for the most recent qualifying entry to an SSO provider. In most cases, these are Case Management providers. |
Current CLS date | =[Most Current OutflowCLS Start] |
Displays the start date of the most recent current living situation |
Current CLS | =[Most Current OutflowCLS] | Displays the current living situation selected with the most recent CLS start date |
CLS details | =[CLS Location Details Most Current] |
Displays the current living situation details entered with the most recent CLS start date |
Date removed from the CBNL | =[Date Removed(6610)] | |
LOT since outflow | =[LoT Since Outflow] | Calculates the number of days between the Date Removed from the CBNL and the report effective date. |
Removal reason | =[Removal Reason(6611)] | |
If ineligible, reason | =[If ineligible, reason(6612)] | |
Location housed | =[Location Housed(6615)] | |
Chronic index notes | =[Chronic Index Notes(6616)] |