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
Note: highlighted fields are the most commonly used in deeper data analysis.
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. | 2025-06-06 03:15 PM |
Date/Time Submitted | The date and time that a referral originated (was submitted or booked) | 2025-06-08 04:33 PM |
Month Submitted | The month that a referral originated. | Jun, 2025 |
Date/Time of Appointment | If a referral has been booked, then this field contains the date & time of the appointment. | 2025-06-08 03:30 PM |
Month of Appointment | The month of the appointment date. | Jun, 2025 |
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 |
Read Status | Used to identify if the referral has been read or not (0 = unread / 1 = read) | 1 |
Provider Names | The name of the user who is assigned to the appointment/ referral. | 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. | Organization A |
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.
For referrals submitted via an external integration without Single Sign-On, the requester name comes from the external integration partner.
Please find additional details about external integration submission methods 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.
For referrals submitted via an external integration without Single Sign-On, the requester organization comes from the external integration partner.
Please find additional details about external integration submission methods 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.
For referrals submitted via an external integration without Single Sign-On, the requester job title comes from the external integration partner.
Please find additional details about external integration submission methods here. | Discharge Planner |
Sender Name | Referrer name | Selena Lu |
Sender Organization | Referrer organization (In some instances, this column will be blank or display **) | Organization B = sent by Caredove user Blank = Public Sign-up or non-SSO integration submission ** = Open Appointment |
Sender Job Title | Referrer job title | Intake Specialist |
Sender Tags | Referrer permissions user tags at the network level. Options include: Resource Centre, Community Care Coordinator, Hospital, Primary Care, Specialist, Hospital Care Coordinator, Assessment Centre. | Community Care Coordinator |
Sender IP | IP Address of the referral sender. | 172.18.3.180 |
Open Appointment Locations | How the open appointment can be conducted. Options include: Phone Call to Registrant, Home-Visit, Virtual, On-Site, Custom and more. | Phone Call to Registrant |
Booked Appointment Location | How the appointment is conducted. Options include: Phone Call to Registrant, Home-Visit, Virtual, On-Site, Custom and more. | Home-Visit |
Sent Method | The method in which the referral is sent. Options include: "Online Submission", "Direct integration without SSO", "Web launch integration with SSO", "Web launch integration without SSO", "Fax", and "Other".
Please find additional details about external integration submission methods here. | 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. | 2025-06-08 08:59 AM |
Date/Time Completed | Date and Time the outcome was set. If no outcome set, field will be blank. | 2025-06-08 04:34 PM |
Date/Time Recorded | The manually entered date the user sets to override the default submission date (optional) | 2025-06-08 04:33 PM |
Date/Time Last Updated | The last date/time that the referral was edited/updated | 2025-06-08 04:30 PM |
Integration Account | Indicates the name of the integration used to submit the referral, if applicable. | API CHRIS |
Source URL | Where the referral originated from (typically a link within Caredove, or WebBuilder) | |
Referral Options | A referral option that was custom created for this organization (captured during submission/initial booking) | french |
Outcome Options | An outcome option that was custom created for this organization (captured when updating the referral to a Closed state) | follow-up-required |