Creating and Exporting Applicant Data from ERAS

IMPORTANT: If you are using CORTEX to review and select applicants for interviews, please first review these two guides to review instructions: Bulk Printing ERAS Applications - Exporting from ERAS to Cortex, Uploading Applications into Cortex and Cortex Supplemental Application Support.  After you import your Cortex files to Thalamus, you can then go back and rerun a CSV from to ERAS to fill in any additional fields listed below.  

DO NOT UPLOAD A CSV TO CORTEX

In order to upload your applicant data into Thalamus, you will need to create and export a CSV file from ERAS. This article describes the process for creating and exporting a CSV file from ERAS. If you require additional assistance, please contact the ERAS customer support team. 

  1. Sign in to the ERAS system using your assigned username and password.mceclip1.png
  2. You will be brought to the Dashboard, which will display the following at the Upper Left-Hand Corner: “’Hospital Name’ → ‘All Groups’ → ‘Specialty.’”
  3. As you review your applicants, select the "Selected to Interview" box if you would like to invite them
  4. Filter your applicants by "Selected to Interview"
  5. Select the “Applications Tab” at the top of the screen
  6. In the sub-menu directly beneath, click “Manage Filters."
  7. Star “Selected to Interview” by searching for it in the “System-Defined” list, or if you have already made it a “User-Defined” or “Favorite,” you may click on “Selected to Interview” from those lists respectively.

mceclip3.png

You may also click on the “Selected to Interview” filter on your Dashboard (if previously made one of your favorites) and appearing in the “Favorite Filters” box (see above graphic).

8.  Click on the “Selected to Interview” filter through any of the methods described above.

9.  A list of applicants will appear. Select all applicants on this list by checking the box in the upper left-hand corner adjacent to “Applicant Name.” Check marks will appear next to all selected applicants’ names and all rows will turn blue.

10.  In the “Select a bulk action” drop down menu in the lower right-hand corner of the screen, select “CSV export.” Click "Go". 

mceclip4.png

11.  A “CSV Templates” menu will appear with some predefined templates. Select “Edit CSV Exports”. 
This will bring up a page called “Exports”

mceclip5.png

12.  In the Exports screen, click the green plus sign in the upper left-hand corner, adjacent to “Add a new export template.”

mceclip6.png

13. Fill in the box “CSV Export Name,” with a suitable title for this CSV file.

Important:  You will now be able to choose the fields you wish to include in your CSV exports.  Your program has the ability to choose what information it wishes to export out of ERAS and upload into Thalamus.  The 5 following fields are required when uploading into Thalamus: 

  • “AAMC ID”
  • “E-mail”
  • “First Name”
  • “Last Name”

"AAMC ID" should always be for your first selection. This will result in a smoother data export from ERAS. 

Thalamus currently supports the following 44 data fields when exporting from ERAS. We recommend you use all available data fields, as it will maximize the user experience for both your program, and your applicants. 

Personal: (Fields in blue are mandatory)

  • AAMC ID
  • E-Mail
  • First Name
  • Last Name
  • Sex or Gender (either is acceptable) * data on your CSV must reflect "Man", "Woman" or "Another Gender Identity" or "Decline to Answer" in order to be imported. 
  • Preferred Name
  • Preferred Pronouns
  • Preferred Phone
  • Cell Phone #
  • Date of Birth
  • Hobbies and Interests
  • Alpha Omega Alpha
  • Alpha Omega Alpha (Yes/No)
  • Contact Address 1
  • Contact Address 2
  • Contact City
  • Contact Country
  • Contact State
  • Contact Zip
  • Birth Place
  • Citizenship
  • USMLE ID
  • NRMP ID
  • Gold Humanism Honor Society
  • Gold Humanism Honor Society (Yes/No)
  • Self Identify
  • Permanent Country
  • Graduate of US or Canadian Medical School
  • Current Visa Status (now Visa Sponsorship Needed
  • Participating as a Couple in NRMP
  • Couples - Partner Name
  • Couples - Partner Specialty
  • Authorized to Work in the US
  • Basis for Work Authorization
  • Military Branch

Education:

  • Medical School of Graduation
  • Medical School Country
  • Medical School Type
  • Medical Degree
  • Higher Education Degree
  • Explanation of why Medical Education or Training Interrupted
  • Medical Degree Expected or Earned
  • Medical Education or Training Interrupted
  • Medical School Attendance Dates
  • Medical School Clinical Campus
  • Medical School State/Province
  • Medical School Degree Date of Graduation

Exams/Licenses/Certifications:

  • USMLE Step 1 Score
  • USMLE Step 2 CK Score
  • USMLE Step 2 CS Score
  • USMLE Step 3 Score
  • COMLEX-USA Level 1 Score
  • COMLEX-USA Level 2 CE Score
  • COMLEX-USA Level 2 PE Score
  • COMLEX-USA Level 3 Score

Experience:

  • Medical Training Program
  • Medical Training Discipline
  • Medical Training Type
  • Medical Training State
  • Medical Training Start Date
  • Medical Training End Date

Supplemental Application:

  • Preference Signal

  • Division Preference

  • Division Preference Description

  • Setting Preference

  • Setting Preference Description

  • Meaningful Experiences

  • Other Impactful Experiences

We will continue to add additional fields to best support our users’ needs.  To request the inclusion of additional data fields in Thalamus,  please contact our technical support by clicking on the “?” at the bottom right-hand corner of any Thalamus page.

14. Make sure the “Type of data to export” box, contains the title “Personal.” Below it, you will find two boxes, one labeled “Available Fields” and another labeled “Fields to Export.”  

15. In the “Available Fields” box locate the value “AAMC ID,” click on this value. The “AAMC ID” field will become highlighted in blue.

mceclip7.png

16. Click the → arrow to move the value into the “Fields to Export” box.

17. Repeat this step to include all mandatory fields and the remaining data fields in this category listed above. You will be able to review any fields selected will be listed in the “Fields to Export” box.  

mceclip8.png

18. Click the down arrow in the box labeled “Type of data to export,” click on “Education” in that list to select that value. From the “Available Fields” box click on “Medical School of Graduation”, which will be highlighted in blue. Click the → arrow to move the value into the “Fields to Export” box.  Repeat this step to include the remaining fields listed in this category above.

19. Click the down arrow in the box labeled “Type of data to export,” click on “Exams/Licenses/Certifications” from this list. Click on the “USMLE Step 1 Score” so that it is highlighted in blue. Click the → arrow to move the value into the “Fields to Export” box.  Repeat this process for the remaining fields listed in this category above. 

20. By the time you complete this step, all forty-four (44) fields should be listed in the “Fields to Export” box. Review this list to ensure that all mandatory and desired fields have been selected. 

21. Once your selection is reviewed and confirmed, click on the green “Save & Run” button at the bottom right of the page.

22. A “Print Request” box will appear with the message “Your CSV report was scheduled.”

mceclip9.png

23. You may then download/export your CSV file to your computer. Your newly created file will appear in the “CSV Export” box at the lower right corner. 

24. Click the blue “complete” button.  The CSV file will download and appear at the bottom of your screen.

  mceclip10.png

25. Click the file to open it in Microsoft Excel or a similar spreadsheet program.

26. Save the file to your computer (we recommend saving to your desktop). 

Note: Do not change any of the structure of this file or edit this file in any capacity. 

Note: Your file is then ready to be uploaded into our system (See “Uploading Applicants to Thalamus from ERAS” for further instructions regarding uploading applicants).

 

Was this article helpful?
0 out of 0 found this helpful