Will Achilles Heel queries be updated to reflect the deprecation of DRUG_COST and PROCEDURE_COST tables

Implementers
1

Hello,

In the process of converting the existing Achilles Heel validation queries from SQL Server to Postgresql, I noticed that those statements in the 15xx and 16xx series are no longer valid as they reference the deprecated tables, DRUG_COST and PROCEDURE_COST. Is the script going to be updated to reflect these changes?

Regards,
Vimala

2

Yes. The plan is to definitely update it in the long run.
Thank you for providing user feedback!

Can you please add this problem to the issue list on GitHub.

Also, if you have the SQL skills, you are welcome to contribute the revised SQL code for these. (that would use the new table)
We welcome pull requests to the Achilles GitHub.

I assume all 15xx and 16xx are affected. Is that right?

The current workaround is to use

aResults<-achilles(connectionDetails = connectionDetails,cdmDatabaseSchema = cdmDatabaseSchema,resultsDatabaseSchema = cdmDatabaseSchema,
sourceName = ‘m2’,cdmVersion = ‘5’,runCostAnalysis = F)

(interesting, bold can not be in code block (on this forum markup)