...

1. Download latest stored procedures from github
2. Execute the stored procedures on your database to create the patientnum and encounternumbers
3. Download SyntheticMass Data, Version 2 (24 May, 2017)
4. Set up an i2b2 project with the ACT ontology.
5. Run create_synthea_table_sqlserver.sql in your project to create the Synthea tables.
6. Import the Synthea data you downloaded in step one into the Synthea tables in your project.
7. Load the i2b2-to-SNOMED table in this repository into your project. https://www.nlm.nih.gov/healthit/snomedct/us_edition.html
8. Run synthea_to_i2b2_sqlserver.sql to convert synthea data into i2b2 tables (this will truncate your existing fact and dimension tables!)
   • Replace references to i2b2metadata.dbo in the script. Use the database and schema where your ACT ontology tables are.

ACT Version-4 Ontology data load

...