To upload a list of MRN’s you must first be in PHI mode. Once in PHI mode, select Upload List Under Cohort Discovery Tool.
Once selected you will be presented with a list of 4 steps. Step 1 includes preparing your data file.
Please note, there are 3 options for preparing your data in excel:
Option 1: If uploading MRN’s only, create a table with 1 column (A).
Label column A MRN
A
MRN
123456788
987654321
123456789
987654320
Option 2: If uploading MRNs, CSNs and Admit Dates, create a table with 3 columns (A, B, C).
Label column A MRN
Label column B CSN
Label column C Admit Date, format dates as YYYY/MM/DD
A
MRN
123456788
987654321
123456789
987654320
B
CSN
1001235678
1000234567
1034567890
C
Admit Date
2013/10/21
2011/01/02
Option 3: If uploading MRNs and Admit Dates only, create a table with 3 columns (A, B, C).
Label column A MRN
Include column B but leave entire column blank, Admit Dates should not be added to column B
Label column C Admit Date, format dates as YYYY/MM/DD
A
MRN
123456788
987654321
123456789
987654320
B
C
Admit Date
2013/10/21
2011/01/02
After preparing the excel file, continue with Steps 2 - 4.
Once the excel file has successfully uploaded, refer to pg. 23 (Creating Output Views) to create the output for your cohort.