Skip to main content

Data Export - Collaborative Care Case Consultations

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 case consultation completed by the psychiatric consultant for an enrollment, including the case summary, consultation documentation and notes and links to the related tasks and meeting. Use it to review consultation activity and documentation.

Example questions this export can answer​

  • Count consultations completed per enrollment or period
  • Audit that consultation documentation is complete
  • Link consultations back to the requesting provider and meeting
ColumnNameFormatNullableDescriptionNotes
instituteidInstitute Ididentifierfalse
instituteShortcodeInstitute ShortcodeStringfalse
idIDuuidfalseThe Mirah internal identifier of the enrollment
statusStatusenumfalseneeds_summaryawaiting_consult
enrollmentIdEnrollment IduuidfalseThe enrollmentReferences the Enrollment table
patientIdPatientIduuidfalseThe patient idReferences the Patient table
caseSummaryCase SummarystringtrueA summary note prepared by the care manager in advance of the consultation
consultationDocumentationConsultation DocumentationstringtrueClinical Documentation generated during the consultation
consultationNotesConsultation NotesstringtrueNotes from the consultation
caseSummaryTaskIdCase Summary Task IduuidtrueThe id of the task generated to keep track of minutes making the case summaryReferences the Task table
consultMeetingIdConsult Meeting IduuidtrueThe id of the meeting where the consultation was discussedReferences the Consulting Meeting table
consultingMeetingTaskIdConsulting Meeting Task IduuidtrueThe id of the task used to track time for the meetingReferences the Task table
documentationTaskIdDocumentation Task IduuidtrueThe id of the task used for post-consult documentationReferences the Task table
createdAtCreated AtdatetimefalseUsed as the filter criteria