Potentially join on date instead of datetime for condition costs

OHDSI / dbt-synthea

[Under development] A dbt ETL project to convert a Synthea synthetic data set into the OMOP CDM

https://ohdsi.github.io/dbt-synthea/

Apache License 2.0

16 stars 6 forks source link

Potentially join on date instead of datetime for condition costs #74

Open katy-sadowski opened 1 month ago

katy-sadowski commented 1 month ago

https://github.com/OHDSI/dbt-synthea/blob/ae791145d50c9e0693880ff9ed37d60f7cc0195d/models/intermediate/int__cost_condition.sql#L44

ETL-Synthea truncates datetimes to dates, so not an issue there. It's possible it doesn't make sense to join on a timestamp. Need to look in the data to confirm.