[CORE-265] OMOP Data Views: Need to add a view for the Provider table Created: 10/May/17 Updated: 29/Jun/17 Resolved: 13/Jun/17
|Project:||i2b2 Core Software|
|Reporter:||Janice Donahoe||Assignee:||Janice Donahoe|
|Remaining Estimate:||Not Specified|
|Time Spent:||Not Specified|
|Original Estimate:||Not Specified|
|Developer Notes:|| script to create provider_dimension added.
Modifier_dim also added for possible future use.
|Testing Notes:||provider_dimension table has been added to the scripts and everything appears to be working correctly.|
Currently, the timeline is generating an error and this is because it is looking for the provider_dimension table. This table is part of the standard i2b2, the OMOP CDM has its own provider table. For i2b2 on OMOP a provider view needs to be created so any plugins like the timeline will not generate errors looking for the i2b2 provider_dimension table.
This view needs to be created for Oracle, PostgreSQL, and SQLServer databases.
|Comment by Lori Phillips [ 11/May/17 ]|
|Create table statement added for PROVDER_DIMENSION. I also added MODIFIER_DIMENSION for possible future use.|
|Comment by Janice Donahoe [ 13/Jun/17 ]|
|This issue has been fixed and will be included in release 1.7.09.|