Data Export - Collaborative Care Time Entry Logs
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 block of time a provider logged against a Collaborative Care task, with billable minutes, duration and start and end times. Several providers can log time against a single task. This is the source of minutes for CoCM time-based billing.
Example questions this export can answer
- Total billable minutes per patient per month for CoCM billing
- See how care-manager and consultant time is distributed
- Reconcile logged time against the CoCM billing export
| Column | Name | Format | Nullable | Description | Notes |
|---|---|---|---|---|---|
| instituteid | Institute Id | identifier | false | ||
| instituteShortcode | Institute Shortcode | String | false | ||
| id | ID | uuid | false | The Mirah internal identifier | |
| taskId | Task Id | uuid | false | The id of the task this time entry is associated with | |
| billableMinutes | Billable Minutes | integer | false | The number of minutes for this task expected to be billable, i.e. not overlapping with another task for the provider and not being clerical in nature | It is possible for only some of the minutes spent to be billable - for example if the provider has another task overlapping in time. |
| duration | Duration | interval | true | Uses | Will be null if the entry has not been completed. |
| startTime | Start Time | DateTime | false | The date time when the time tracking for this log started | |
| endTime | End Time | DateTime | true | The date time when the time tracking for this log ended | |
| providerId | Provider Id | uuid | false | The id of the provider billing the time |