search

ARCH-commons / i2p-transform

i2b2 to PCORnet Common Data Model Transformation - requires i2b2 PCORnet ontology
Other
3 stars 16 forks source link

PCORnet DCQ does not produce charts #76

Closed jklann closed 6 years ago

jklann commented 6 years ago

The PCORnet DCQ does not produce charts. We have been told this is due to an invalid date in the Harvest table and we will push a fix as soon as we have clarification on this.

jklann commented 6 years ago

Three-pronged Harvest-table cleanup should fix this:

  1. Wrap all the REFRESH*DATE fields in datepart in SQL2SAS
  2. Make all the null REFRESH*DATE fields getdate() in the transform
  3. Make the empty date management columns ‘01’ in the transform

Push coming soon!

jklann commented 6 years ago

Fixed in f3788caf0d9110833b1dba71dda8678e53384e5f and 30b6125e2ac3509ab06dba67f572dc55163c7803 and verified