search

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: Implement framework for incremental extracts #72

Open isangil opened 2 years ago

isangil commented 2 years ago

F00084 is updated on any saved change to any data element within a case.

Probably the simplest (and perhaps only reliable) field for tracking changes is our Date Case Last Changed [HospExtended.F00084]. It is not a timestamp in the traditional sense. This field is formatted CCYYMMDD and is updated on any change to any element of a case tuple. A warehousing system could scan this date value, compare to existing data, and update accordingly.

isangil commented 2 years ago

in progress, need non-clinical data sets