Supporting Analytics in eReferral eForms

The Ocean eReferral platform de-identifies data automatically to provide you with an understanding of referral patterns, decline rates, wait times, etc. You can export this data at anytime from the "Reports" section of the Admin tab. For more details on exporting eReferral analytics, please refer to this article.

Core Analytics

The core set of analytics captured in the de-identified record are in the table below.

Column Header Description
referralRef The unique reference number for the referral in Ocean.
patientId A one-way hashed value representing the patient identity.
initialHealthService The health service on the referral at time of send.
currentHealthService The health service on the referral currently.
claimedWaitTimeDaysLow The lower end of the range of wait times claimed in the health service listing when the referral was sent (e.g. 7, if 1-2 weeks). This will be wait 1 for health services with multiple health services.
claimedWaitTimeDaysHigh The higher end of the range of wait times claimed in the health service listing when the referral was sent (e.g. 14, if 1-2 weeks). This will be wait 1 for health services with multiple health services.
claimedWaitTime2DaysLow  The lower end of the range of wait 2 times claimed in the health service listing when the referral was sent (e.g. 7, if 1-2 weeks).
claimedWaitTime2DaysHigh  The higher end of the range of wait 2 times claimed in the health service listing when the referral was sent (e.g. 14, if 1-2 weeks).
waitTime  The actual wait time, as calculated between the date the referral was created to the first appointment date.
waitTime2 The actual wait time, as calculated between the date the referral was created to the second appointment date.
referrerName The name of the referrer (i.e. clinician).
referrerClinicianType
 The referrer clinician type.  One "Allied Health Professional",
"Family Physician","Medical Student","MOA / Secretary",
"Nurse","Nurse Practitioner","Resident","Specialist" or "Other".
referrerUrgency The urgency of the referral, as taken from the referral form item with the EMRField mapping of "referralUrgency".

srcSiteName

The name of the source referral site.
initialRecipientName The name of the original referral target on the referral.
recipientName The name of the current referral target on the referral (this can change if the referral is forwarded from central intake to a specialist, for example.)
recipientCity The city of the recipient.
recipientProvince The province of the recipient.
recipientPostalCode The postal code of the recipient.
recipientPriority  The priority as indicated by the recipient via the review form (specifically the item with reference "priority"). Limited to P1, P2, P3, P4, P4F, P5.
recipientLatitude The latitude of the recipient.
recipientLongitude The longitude of the recipient.
patientAge The age of the patient.
patientGender The gender of the patient.
patientCity The patient's home city.
patientProvince The patient's home province.
patientPostalFirst3Chars The first 3 characters of the patient's postal code.
patientDistanceKm  The distance, in km, between the patient's home and the referral target.
referralState  The status of the referral. One of PRINTED,
SENT, ACCEPTED, DECLINED, AWAITING_REPLY, BOOKED, CANCELED,SEEN, or FINISHED.
scheduledAppointment  The date/time set for the first appointment.
scheduledAppointment2  The date/time set for the second appointment.
booked Whether the referral appointment has been booked.
seen Whether the patient has been seen (i.e. in the clinic for a consult).
completed Whether the referral has been marked completed (i.e. generally means referral has been completed and consult letter, if appropriate, will be forthcoming.)
reasonForDecline

The reason for a declined referral. One of:

UNABLE_TO_CONTACT, MISSING_INFORMATION,
ADDITIONAL_WORKUP_REQUIRED, INAPPROPRIATE_INDICATION, SENT_TO_WRONG_PROVIDER, RECOMMEND_OTHER_PROVIDER, SERVICE_NOT_AVAILABLE, PRECLUDED_DUE_TO_PATIENT_ISSUE, CANNOT_BE_SEEN_QUICKLY_ENOUGH, UNLIKELY_TO_BENEFIT, NOT_YET_DUE, OTHER

creationDate  The date/time the referral was created (in ISO 8601 format)
modificationDate  The date/time the referral was most recently updated (in ISO 8601 format)
 

Additional Available Analytics

In addition, you can map fields in your referral form and Review form to set analytics values for your referral exports. Keep in mind that the semantics behind each is arbitrary and you can "co-opt" them for the purposes of a particular pathway as long as the consumers of the analytical data understand the data values. To do add these analytics values, simply open your form in the eForm Editor and set the item reference to one of the following values.

Item Reference
ax_preciseAge
ax_reasonForReferral
ax_diagnosis
ax_diagnosisAcuity (e.g. undiagnosed high risk; newly diagnosed; established)
ax_aboriginalStatus
ax_gestationalAge
ax_languageBarrier
ax_language
ax_comorbidities
ax_pcpName
ax_socialDeterminants 
ax_imagingStatus
ax_lab_hb
ax_lab_a1c
ax_lab_fbs
ax_lab_glucoseT1Hr
ax_lab_glucoseT2Hr
ax_lab_chol
ax_lab_cholHdlRatio
ax_lab_hdl 
ax_lab_ldl
ax_lab_tg
ax_lab_egfr
ax_lab_cr
ax_v_bp
ax_v_ht 
ax_v_wt 
ax_v_bmi
ax_cm_arthritis 
ax_cm_asthma 
ax_cm_chf 
ax_cm_cvd 
ax_cm_dm 
ax_cm_obesity 
ax_cm_osteoporosis 
ax_cm_copd 
ax_cm_pad 
ax_cm_tiaStroke
ax_cm_retinopathy 
ax_cm_nephropathy 
ax_cm_footUlcer 
ax_cm_mentalHealth 
ax_cm_htn
ax_alcohol_dpw
ax_tobacco_cigsPerDay
ax_tobacco_everSmoked
ax_drugUse_mj
ax_request_preConceptionCounseling
ax_request_footCareEducation
ax_request_additionalEducation
ax_request_renalCriteria
ax_request_mentalHealth
ax_preferredClinician
ax_preferredCity
ax_secondOpinion
ax_cause
ax_severity1
ax_severity2
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request