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
| Column | Name | Format | Nullable | Description | Notes | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| instituteid | Institute Id | identifier | false | |||||||||||
| instituteShortcode | Institute Shortcode | String | false | |||||||||||
| id | ID | uuid | false | The mirah internal identifier | ||||||||||
| caseConsultId | Case Consult Id | uuid | false | The id of the consulation this time entry is associated with | ||||||||||
| providerId | Provider Id | uuid | false | |||||||||||
| requestDate | Request Date | datetime | false | |||||||||||
| requestReason | Request Reason | discharge | increased_measure_severity | change_of_treatment_plan | lack_of_clinical_improvement | diagnostic_clarity | medication_side_effect | new_information | sdoh | medical_complications | medication_management_question | quick_win | other | false | The reason for consult as selected from the dropdown |
| requestText | Request Text | string | true | Any extra text detailing the request for consultation |