Before we take a dive into the columns and their definitions, here's a reminder about where to find this report.
Navigate to Reports in your top menu, and from there select either the Spreadsheet: Inbound Referral Raw Data or the Spreadsheet: Outbound Referral Raw Data.
The Inbound version will display all referrals received in your organization's referral inbox.
The Outbound version will display all referrals sent from staff at your organization (visible in your referral outbox).
Once you've selected the criteria you want to download such as the custom time period etc. you can use the below table to help you understand the data contained within your sheet.
Include Open Appointments
In some contexts, you may want to see more than just booked referrals. You can also include data about open appointments in this report.
Select the Submitted Date dropdown and switch to Appointment Date, then you can check off 'Open Time Slots' to include that data as well.
Note: using Appointment Date as the time filter, the data will only contain referrals whose appointment dates fall within the identified time period. For example, if you pulled by Appointment Date for April 1 - April 30, if you sent a referral on April 29, but its appointment is on May 2nd, you will not see this referral included in the data.
Report Columns
Column Title | Explanation | Data Example |
Reference # | The unique identifier generated with every referral created in Caredove. | 3502768696 |
Group Appointment # | A unique identifier associated with a group appointment. There can be many referrals associated to one group appointment. |
123456
|
Parent Reference # | When a referral is routed or referred again, the originating referral is the Parent. Where a Parent Reference # exists, the referral in question is the Child (or second) referral. If this field is blank, the referral exists as a standalone. This column helps you to find related referrals for the same client. | 9921993008 |
Date/Time Invited | If a referral originates through an invitation, then this field contains the date and time of the invitation. | 2020-06-06 03:15 PM |
Date/Time Submitted | The date and time that a referral originated (was submitted or booked) | 2020-06-08 04:33 PM |
Month Submitted | The month that a referral originated. | Jun, 2020 |
Date/Time of Appointment | If a referral has been booked, then this field contains the date & time of the appointment. | 2020-06-08 03:30 PM |
Month of Appointment | The month of the appointment date. | Jun, 2020 |
Duration (min) | The length of the appointment (if booked). | 15 |
Status | The current state of the referral, either Invited, Submitted, Booked or Closed. | CLOSED |
Sub Status Classification | The defined state of the referral used to better describe the workflow state the referral is currently in. | Completed |
Sub Status | A defined sub-status that can be applied to referrals while in the "Submitted" or "Booked" or "Closed" status. Customizable. | Admitted |
Provider Names | The name of the user who is assigned to the appointment. | Gwen Stevens |
Provider Account Organization | The organization name of the user who is assigned to the appointment. I.e their employer | Organization A |
Service Organization | The organization that provides the service. (In some instances, this column will be blank or display **) | Organization A = sent by Caredove user Blank = Public Sign-up ** = Open Appointment |
Calendar | The calendar in which this service belongs to, within the service organization. | Intake |
Service Option | The Caredove Category & the selected service's given name. | Meals on Wheels: Hot Meal Delivery |
Service Selected | The given name for the service. | Hot Meal Delivery |
Service Selected Category | The Caredove Category for the service. | Meals on Wheels |
Other Services Categories Selected | If other services are selected at the time of the referral, they will be listed here. | Adult Day Program |
Other Services Categories Count | The number of other services requested, displayed numerically. | 0 |
Requester Name | If a referrer notes that they are sending the referral on behalf of someone else (requester) the name of requester will be found here. | Amelie Lepine |
Requester Organization | If a referrer notes that they are sending the referral on behalf of someone else (requester) the name of requester's organization will be found here. | Local Hospital |
Requester Job Title | If a referrer notes that they are sending the referral on behalf of someone else (requester) the job title of the requester will be found here. | Discharge Planner |
Sender Name | Referrer name | Selena Lu |
Sender Organization | Referrer organization | Organization B |
Sender Job Title | Referrer job title | Intake Specialist |
Sender Tags |
| TBD |
Sender IP | IP Address of the referral sender. | 172.18.3.180 |
Location | How the appointment is conducted. Options include: Phone Call to Registrant, Home-Visit, On-Site or custom. | Phone call to registrant |
Sent Via | The method in which the referral is sent. Options include: Online Submission, Fax, Other. | Online Submission |
Primary Outcome | A defined sub-status that can be applied to referrals while in the "Closed" status. Customizable. If blank, the referral is not in the "Closed" status. | Admitted |
Other Outcome Services | Other services requested during referral submission. | Adult Day Program |
Other Outcomes | Selected outcome (closed sub-status) when closing an appointment for an additional service. | Waitlisted |
Date/Time Created | When the appointment (or appointment series) was created by the provider organization. | 2020-06-08 08:59 AM |
Date/Time Completed | Date and Time the outcome was set. If no outcome set, field will be blank. | 2020-06-08 04:34 PM |
Date/Time Recorded | The manually entered date the user sets to override the default submission date (optional) | 2020-06-08 04:33 PM |
Last Updated | The last date/time that the referral was edited/updated | 2020-06-08 04:30 PM |
Source URL | Where the referral originated from (typically a link within Caredove, or WebBuilder) | |
referral-option-code | A referral option that was custom created for this organization (captured during submission/initial booking) | french |
outcome-option-code | An outcome option that was custom created for this organization (captured when updating the referral to a Closed state) | follow-up-required |
Still Have Questions?
Please send us a message, using our Chat box.
