Skip to main content

Data Export - Collaborative Care Consult Request

Generated by the Bulk Data Export system

The order of columns is subject to change. When parsing files, please ensure to use headers rather than positional parsing to ensure you are reading the data correctly.

What this export contains​

One row per provider request for a psychiatric case consultation, with the reason, free text and request date. Details of the consultation itself live on the Case Consultation referenced by the case consult id. Use it to track demand for and responsiveness to consults.

Example questions this export can answer​

  • Measure how many consults are requested and why
  • Track time from request to consultation
  • See which providers are requesting consults
ColumnNameFormatNullableDescriptionNotes
instituteidInstitute Ididentifierfalse
instituteShortcodeInstitute ShortcodeStringfalse
idIDuuidfalseThe mirah internal identifier
caseConsultIdCase Consult IduuidfalseThe id of the consulation this time entry is associated with
providerIdProvider Iduuidfalse
requestDateRequest Datedatetimefalse
requestReasonRequest Reasondischarge | increased_measure_severitychange_of_treatment_planlack_of_clinical_improvementdiagnostic_claritymedication_side_effectnew_informationsdohmedical_complicationsmedication_management_questionquick_winotherfalseThe reason for consult as selected from the dropdown
requestTextRequest TextstringtrueAny extra text detailing the request for consultation