[RFRL-120] Community Queue Detail

This is a referral-based report in which clients from the Community Queues are divided into groups:

To provide details about clients that were referred to the Community Queue by the agencies with the same CoC as the current agency.

All users can run the report. There are restrictions for which information can be accessed based on the rights of the user.

The report can be found in the Community and Referrals section of the Report Library.

CoC (single select)
- This is a CoC of the current agency.
- It is a predefined parameter.
Primary Coordinated Entry Sharing Group (single select)
- NOTE: this option is only displayed for instances with Coordinated Entry Type = Sharing Groups Based.
- It is the Primary Coordinated Entry Sharing Group of the current agency.
- It is a predefined parameter.
Queue(s) (multi-select)
- If Coordinated Entry Type = Continuum of Care Based, it is dependent on the CoC option
  - It is a list of Community Queues from the Referral Setting for the selected CoC.
  - The order of the Queue Names is alphabetical.
- If Coordinated Entry Type = Sharing Groups Based, it is dependent on the Primary Coordinated Entry Sharing Group option
  - It is a list of Community Queues from the Referral Setting for the selected Sharing Group.
  - The order of the Queue Names is alphabetical.
Report Output Format
- Web Page
- PDF
- Excel

To be pulled into the report client should be:

The Unique ID column contains the link to the client profile.

The Age column displays clients' age at the moment the referral has been created.

Referrals' assessments are assessments the referrals have been created under.

VI-SPDAT column displays referrals' assessments score in case if:

assessment Display Score option is turned on
AND client assessment processor code has SPDAT in the name
if there are several scores for the SPDAT assessment processor code for the referral's assessment, the last one will be displayed

Clients on the community queue who are between the ages of 18-24 section:

referrals are pulled into this section if clients' age at referral creation date was between 18 and 24

Clients on the community queue who are veterans section:

referrals are pulled into this section if clients' age at referral creation date was at or greater than 18
AND clients' Veteran field is "Yes"

Clients in community queue with income section:

referrals are pulled into this section if referrals' assessments “VI-SPDAT Socialization Q15” field is "Yes"

Clients on the community queue who have been in jail or prison section:

referrals are pulled into this section if referrals' assessments "Previously in Jail" field is "Yes"
OR "Previously in Prison" field is "Yes"

Clients on the community queue who reported having no insurance section:

referrals are pulled into this section if referrals' assessments “No Insurance" field is checked

Community Queue List section:

Updated 11/05/2021