Data Export - Insurance Coverage
Coverage
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 insurance coverage span for a patient, with the payer, subscriber number, relationship and the start and end dates the coverage was active. Use it to attach payer information to patients and to see who was covered when.
Example questions this export can answer
- Break caseload or outcomes down by payer
- Find patients with lapsed or missing coverage
- Attach the active payer to a visit or assessment by date
| Property | Name | Field Type | Cardinality | Notes |
|---|---|---|---|---|
| instituteid | Institute Id | identifier | 1..* | |
| instituteShortcode | Institute Shortcode | String | 1..* | |
| id | Id | identifier | 1..1 | |
| patientId | Patient Id | identifier | 1..1 | |
| payorId | Payor Id | string | 1..1 | The EDI payor number |
| payorName | Payor Name | string | 1..1 | |
| payorMirahId | Payor Mirah Id | identifier | 1..1 | The internal identifier of this payor in the Mirah system |
| subscriberNumber | Subscriber Number | string | 1..1 | |
| relationship | Relationship | string | 1..1 | The relationship of this patient to the guarantor - e.g. ‘self’, ‘spouse’ etc |
| startDate | Start Date | date | 0..1 | If known, when coverage started |
| endDate | End Date | date | 00.1 | If known, when coverage ended |