OHDSI/ETL-Synthea

Synthea version not used in all SQL scripts

Closed this issue · 0 comments

Some of the .sql scripts take the Synthea version as input and select data depending on the version.

This is e.g. relevant for the date column in version 2.7.0 that seems to be renamed to start.

insert_procedure_occurence.sql uses the version:

{@synthea_version == "master"} ? {
pr.start                                 procedure_date,
pr.start                                 procedure_datetime,
} 

{@synthea_version == "2.7.0"} ? {
pr.date                                  procedure_date,
pr.date                                  procedure_datetime,
} 

But most other SQL scripts don't use the version. They use the start column by default.