search

National-COVID-Cohort-Collaborative / Phenotype_Data_Acquisition

The repository for code and documentation produced by the N3C Phenotype and Data Acquisition workstream
60 stars 35 forks source link

fix for #234 #235

Closed MPagel closed 6 months ago

MPagel commented 7 months ago

moved AND (p.OBSERVATION_PERIOD_START_DATE >= TO_DATE(TO_CHAR(2018,'0000')||'-'||TO_CHAR(01,'00')||'-'||TO_CHAR(01,'00'), 'YYYY-MM-DD') OR p.OBSERVATION_PERIOD_END_DATE >= TO_DATE(TO_CHAR(2018,'0000')||'-'||TO_CHAR(01,'00')||'-'||TO_CHAR(01,'00'), 'YYYY-MM-DD'));

from person to observationPeriod. This should be consistent with lines 188-219 in postgres version of script

https://github.com/National-COVID-Cohort-Collaborative/Phenotype_Data_Acquisition/blob/59b9b32363fba815071df497a295de897200f3ad/ExtractScripts/N3C_extract_omop_postgres.sql#L188