Skip to main content
Data Slice Exports

Detailed explanations of the fields found for Data Slice Exports

Updated over 5 years ago

We have converted our native "Data Slice Exports" to our Analytics engine for a more user friendly experience. These include exports on the following areas in the platform:

  • Appointments

  • Cases

  • Encounters

  • Patients

  • Patient Data

  • Practitioners

Appointments

The "Appointments" report includes the following fields:

  • Appointment ID: use to jump into the patient chart

  • Created From Public (Yes/No): was this appointment requested online by a patient

  • Cancelled (Yes/No): appointment has the status of "cancelled" or an appointment requested by the patient was "rejected"

  • Cancelled Time: when the appointment's status was changed "cancelled" or when an appointment requested by the patient was "rejected"

  • Checked In Time: when the appointment's status was changed to "arrived"

  • Group Visit ID: if this appointment was a "Group Visit" type

  • Location ID: the ID associated with the appointment's location

  • Location Name: the name of the location the appointment was booked under

  • Practitioner ID: user ID of the person the appointment is booked with

  • Practitioner: the user the appointment was booked under

  • Appointment Type ID: the ID associated with the appointment type of the appointment

  • Appointment Type: name of the associated appointment type

  • Presenting Issue ID: the ID associated with the linked templated "presenting issue"

  • Presenting Issue: the linked templated "presenting issue" if applicable

  • Reason: the "presenting issue" associated with the Appointment or linked Encounter note

  • Note: free text found in the appointment “note” section

  • Referring Practitioner: referring doctor listed in the patient's chart

  • Patient ID: use to jump into the patient chart

  • Room ID: ID associated with the room the appointment was assigned to

  • Room: name associated with the room the appointment was assigned to

  • Created Time: time the appointment was created

  • Start Time: time the appointment was scheduled for

  • Until Time: time the appointment was scheduled to end at

  • Status: appointment status currently assigned to the appointment

  • Updated Time: last time the appointment was updated

  • Virtual Encounter ID: if the appointment was linked to virtual encounter

  • Visit Type: either "physical or virtual"

The "Appointment Types" report includes the following fields:

  • ID: ID associated with the Appointment Type

  • Created Time: time the Appointment Type was created

  • Active (Yes/No): is the Appointment Type currently in your settings or has it been deleted

  • Long Description: long description free text associated with the Appointment Type settings

  • Short Description: short description free text associated with the Appointment Type settings

  • Name: name of the Appointment Type

  • Require Primary Practitioner (Yes/No): when a patient goes to request an appointment online for this Appointment Type does the request need to be with their primary practitioner assigned in their chart

  • Slot Length: the templated amount of time in minutes associated with the Appointment Type

  • Updated Time: the last time the Appointment Type settings were updated

Cases

The "Cases" report includes the following fields:

  • Case ID: ID associated with the individual case

  • Case Template ID: ID associated with the case template

  • Template Name: name of the template applied to the case

  • Assigned Provider ID: ID associated with the user "assigned" to the case

  • Assigned Practitioner: name of the user "assigned" to the case

  • Case Number: unique number assigned to the case

  • Created Time: time the case was created

  • Closed Time: time the case was closed

  • Closed Provider User ID: ID associated with the user that "closed" the case

  • Closed Provider: name of the user that "closed" the case

  • Issue: free text for the reason of the case

  • Opened Time: time the case was "opened"

  • Reported Closed Time: time the case was "reported closed"

  • Patient ID: unique ID assigned to the patient associated with the case

  • Case Status: whether the case is "open" or "closed"

  • Updated Time: the last time the case was updated

Encounters

