ARCH-commons / i2p-transform

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

orphan providerids aren't legal #69

Closed jklann closed 6 years ago

jklann commented 6 years ago

Getting DCQ error: "Orphan PROVIDERID(S) in the ENCOUNTER, DIAGNOSIS,MED_ADMIN, OBS_CLIN, PRESCRIBING, or PROCEDURES table."

Will need to write a script to fill in the provider table.

jklann commented 6 years ago

Commit b50477009960f4c0040b44e96937e59a3e464d20 fixes this in MSSQL, though DCQ has not been rerun to verify it passes the check. Needs to be propagated to Oracle.

jklann commented 6 years ago

Matt fixed in Oracle ab92d093d3d8cfde4112b32acf1eb50b76a5cc7f