Workgroup for Cost, Utilization, Economic, Services

Vojtech_Huser · June 15, 2018, 8:19pm

Is there an overview of all the analyses in the 4000+ range in Heracles. Do they make sense on global level? Should they go to Achilles?

Like on this line 11085 (what a beatiful SQL file with many )lines

e.g. analysis 4019

github.com

OHDSI/WebAPI/blob/3e36cd3d0bf88dcd85a5d7fd9ee8e888f02c9004/src/main/resources/resources/cohortanalysis/sql/runHeraclesAnalyses.sql#L11085

    
      
          TRUNCATE TABLE #raw_de_4018;
          DROP TABLE #raw_de_4018;
          
          
TRUNCATE TABLE #raw_de_p_4018;
          DROP TABLE #raw_de_p_4018;
          
          
}
          
          

          
{4019 IN (@list_of_analysis_ids)}?{
          	-- 4019	Distribution of greater than 0 drug quantity per subject by period_id, by drug_concept_id during the cohort period
          
          
with drug_records (cohort_definition_id, subject_id, drug_concept_id, drug_type_concept_id, drug_exposure_date, duration) as
          (
          	select distinct c1.cohort_definition_id,
          		c1.subject_id,
          		de1.drug_concept_id,
          		de1.drug_type_concept_id,
          		de1.drug_exposure_start_date,
              de1.quantity as duration
              from  #HERACLES_cohort c1