Flat File Integrations

Overview

The Mirah flat file integration can be used to send patient, provider, scheduling, and other information to the Mirah platform.  This process may be used in circumstances where EHR direct connectivity is unavailable or undesired. The flat file integration procedure involves sending CSV data files via SFTP to a secure server.

Requirements

In order to do a flat file integration you will need to be able to do the following (with technical support from Mirah):

  • Set up an SFTP Connection
  • Send all required data as .csv files to Mirah periodically (at least once a day).

Configuring your SFTP Connection

In order to start sending us data an SFTP connection needs to be set up.  To get your connection set up you will need to do the following steps:

  1. Generate a public and private key.  An easy way to generate your credentials can be found here:  https://docs.github.com/en/authentication/connecting-to-github-with-ssh/generating-a-new-ssh-key-and-adding-it-to-the-ssh-agent#generating-a-new-ssh-key
  2. Send your SFTP public key to support@mirah.com, and in the same email request an SFTP username and set-up of the SFTP configurations on Mirah's side.
  3. Configure your SFTP connection upon confirmation from Mirah, choosing to use your private key as your password option.  The key may need to be reformatted, but most SFTP tools (such as filezilla) will automatically reformat the file.  Additional information you might need includes:
    1. Port:  22
    2. Host:  sftp3.mirah.com
    3. Username:  Provided in the email.
  4. SFTP a .txt file with the line "test" to sftp.mirah.com to confirm we can get data.
  5. Set up a recurring job to generate CSV files and SFTP them to sftp.mirah.com on port 22.  Frequency should be at least daily.
  6. After you send the first batch of files, confirm with Mirah support that they were received and parsed correctly.

Once these steps have been completed we should be able to receive data.  If you are having any issues during this process you should reach out to your CSM and Integration Manager for support.

Sending Data Files to Mirah

Once the SFTP connection has been set up and we have confirmed we can receive files through the SFTP connection we can now start are able to receive your institute data.  These are sent as .csv files, and include the list of files below.

File Type Description Required?
Patients Individuals under care within an institute or their caregivers Yes
Providers Anyone from an institute that manage either patients or that institute's IT Yes
Organizations  How an institute's care plans are broken up, either by physical locations or programs Yes
Appointments Instances of a patient receiving care from a provider within a given organization Yes
Episodes of Care  Series of appointments for a patient No (Optional)
Payers Instances of health care insurance coverages No (Optional)
Insurance Coverage  Health Care plan No (Optional)
Caregiver Individuals who provide oversight for a given patient, such as a guardian No (Optional)
Condition All relevant conditions that patients can be diagnosed with No (Optional)
Patient Condition  Patients with their relevant conditions and their treatment periods No (Optional)

We recommend sending files in the following order:

  1. Organization
  2. Provider
  3. Patient
  4. Caregiver
  5. Condition
  6. Patient Condition
  7. Payers
  8. Insurance Coverage
  9. Episode of Care
  10. Appointment

Once we have received your files our team will validate what has been sent and work with you to update the files as necessary if any discrepancies are found.  When files have been fully validated Mirah will turn on data processing in our systems so that your sent data will begin to show in the Mirah platform.

Additional Concepts

Please contact support@mirah.com for questions or clarifications.  Our goal is to make this process simple and easy for you, so if there’s something that would make your life easier, let us know.

Related Articles