OHDSI / Achilles

Automated Characterization of Health Information at Large-scale Longitudinal Evidence Systems (ACHILLES) - descriptive statistics about a OMOP CDM database
https://ohdsi.github.io/Achilles/
130 stars 121 forks source link

heel rule for PROCEDURE_OCCURRENCE convention 10 #375

Closed vojtechhuser closed 3 years ago

vojtechhuser commented 5 years ago

for PROCEDURE_OCCURRENCE this SQL should a count of 0 rows with quantity of 0

select count(*) as cnt from procedure_occurrence where quantity=0

Help from Ajit is solicited to put this as SQL-logic based rule @alondhe

per this themis issue https://github.com/OHDSI/Themis/issues/26

fdefalco commented 3 years ago

Heel has been superseded by DQD.