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
| Column | Name | Format | Nullable | Description | Notes |
|---|---|---|---|---|---|
| instituteid | Institute Id | identifier | false | ||
| instituteShortcode | Institute Shortcode | String | false | ||
| id | ID | uuid | false | The Mirah internal identifier of the enrollment | |
| status | Status | enum | false | needs_summary | awaiting_consult |
| enrollmentId | Enrollment Id | uuid | false | The enrollment | References the Enrollment table |
| patientId | PatientId | uuid | false | The patient id | References the Patient table |
| caseSummary | Case Summary | string | true | A summary note prepared by the care manager in advance of the consultation | |
| consultationDocumentation | Consultation Documentation | string | true | Clinical Documentation generated during the consultation | |
| consultationNotes | Consultation Notes | string | true | Notes from the consultation | |
| caseSummaryTaskId | Case Summary Task Id | uuid | true | The id of the task generated to keep track of minutes making the case summary | References the Task table |
| consultMeetingId | Consult Meeting Id | uuid | true | The id of the meeting where the consultation was discussed | References the Consulting Meeting table |
| consultingMeetingTaskId | Consulting Meeting Task Id | uuid | true | The id of the task used to track time for the meeting | References the Task table |
| documentationTaskId | Documentation Task Id | uuid | true | The id of the task used for post-consult documentation | References the Task table |
| createdAt | Created At | datetime | false | Used as the filter criteria |