2 Replies Latest reply on Mar 18, 2013 8:57 AM by annette.hatch

    Looking for patients with multiple accounts with one MRN

    annette.hatch

      I am trying to identify patients whose medical record numbers have more than one account attached to them.  I then need to match the discharge date and the admit day for accounts within that medical record number so that I can see which patients were discharged from the Main Hospital and checked into Rehab.  Any thoughts?

       

      I am including an Excel spreadsheet that has two tables as examples of data I am trying to sort.

      (I don't think I can download the patient table twice and join them by MRN because the actual source file is enormous.)

       

      Thank you for any help you are able to provide,

      Annette