Version 1.8.2 Demo ontology... for the MS SQL version of the I2B2 ontology table... note the 188 'Age at visit' concepts...
In their C_DIMCODE, there are references to this table: 'i2b2demodata.dbo.visit_dimension'.
If this Demo ontology were ever used in a database or schema with a different name, the query could fail because the schema name is hard-coded.
Or, if permissions were shared among different schemas or databases, it could fail silently, providing age at visit for the wrong patient.
Suggestion: remove the 'i2b2demodata.dbo.' identifier, and leave just the 'visit_dimension' table name.
Version 1.8.2 Demo ontology... for the MS SQL version of the I2B2 ontology table... note the 188 'Age at visit' concepts...
In their C_DIMCODE, there are references to this table: 'i2b2demodata.dbo.visit_dimension'.
If this Demo ontology were ever used in a database or schema with a different name, the query could fail because the schema name is hard-coded.
Or, if permissions were shared among different schemas or databases, it could fail silently, providing age at visit for the wrong patient.
Suggestion: remove the 'i2b2demodata.dbo.' identifier, and leave just the 'visit_dimension' table name.