search

ARCH-commons / i2p-transform

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

Minor issues in SQL2SAS in unused tables #77

Open jklann opened 6 years ago

jklann commented 6 years ago

Reported by @ctsb --

  1. MEDADMIN_START_DATE, MEDADMIN_STOP_DATE, OBSCLIN_DATE, OBSGEN_DATE, these date should also be change to DATEPART( XXXXXX_DATE ) AS XXXXXX_DATE format date9., otherwise it will cause “future date” error.
  2. MEDADMINID, OBSCLINID needs change to PUT(XXXXXID ,32.) AS XXXXXXID, it would cause error 'Required character field is numeric'

These don't appear to be causing DCQ errors so not marking as high-priority.