The "Encounters" report includes the following fields:

  • Encounter ID: ID associated with the encounter note

  • Created Time: time the encounter note was created

  • Created Provider User ID: ID associated with the user that created the encounter note

  • Created Provider User: name of the user that created the encounter

  • Concern: title of the encounter note, can be free text or linked to a presenting issue

  • Appointment ID: ID of the linked appointment if applicable

  • History: text found in the "history" section of the note

  • Physical Exam Data: data found in the "vitals" tab of the "Examination" section of the note

  • Physical Exam: text found in the "examination" section of the note

  • Assessment and Plan: text found in the "assessment and plan" section of the note

  • Locked (Yes/No): whether or not the encounter note has been signed

  • Locked Time: time the encounter note was signed

  • Locked Provider User ID: ID associated with the user that signed the encounter

  • Signed By: the name of the user that signed the encounter

  • Prescriptions Data: data associated with any prescriptions that were created directly from the encounter note

  • Presenting Issue ID: ID associated with the presenting issue template linked to the encounter note

  • Presenting Issue: name of the presenting issue template linked to the encounter 

  • Respondent Case ID: ID of the case linked to the encounter note

  • Patient ID: unique ID associated with the patient the encounter note is associated with

  • Seen Time: either the created time of the encounter or the linked appointment start time

  • Signature ID: unique ID associated with the signature on the signed note

  • Signed Provider User Data: the ID, title, name, and license number of the user that signed the note

  • Updated Time: last time the note was updated

Patients

The "Patients" report includes the following fields:

  • ID: unique patient ID, use this jump into the patient chart

  • Created Date: date the patient was created

  • Full Name: full name of the patient

  • PHIN: primary identification number

  • Gender: gender of the patient

  • Date of Birth: date of birth of the patient

  • Primary Practitioner: primary practitioner assigned in the patient's chart

  • Phone: cell phone number entered in the patient's chart

  • Email: email entered in the patient's chart

  • Notify By: notification method set in the patient's chart, either email, SMS, both or none

  • City: city entered in the patient's address section in their chart

  • Family Doctor: contact assigned in the family doctor section of the patient's chart

  • Referring Doctor: contact assigned in the referring doctor section of the patient's chart

Patient Data

The "Patients" report includes the following fields:

  • Patients ID: unique patient ID, use this jump into the patient chart

  • Primary Identification Name: name of the primary identification assigned to the patient's chart (ex. MSP, OHIP)

  • Primary Identification Value: value of the primary identification assigned to the patient's chart (ex. MSP, OHIP)

  • Gender: gender of the patient

  • Referring Practitioner Title: title of the contact assigned to the patient's referring doctor section in their chart

  • Referring Practitioner First Name: first name of the contact assigned to the patient's referring doctor section in their chart

  • Referring Practitioner Last Name: last name of the contact assigned to the patient's referring doctor section in their chart

  • Referring Practitioner Billing Code: billing code of the contact assigned to the patient's referring doctor section in their chart

  • Referring Practitioner License Number: license number of the contact assigned to the patient's referring doctor section in their chart

  • Date of Birth: date of birth of the patient

  • Patient First Name: patient's first name

  • Patient Preferred Name: patient's preferred name

  • Patient Last Name: patient's last name

  • Notify By: notification method set in the patient's chart, either email, SMS, both or none

  • Searchable Name: directory path of the patient data (Category|Property|Entity)

  • Value: the most recent value for that searchable name in the occurred date (when entered) range set in the filter

Practitioners

The "Practitioners" report includes the following fields:

  • Practitioner ID: unique ID associated with the user

  • Deactivated (Yes/No): whether the user has been deactivated or not

  • Billing Number: billing number assigned to that user

  • Created Time: time the user was created

  • Last Sign In Time: last time the user signed into the platform

  • Email: email associated with the user, used to log into the platform

  • Title: title of the user

  • Full Name: full name of the user

  • Position: position associated with the user

  • Has Inbox (Yes/No): user has an inbox in the platform

  • Has Schedule (Yes/No): user has the ability to own a schedule in the platform

  • License Number: licence number assigned to that user

  • Phone Number: phone number assigned to that user

  • Sign In Count: count of how many times a user has signed into the platform

  • Two Factor Enabled (Yes/No): does the user have two factor security enabled for their account

Learn more about how to use our Analytics module

Did this answer your question?