Open Zachary-Higgins opened 3 months ago
It also generated the following incorrect column reference:
[UNRESOLVED_COLUMN.WITH_SUGGESTION] A column, variable, or function parameter with name admitting_source_concept_id
cannot be resolved. Did you mean one of the following? [visit_source_concept_id
, admitted_from_concept_id
, visit_type_concept_id
, discharged_to_concept_id
, visit_concept_id
].; line 65 pos 197
Assuming admitting_source_concept_id should actually be admitted_from_concept_id.
Should we create a new issue for each or keep a list here?
Hi - We're setting up Achilles to run on top of our delta lake through Databricks. I was having issues running the analysis through R, so I generated the SQL scripts and copied them over to Databricks. The generated script failed to complete when referencing the discharge_to_concept_id field because it was missing. In actuality, it looks like it changed from discharge to discharged.
https://ohdsi.github.io/CommonDataModel/cdm54.html#visit_occurrence
We're using OMOP CDM 5.4.1. It looks like this issue was reported last year in May, but has been closed and is still present. https://github.com/OHDSI/Achilles/issues/702
Here's the r script we used to generate the queries. I think it's pretty standard....
And an example of the incorrect column reference in the generated SQL.