Skip to main content

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
PropertyNameField TypeCardinalityNotes
instituteidInstitute Ididentifier1..*
instituteShortcodeInstitute ShortcodeString1..*
idIdidentifier1..1
patientIdPatient Ididentifier1..1
payorIdPayor Idstring1..1The EDI payor number
payorNamePayor Namestring1..1
payorMirahIdPayor Mirah Ididentifier1..1The internal identifier of this payor in the Mirah system
subscriberNumberSubscriber Numberstring1..1
relationshipRelationshipstring1..1The relationship of this patient to the guarantor - e.g. ‘self’, ‘spouse’ etc
startDateStart Datedate0..1If known, when coverage started
endDateEnd Datedate00.1If known, when coverage ended