RESULT_DATE in labs cannot be null

ARCH-commons / i2p-transform

i2b2 to PCORnet Common Data Model Transformation - requires i2b2 PCORnet ontology

Other

3 stars 16 forks source link

RESULT_DATE in labs cannot be null #34

Closed jklann closed 7 years ago

jklann commented 7 years ago

Labs table should be changed to not allow empty RESULT_DATES. Then the procedure should conditionally fill in the RESULT_DATE=end_date if available, otherwise start_date.

matthewjoss commented 7 years ago

Fixed in MSSQL

matthewjoss commented 7 years ago

Fixed in Oracle.