Community and Referrals

[RFRL-102] Referral Outcome Statistics

Purpose

The Referral Outcome Statistics report returns a detailed breakdown of referral outcomes by agency and program during the reporting period. An Administrator version of the report is also available [RFRL-102-AD]. System Administrators and users with additional access can run the report.

Running the Report

Who Can Run the Report

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

Report Location

This report can be found in the following locations in the Report Library:

  • Community and Referrals → [RFRL-102] Referral Outcome Statistics

  • Administrator Reports → [RFRL-102-AD] Referral Outcome Statistics

Parameters

The following parameters are required to run this report. 

Parameter

Description

Report Date Range

Select your start and end date for the report range. Referrals that were created, changed to in-process, accepted, or denied within this date range will appear in the data tables

Report Output Format

Web Page, PDF or Excel

Additional Admin Parameters

Parameter

Description

CoC

Choose which CoC to include in this report. 

Report Details

Specifications

The information below outlines the specifications for data to be included within the report. 

  • Includes referrals, that have not been deleted, AND

  • created under the current agency AND

  • (for a program of the current agency OR

  • referred to a program of another agency) AND

  • (created within the report date range OR

  • have any of following activities: Pending, Pending - In Process, Accepted or Denied - during the reporting period OR

  • created/changed status to Pending, Pending - In Process before the report start and did not change during the reporting period)

Report Will Include:

  • All referrals - Direct Referrals and Community Queue

Definitions

  • [days pending] - is calculated as the difference between [last date] and [first date]
    • [first date] is:

      • for Direct Referrals - [referral date], the date the referral was created

      • for Referral from Community Queue - [reassigned date], the date the referral was reassigned to the program from the Community Queue

    • [last date] is:

      • For statuses "Pending" and "Pending - In Process" - [report end date]

      • For status "Accepted - [end date], the date referral changed status to "Accepted" 

      • For statuses "Denied" - [end date], the date referral changed status to "Denied" 

Report Tables

The report has two sections:

  • Breakdown of Referred Agencies 

  • Breakdown of Referred Programs 

Breakdown of Referred Agencies 

In this section, data is grouped by agency.

Agency Name consists of the name of the agency that has received the referral(s). 

There are referral outcome columns for:

  • - Pending
  • P/I - Pending/In Progress
  • - Accepted
  • - Denied 

Breakdown of Referred Programs

In this section, data is grouped by program.

Each table within this section has a Program Type title. Within this table, Program Name is listed and accompanied by the Agency Name and referral outcomes.

The fields have the same logic as in the Breakdown of Referred Agencies section.

Additional Admin Data Tables

The administrator version of this report contains the report tables above for the selected CoC as well as tables highlighting the breakdown of the most common exit destinations and whether clients experienced a change in income after leaving the program associated with the referrals made during the reporting period.

Drilldown Functionality 

Drilldown functionality is accessed by selecting any count within the data tables. This functionality is available within all outcome, exit destination and income tables. 

Once selected, a drilldown data table will open. 

This data table includes:

  • Referral Date
  • Unique Identifier
  • Client Name
  • Program Name
    • From agency (referring agency)
    • To agency (referred agency)
  • Days Pending
  • Total 

Updated: 11/29/2021