UNMCCC / CRIIS_Source_Extracts_for_OMOP

Cancer Clinical Data integration - Set of SQL extractions from disparate health system sources targeting the OMOP data model
MIT License
0 stars 0 forks source link

CNExT: obs-period incremental #190

Closed isangil closed 2 years ago

isangil commented 2 years ago

tweak extract to account for deltas

isangil commented 2 years ago

so, add records within 5x of last edit of the modified date. in this case, we extract 5 weeks from today into the past, compare to moddttm -- perhaps in the where stat .. `DECLARE @incDate = dateadd (week, -5, getdate()); DECLARE @AllDates = '2010-01-01'

CASE $param (is increment or is all) @fromDate = either incDate or AllDates

HExt.F00084 >= @fromDate`

isangil commented 2 years ago

done with #191 - will leave issue open for a couple of days to use this as template @lvarnedoe