Era tables, most recent version

Nick_Williams · July 13, 2021, 11:36pm

We (@Vojtech_Huser) are producing an ETL to consume Medicaid data and produce a CDM. We are looking for the most recent version of code to produce era tables from clinical tables.

Thoughts?

I have several versions to consider:

github.com

OHDSI/CommonDataModel/blob/master/CodeExcerpts/DerivedTables/GenerateEra.sql#L228

    
      
          
          

          

          

          

          

          

          

          
/****
          
          
CONDITION ERA
          Note: Eras derived from CONDITION_OCCURRENCE table, using 30d gap
          
          
 ****/
          IF OBJECT_ID('tempdb..#condition_era_phase_1', 'U') IS NOT NULL
          	DROP TABLE #condition_era_phase_1;
          
          
/* / */
          
          
IF OBJECT_ID('tempdb..#cteConditionTarget', 'U') IS NOT NULL
          	DROP TABLE #cteConditionTarget;